} // 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;
}
