SalarDbCodeGenerator.DbProject.ProjectDbSettions.GetNewConnection C# (CSharp) Method

        public DbConnection GetNewConnection()
        {
            switch (DatabaseProvider)
            {
                case DatabaseProvider.SQLServer:
                    return new SqlConnection(GetConnectionString());

                case DatabaseProvider.Oracle:
                    return new OracleConnection(GetConnectionString());

                case DatabaseProvider.SqlCe4:
                    return new SqlCeConnection(GetConnectionString());

                case DatabaseProvider.SQLite:
                    var conn = new SQLiteConnection(GetConnectionString());
                    if (!string.IsNullOrEmpty(SqlPassword))
                    {
                        conn.SetPassword(SqlPassword);
                    }
                    return conn;

                default:
                    throw new NotSupportedException("Database type is not supported");
            }
        }