} // End Function GetMsCSB protected static DB.Abstraction.UniversalConnectionStringBuilder GetPgCSB() { DB.Abstraction.UniversalConnectionStringBuilder csb = DB.Abstraction.UniversalConnectionStringBuilder.CreateInstance( DB.Abstraction.cDAL.DataBaseEngine_t.PostGreSQL); csb.Server = "127.0.0.1"; csb.DataBase = "blogz"; csb.Port = 5432; csb.UserName = "******"; csb.Password = "******"; return(csb); } // End Function GetPgCSB
protected static DB.Abstraction.UniversalConnectionStringBuilder GetMsCSB() { DB.Abstraction.UniversalConnectionStringBuilder csb = DB.Abstraction.UniversalConnectionStringBuilder.CreateInstance( DB.Abstraction.cDAL.DataBaseEngine_t.MS_SQL); csb.Server = System.Environment.MachineName; if (System.Environment.OSVersion.Platform == System.PlatformID.Unix) { csb.Server += ",2019"; } csb.DataBase = "Blogz"; csb.IntegratedSecurity = true; csb.Pooling = false; csb.PersistSecurityInfo = false; return(csb); } // End Function GetMsCSB
public static DB.Abstraction.UniversalConnectionStringBuilder GetDefaultCSB(DB.Abstraction.cDAL.DataBaseEngine_t dataBaseEngine) { DB.Abstraction.UniversalConnectionStringBuilder csb = DB.Abstraction.UniversalConnectionStringBuilder.CreateInstance( dataBaseEngine ); // OMG if (System.Environment.OSVersion.Platform == System.PlatformID.Unix) { csb.Server = "127.0.0.1"; } else { csb.Server = System.Environment.MachineName; } switch (dataBaseEngine) { case DB.Abstraction.cDAL.DataBaseEngine_t.PostGreSQL: csb.Port = 5432; csb.DataBase = "postgres"; break; case DB.Abstraction.cDAL.DataBaseEngine_t.MySQL: csb.Port = 3306; break; case DB.Abstraction.cDAL.DataBaseEngine_t.MS_SQL: csb.IntegratedSecurity = true; csb.DataBase = "master"; break; } // End switch (dataBaseEngine) if (!csb.IntegratedSecurity) { csb.UserName = "******"; csb.Password = "******"; } // End if(!csb.IntegratedSecurity) return(csb); }
} // End Function GetCSB protected static DB.Abstraction.cDAL SetupDAL() { DB.Abstraction.UniversalConnectionStringBuilder csb = GetCSB(); return(DB.Abstraction.cDAL.CreateInstance(csb.EngineName, csb.ConnectionString)); } // End Function SetupDAL
public cbItem(string name, DB.Abstraction.UniversalConnectionStringBuilder csb) { this.Name = name; this.m_csb = csb; }