private void ConfigureShards(IServiceScope serviceScope)
{
var databaseManager = serviceScope.ServiceProvider.GetService <IDatabaseManager>();
var shardsConfiguration = serviceScope.ServiceProvider.GetService <ShardsConfiguration>();
var shardProvider = serviceScope.ServiceProvider.GetService <IShardFactory <int> >();
var shardMapProvider = serviceScope.ServiceProvider.GetService <IShardMapProvider <int> >();
var shardMappingProvider = serviceScope.ServiceProvider.GetService <IShardMappingFactory <int> >();
databaseManager.CreateIfNotExtists(ShardMapConnectionString);
foreach (var shardConfiguration in shardsConfiguration.Shards)
{
databaseManager.CreateIfNotExtists(shardConfiguration.Server, shardConfiguration.UserName, shardConfiguration.Password.ToSecureString(), shardConfiguration.Database);
var shardMap = shardMapProvider.CreateOrGetListShardMap(ShardMapConnectionString, ShardMapName);
var shard = shardProvider.CreateOrGet(shardMap, shardConfiguration.Server, shardConfiguration.Database);
foreach (var shardingKey in shardConfiguration.ShardingKeys)
{
shardMappingProvider.CreateIfNotExists(shardMap, shard, shardingKey);
}
var optionsBuilder = new DbContextOptionsBuilder <SchoolsDbContext>();
var connectionStringBuiler = new SqlConnectionStringBuilder();
connectionStringBuiler.Add("Server", shardConfiguration.Server);
connectionStringBuiler.Add("Data Source", shardConfiguration.Database);
connectionStringBuiler.Add("User Id", shardConfiguration.UserName);
connectionStringBuiler.Add("Password", shardConfiguration.Password);
optionsBuilder.UseSqlServer(connectionStringBuiler.ConnectionString,
sqlServerOptions => sqlServerOptions.MigrationsAssembly(_migrationsAssembly));
var schoolsDbContext = new SchoolsDbContext(optionsBuilder.Options);
schoolsDbContext.Database.EnsureCreated();
}
}
public void TestSqlConnectionStringBuilderShouldSerialize(SqlConnectionColumnEncryptionSetting sqlConnectionColumnEncryptionSetting)
{
SqlConnectionStringBuilder connectionStringBuilder = new SqlConnectionStringBuilder();
// Use the Add function to update the Column Encryption Setting in the dictionary.
connectionStringBuilder.Add(@"Column Encryption Setting", sqlConnectionColumnEncryptionSetting);
// Query the ShouldSerialize method to check if the above add was effective.
Assert.True(connectionStringBuilder.ShouldSerialize(@"Column Encryption Setting"));
// Use the Remove function to Remove the Column Encryption Setting from the dictionary.
connectionStringBuilder.Remove(@"Column Encryption Setting");
// Query the property to check if the above add was effective.
Assert.False(connectionStringBuilder.ShouldSerialize(@"Column Encryption Setting"));
// Use the Add function to update the Column Encryption Setting in the dictionary.
string url = "www.foo.com";
connectionStringBuilder.Add(@"Enclave Attestation Url", url);
// Query the ShouldSerialize method to check if the above add was effective.
Assert.True(connectionStringBuilder.ShouldSerialize(@"Enclave Attestation Url"));
// Use the Remove function to Remove the Column Encryption Setting from the dictionary.
connectionStringBuilder.Remove(@"Enclave Attestation Url");
// Query the property to check if the above add was effective.
Assert.False(connectionStringBuilder.ShouldSerialize(@"Enclave Attestation Url"));
}
public static string ModifyConnString(string connString)
{
OleDbConnectionStringBuilder oleConnBuilder = new OleDbConnectionStringBuilder(connString);
SqlConnectionStringBuilder sqlConnBuilder = new SqlConnectionStringBuilder();
object tokenValue;
if (oleConnBuilder.TryGetValue("Application Name", out tokenValue))
{
sqlConnBuilder.ApplicationName = tokenValue.ToString();
}
if (oleConnBuilder.TryGetValue("Server", out tokenValue))
{
sqlConnBuilder.Add("Server", tokenValue.ToString());
}
if (oleConnBuilder.TryGetValue("Database", out tokenValue))
{
sqlConnBuilder.Add("Database", tokenValue.ToString());
}
if (oleConnBuilder.TryGetValue("Trusted_Connection", out tokenValue))
{
sqlConnBuilder.IntegratedSecurity = (string.Compare(tokenValue.ToString(), "yes", true) == 0);
}
if (!sqlConnBuilder.IntegratedSecurity)
{
sqlConnBuilder.UserID = oleConnBuilder["User Id"].ToString();
sqlConnBuilder.Password = oleConnBuilder["Password"].ToString();
}
if (oleConnBuilder.TryGetValue("MARS Connection", out tokenValue))
{
sqlConnBuilder.MultipleActiveResultSets = (string.Compare(tokenValue.ToString(), "true", true) == 0);
}
return(sqlConnBuilder.ToString());
}
public void TestSqlConnectionStringBuilderAdd(SqlConnectionColumnEncryptionSetting sqlConnectionColumnEncryptionSetting)
{
SqlConnectionStringBuilder connectionStringBuilder = new SqlConnectionStringBuilder();
// Use the Add function to update the Column Encryption Setting in the dictionary.
connectionStringBuilder.Add(@"Column Encryption Setting", sqlConnectionColumnEncryptionSetting);
// Query the property to check if the above add was effective.
Assert.Equal(sqlConnectionColumnEncryptionSetting, connectionStringBuilder.ColumnEncryptionSetting);
//define value for Attestation Url and Attestation Protocol
string url = "www.foo.com";
SqlConnectionAttestationProtocol protocol = SqlConnectionAttestationProtocol.HGS;
// Use the Add function to update the Enclave Attestation Url in the dictionary.
connectionStringBuilder.Add(@"Enclave Attestation Url", url);
// Query the property to check if the above add was effective.
Assert.Equal(url, connectionStringBuilder.EnclaveAttestationUrl);
// Use the Add function to update the Attestation Protocol in the dictionary.
connectionStringBuilder.Add(@"Attestation Protocol", protocol);
// Query the property to check if the above add was effective.
Assert.Equal(protocol, connectionStringBuilder.AttestationProtocol);
}
public void TestSqlConnectionStringBuilderRemove(SqlConnectionColumnEncryptionSetting sqlConnectionColumnEncryptionSetting)
{
SqlConnectionStringBuilder connectionStringBuilder = new SqlConnectionStringBuilder();
// Use the Add function to update the Column Encryption Setting in the dictionary.
connectionStringBuilder.Add(@"Column Encryption Setting", sqlConnectionColumnEncryptionSetting);
// Query the property to check if the above add was effective.
Assert.Equal(sqlConnectionColumnEncryptionSetting, connectionStringBuilder.ColumnEncryptionSetting);
// Use the Remove function to remove the Column Encryption Setting from the dictionary.
connectionStringBuilder.Remove(@"Column Encryption Setting");
// Query the property to check if the above add was effective.
object outputValue;
connectionStringBuilder.TryGetValue(@"Column Encryption Setting", out outputValue);
Assert.Equal(SqlConnectionColumnEncryptionSetting.Disabled, outputValue);
// Use the Add function to update the Column Encryption Setting in the dictionary.
string url = "www.foo.com";
connectionStringBuilder.Add(@"Enclave Attestation Url", url);
// Query the property to check if the above add was effective.
Assert.Equal(url, connectionStringBuilder.EnclaveAttestationUrl);
// Use the Remove function to remove the Column Encryption Setting from the dictionary.
connectionStringBuilder.Remove(@"Enclave Attestation Url");
// Query the property to check if the above add was effective.
connectionStringBuilder.TryGetValue(@"Enclave Attestation Url", out outputValue);
Assert.Equal(string.Empty, outputValue);
}
private void buttonLogin_Click(object sender, EventArgs e)
{
SettingHelper parentForm = (SettingHelper)this.Owner;
try {
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.Add("Server", this.textBoxServerName.Text);
if (this.comboBoxAuth.SelectedIndex == 0)
{
builder.Add("Integrated Security", "SSPI");
}
else if (this.comboBoxAuth.SelectedIndex == 1)
{
builder.Add("UID", this.textBoxUserName.Text);
builder.Add("PWD", this.textBoxPassword.Text);
builder.Add("Network Library", "DBMSSOCN");
}
parentForm.dbConn = new SqlConnection(builder.ConnectionString);
parentForm.dbConn.Open();
parentForm.dbCmd = parentForm.dbConn.CreateCommand();
parentForm.dbCmd.CommandType = CommandType.Text;
// write settings back
parentForm.connSetting["Server"] = this.textBoxServerName.Text;
parentForm.connSetting["AuthType"] = this.comboBoxAuth.SelectedIndex;
parentForm.connSetting["UID"] = this.textBoxUserName.Text;
parentForm.connSetting["PWD"] = this.textBoxPassword.Text;
this.Close();
} catch (Exception ex) {
MessageBox.Show(ex.Message);
}
}
public void insertHKDRATE(string hkdrate)
{
SqlConnectionStringBuilder builder2 = new SqlConnectionStringBuilder();
builder2.Add("User id", DBUser.Trim());
builder2.Add("Initial Catalog", DBStr.Trim());
builder2.Add("Data Source", DBHostStr.Trim());
builder2.Add("Password", DBPasd.Trim());
SqlConnection cn2 = new SqlConnection(builder2.ConnectionString);
SqlCommand cmd2 = cn2.CreateCommand();
cmd2.Parameters.Add(new SqlParameter("@From_Currency_code", "HKD"));
cmd2.Parameters.Add(new SqlParameter("@To_Currency_code", "TWD"));
cmd2.Parameters.Add(new SqlParameter("@Rate_YYYYMMDD", DateTime.Now.ToString("yyyyMMdd")));
cmd2.Parameters.Add(new SqlParameter("@Exchange_rate", Convert.ToSingle(hkdrate)));
cmd2.Parameters.Add(new SqlParameter("@Creation_date", DateTime.Now));
cmd2.Parameters.Add(new SqlParameter("@Created_by", 195));
cmd2.CommandText = "insert into Exchange_date_rate(From_Currency_code,To_Currency_code,Rate_YYYYMMDD,Exchange_rate,Creation_date,Created_by) values (@From_Currency_code,@To_Currency_code,@Rate_YYYYMMDD,@Exchange_rate,@Creation_date,@Created_by) ";
try
{
cn2.Open();
cmd2.ExecuteNonQuery();
}
catch (Exception ex)
{
err = ex.Message;
}
finally
{
cn2.Close();
cn2.Dispose();
}
return;
}
public string BuildForWindowsAuthentication(string serverName)
{
SqlConnectionStringBuilder connectionStringBuilder = new SqlConnectionStringBuilder();
connectionStringBuilder.Add("Data Source", serverName);
connectionStringBuilder.Add("Integrated Security", "True");
return(connectionStringBuilder.ConnectionString);
}
private static string AddCredentials(string connectionString)
{
var databaseConfiguration = (NameValueCollection)ConfigurationManager.GetSection("DatabaseConfig");
var builder = new SqlConnectionStringBuilder(connectionString);
builder.Add("User Id", databaseConfiguration["UserId"]);
builder.Add("Password", databaseConfiguration["Password"]);
return(builder.ConnectionString);
}
public string BuildForSqlAuthentication(string serverName, string login, string password)
{
SqlConnectionStringBuilder connectionStringBuilder = new SqlConnectionStringBuilder();
connectionStringBuilder.Add("Data Source", serverName);
connectionStringBuilder.Add("User Id", login);
connectionStringBuilder.Add("Password", password);
return(connectionStringBuilder.ConnectionString);
}
// Init
static SqlConn()
{
SqlConnectionStringBuilder lConnStr = new SqlConnectionStringBuilder();
lConnStr.Add("Data Source", "paweladamczuk.com.pl,4100");
lConnStr.Add("Initial Catalog", "FOKA");
lConnStr.Add("User Id", "sa");
lConnStr.Add("Password", "foka");
mSC = new SqlConnection(lConnStr.ConnectionString);
}
static void Main(string[] args)
{
string domain = System.Environment.UserDomainName;
Console.WriteLine(domain);
//this need to be wrapped
string password = "******";
SecureString secureString = new SecureString();
Array.ForEach(password.ToArray(), (z) => secureString.AppendChar(z));
//end
secureString.MakeReadOnly();
try
{
//use sql crederntial and password
SqlCredential sql = new SqlCredential(Environment.UserName, secureString);
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.Add("Data Source", domain);
builder.Add("Initial Catalog", "Example");
SqlCredential sqlCredential = new SqlCredential("roman", secureString);
using (SqlConnection sqlConnectio = new SqlConnection(builder.ConnectionString, sqlCredential))
{
sqlConnectio.Open();
SqlCommand sqlCommand = new SqlCommand("select SYSTEM_USER", sqlConnectio);
string result = (string)sqlCommand.ExecuteScalar();
Console.WriteLine(result);
sqlConnectio.Close();
}
//use windows authentication
builder.Clear();
builder.Add("Data Source", domain);
builder.Add("Initial Catalog", "Example");
builder.Add("Integrated Security", "SSPI");
using (SqlConnection sqlConnectionSecond = new SqlConnection(builder.ConnectionString))
{
sqlConnectionSecond.Open();
SqlCommand sqlCommand = new SqlCommand("select SYSTEM_USER", sqlConnectionSecond);
string result = (string)sqlCommand.ExecuteScalar();
Console.WriteLine(result);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
secureString.Dispose();
}
}
private void FormFestivos_Load(object sender, EventArgs e)
{
SqlConnectionStringBuilder ParametrosConexion = new SqlConnectionStringBuilder();
dt.Columns.Add("Fecha", Type.GetType("System.DateTime"));
dt.Columns.Add("Fiesta", Type.GetType("System.String"));
ParametrosConexion.Add("Data Source", "SEGUNDO150");
ParametrosConexion.Add("Initial Catalog", "AVAN_iban");
ParametrosConexion.Add("Integrated Security", "SSPI");
//ParametrosConexion.Add("Data Source", "xxxxxxx,80");
//ParametrosConexion.Add("Initial Catalog", "Agencia");
//ParametrosConexion.Add("user", "sa");
//ParametrosConexion.Add("password", "xxxxxxx");
cn.ConnectionString = ParametrosConexion.ConnectionString;
SqlParameter p_anio = new SqlParameter();
SqlCommand Comando = cn.CreateCommand();
Comando.CommandType = System.Data.CommandType.Text;
Comando.CommandText = "select CAST(CAST(Agno AS varchar(4)) + '-' + CAST(Mes AS varchar(2)) + '-' + CAST(DiaMes AS varchar(2)) AS date) Fecha, DescFestivo from Agencia.Calendario where Festivo = 1 and Agno = @anio";
p_anio.SqlDbType = SqlDbType.SmallInt;
p_anio.Direction = ParameterDirection.Input;
p_anio.ParameterName = "@anio";
p_anio.Value = DateTime.Now.Year;
Comando.Parameters.Add(p_anio);
try
{
cn.Open();
SqlDataReader lector = Comando.ExecuteReader();
while (lector.Read())
{
agrega_fecha((DateTime)((IDataRecord)lector)["Fecha"], (String)((IDataRecord)lector)["DescFestivo"]);
}
lector.Close();
}
catch (Exception ex)
{
//////
MessageBox.Show(ex.Message);
}
finally
{
cn.Close();
}
}
/// <summary>
/// static constructor to determine the state of the environment and set defaults
/// </summary>
static CurrentEnvironment()
{
// Not on cloud foundry filling in the blanks.
if (string.IsNullOrEmpty(Environment.GetEnvironmentVariable(INSTANCE_GUID_ENV_VARIABLE_NAME)))
{
Environment.SetEnvironmentVariable(BOUND_SERVICES_ENV_VARIABLE_NAME, "{}");
Environment.SetEnvironmentVariable(PORT_ENV_VARIABLE_NAME, NOT_ON_CLOUD_FOUNDRY_MESSAGE);
Environment.SetEnvironmentVariable(INSTANCE_GUID_ENV_VARIABLE_NAME, NOT_ON_CLOUD_FOUNDRY_MESSAGE);
Environment.SetEnvironmentVariable(INSTANCE_INDEX_ENV_VARIABLE_NAME, NOT_ON_CLOUD_FOUNDRY_MESSAGE);
}
// check to see if DB is bound, if so...what type
// SQL server first
if (BoundServices.GetValue("azure-sqldb") != null) // Azure SQL Database (Azure Broker)
{
DbEngine = DatabaseEngine.SqlServer;
SqlConnectionStringBuilder csbuilder = new SqlConnectionStringBuilder();
csbuilder.Add("server", BoundServices["azure-sqldb"][0]["credentials"]["hostname"].ToString());
csbuilder.Add("uid", BoundServices["azure-sqldb"][0]["credentials"]["username"].ToString());
csbuilder.Add("pwd", BoundServices["azure-sqldb"][0]["credentials"]["password"].ToString());
csbuilder.Add("database", BoundServices["azure-sqldb"][0]["credentials"]["name"].ToString());
_connectionString = csbuilder.ToString();
}
else if (BoundServices.GetValue("azure-mysqldb") != null || BoundServices.GetValue("p-mysql") != null || BoundServices.GetValue("cleardb") != null) // MySQL for PCF or Mysql for AZURE
{
string label = "p-mysql"; // MySQL Database.
if (BoundServices.GetValue("azure-mysqldb") != null)
{
label = "azure-mysqldb"; //Mysql Database on Azure (Mysql For Azure)
}
if (BoundServices.GetValue("cleardb") != null)
{
label = "cleardb"; //Mysql cleardb
}
DbEngine = DatabaseEngine.MySql;
MySqlConnectionStringBuilder csbuilder = new MySqlConnectionStringBuilder();
csbuilder.Add("server", BoundServices[label][0]["credentials"]["hostname"].ToString());
csbuilder.Add("port", BoundServices[label][0]["credentials"]["port"].ToString());
csbuilder.Add("uid", BoundServices[label][0]["credentials"]["username"].ToString());
csbuilder.Add("pwd", BoundServices[label][0]["credentials"]["password"].ToString());
csbuilder.Add("database", BoundServices[label][0]["credentials"]["name"].ToString());
_connectionString = csbuilder.ToString();
}
else
{
DbEngine = DatabaseEngine.None;
}
}
public static string GetProviderConnectionString(string connectionString, out bool isEntity)
{
isEntity = false;
if (string.Compare(connectionString, "metadata=", true) == 0)
{
// Get connection string from entity connection string.
var ecsb = new System.Data.EntityClient.EntityConnectionStringBuilder(connectionString);
connectionString = ecsb.ProviderConnectionString;
isEntity = true;
}
var builder = new SqlConnectionStringBuilder(connectionString);
if (!builder.ContainsKey("Application Name") || ".Net SqlClient Data Provider".Equals(builder["Application Name"]))
{
var asm = Assembly.GetEntryAssembly();
if (asm == null)
{
asm = Assembly.GetExecutingAssembly();
}
var appPrefix = asm.GetName().Name.Replace(".", "");
var appName = string.Format("{0}", appPrefix);
builder.Add("Application Name", appName);
connectionString = builder.ToString();
}
return(connectionString);
}
public static string GetConnstringFromDBSource(DBSource dbSource, string connDB)
{
if (dbSource == null)
{
return(null);
}
SqlConnectionStringBuilder sb = new SqlConnectionStringBuilder();
sb.DataSource = dbSource.ServerName;
sb.InitialCatalog = connDB;
sb.Pooling = true;
sb.MaxPoolSize = 20;
sb.MinPoolSize = 10;
sb.ConnectTimeout = 30;
if (dbSource.IDType == IDType.sqlserver)
{
sb.UserID = dbSource.LoginName;
sb.Password = dbSource.LoginPassword;
return(sb.ConnectionString);
}
else
{
sb.Add("Trusted_Connection", "SSPI");
return(sb.ConnectionString);
}
}
private static string BuildConnectionString(string server, string database, string username, string password)
{
// Create a connection string builder
SqlConnectionStringBuilder csb = new SqlConnectionStringBuilder
{
DataSource = server
};
// Define connection string attributes using three techniques
csb.Add("Initial Catalog", database);
csb.Add("User Id", username);
csb.Add("Password", password);
//csb["Integrated Security"] = true;
return(csb.ConnectionString);
}
public string GetConnectionString(string name)
{
// Try to find entity connection.
var cs = ConfigurationManager.ConnectionStrings[name];
// If configuration section with not found then return.
if (cs == null)
{
return(null);
}
var connectionString = cs.ConnectionString;
if (string.Compare(cs.ProviderName, "System.Data.EntityClient", true) == 0)
{
// Get connection string from entity connection string.
var ecsb = new System.Data.EntityClient.EntityConnectionStringBuilder(cs.ConnectionString);
connectionString = ecsb.ProviderConnectionString;
}
var builder = new SqlConnectionStringBuilder(connectionString);
if (!builder.ContainsKey("Application Name") || ".Net SqlClient Data Provider".Equals(builder["Application Name"]))
{
var asm = Assembly.GetEntryAssembly();
if (asm == null)
{
asm = Assembly.GetExecutingAssembly();
}
var appPrefix = asm.GetName().Name.Replace(".", "");
var appName = string.Format("{0}", appPrefix);
builder.Add("Application Name", appName);
connectionString = builder.ToString();
}
return(connectionString);
}
private SqlConnection CreateSQLConnection()
{
string serverName = SQLServerText.Text,
userName = Username.Text,
password = Password.Text,
dataBase = DBName.Text;
bool isIntegratedSecurity = AuthenticationTypeComboBox.SelectedIndex != 0;
SqlConnection connection = new SqlConnection();
SqlConnectionStringBuilder connectionString = new SqlConnectionStringBuilder();
if (isIntegratedSecurity)
{
connectionString.Add("Integrated Security", "SSPI");
}
else
{
connectionString.UserID = userName;
connectionString.Password = password;
}
if (!String.IsNullOrEmpty(dataBase))
{
connectionString.InitialCatalog = dataBase;
}
connectionString.DataSource = serverName;
connection.ConnectionString = connectionString.ToString();
return(connection);
}
/// <summary>
/// This builds a connection string to hit this connection
/// </summary>
/// <returns></returns>
public string BuildConnectionString()
{
SqlConnectionStringBuilder csb = new SqlConnectionStringBuilder();
if (!string.IsNullOrEmpty(Server))
{
csb.DataSource = Server;
}
if (!string.IsNullOrEmpty(Database))
{
csb.InitialCatalog = Database;
}
csb.IntegratedSecurity = (SecurityType == SecurityType.WindowsAuthentication);
if (csb.IntegratedSecurity == false && !string.IsNullOrEmpty(Username))
{
csb.UserID = Username;
if (!string.IsNullOrEmpty(Password))
{
csb.Password = Password;
}
}
// Turn on MARS
csb.Add("MultipleActiveResultSets", true);
return(csb.ConnectionString);
}
public static string GetProviderConnectionString(string connectionString, out bool isEntity)
{
isEntity = false;
#if NETSTANDARD // .NET Standard
#elif NETCOREAPP // .NET Core
// EF Core does not support EF specific connection strings (metadata=res:... < this kind of connection strings).
#else // .NET Framework
if (string.Compare(connectionString, "metadata=", true) == 0)
{
// Get connection string from entity connection string.
var ecsb = new System.Data.EntityClient.EntityConnectionStringBuilder(connectionString);
connectionString = ecsb.ProviderConnectionString;
isEntity = true;
}
#endif
var builder = new SqlConnectionStringBuilder(connectionString);
if (!builder.ContainsKey("Application Name") || ".Net SqlClient Data Provider".Equals(builder["Application Name"]))
{
var asm = Assembly.GetEntryAssembly();
if (asm == null)
{
asm = Assembly.GetExecutingAssembly();
}
var appPrefix = asm.GetName().Name.Replace(".", "");
var appName = string.Format("{0}", appPrefix);
builder.Add("Application Name", appName);
connectionString = builder.ToString();
}
return(connectionString);
}
public static SqlConnection GetSQLConnection()
{
string connString = ConfigurationManager.ConnectionStrings["appConnectionString"].ConnectionString;
SqlConnectionStringBuilder connStringBuilder = new SqlConnectionStringBuilder(connString);
connStringBuilder.Add("Password", "niemvui");
return(new SqlConnection(connStringBuilder.ToString()));
}
public void TestSqlConnectionStringBuilderAdd(SqlConnectionColumnEncryptionSetting sqlConnectionColumnEncryptionSetting)
{
SqlConnectionStringBuilder connectionStringBuilder = new SqlConnectionStringBuilder();
// Use the Add function to update the Column Encryption Setting in the dictionary.
connectionStringBuilder.Add(@"Column Encryption Setting", sqlConnectionColumnEncryptionSetting);
// Query the property to check if the above add was effective.
Assert.Equal(sqlConnectionColumnEncryptionSetting, connectionStringBuilder.ColumnEncryptionSetting);
// Use the Add function to update the Column Encryption Setting in the dictionary.
string url = "www.foo.com";
connectionStringBuilder.Add(@"Enclave Attestation Url", url);
// Query the property to check if the above add was effective.
Assert.Equal(url, connectionStringBuilder.EnclaveAttestationUrl);
}
static Connect()
{
try
{
SqlConnectionStringBuilder stringConn = new SqlConnectionStringBuilder();
stringConn.Add("Data Source", @"VLADIMIR\SQLEXPRESS");
stringConn.Add("Initial Catalog", "projekt_bazy_danych");
stringConn.Add("Trusted_Connection", "True");
conn = new SqlConnection(stringConn.ConnectionString);
conn.Open();
connected = true;
}
catch
{
conn.Dispose();
connected = false;
}
}
public static string SeachConnectionString()
{
SqlConnectionStringBuilder SCSB = new SqlConnectionStringBuilder();
SCSB.ConnectionString = "Data Source=(LocalDB)\\MSSQLLocalDB;Integrated Security=True;MultipleActiveResultSets=True;App=EntityFramework";
//if (Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location).Contains("assembly"))
// return @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=F:\BankNetEntity\BankNetEntity\BankNetEntityDB\BankNetEntityDB.mdf;Integrated Security=True;MultipleActiveResultSets=True;App=EntityFramework";
SCSB.Add("AttachDbFilename", Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location) + "\\BankNetEntityDB.mdf");
return(SCSB.ConnectionString);
}
private string getConnStr()
{
// 参数详见 https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring%28v=vs.110%29.aspx
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.Add("Server", dbIP.Text + "," + dbPort.Value.ToString());
if (modeWin.Checked)
{
builder.Add("Integrated Security", "SSPI");
}
else
{
builder.Add("UID", userName.Text);
builder.Add("PWD", password.Text);
builder.Add("Network Library", "DBMSSOCN");
}
return(builder.ConnectionString);
}
static void Main(string[] args)
{
var builder = new SqlConnectionStringBuilder()
{
["Server"] = ".",
["Integrated Security"] = "Тrue"
};
var connection = new SqlConnection(builder.ToString());
connection.Open();
using (connection)
{
string createDbQuery = "CREATE DATABASE MinionsDB";
ExecuteNonQueryCommand(createDbQuery, connection);
}
builder.Add("Database", "MinionsDb");
connection = new SqlConnection(builder.ToString());
using (connection)
{
connection.Open();
string createCountriesSql = "CREATE TABLE Countries (Id INT PRIMARY KEY IDENTITY,Name VARCHAR(50))";
string createTownsSql = "CREATE TABLE Towns(Id INT PRIMARY KEY IDENTITY,Name VARCHAR(50), CountryCode INT FOREIGN KEY REFERENCES Countries(Id))";
string createMinionsSql = "CREATE TABLE Minions(Id INT PRIMARY KEY IDENTITY,Name VARCHAR(30), Age INT, TownId INT FOREIGN KEY REFERENCES Towns(Id))";
string createEvilnesFactorSql = "CREATE TABLE EvilnessFactors(Id INT PRIMARY KEY IDENTITY, Name VARCHAR(50))";
string createVillainsSql = "CREATE TABLE Villains (Id INT PRIMARY KEY IDENTITY, Name VARCHAR(50), EvilnessFactorId INT FOREIGN KEY REFERENCES EvilnessFactors(Id))";
string createMinionsVillainsSql = "CREATE TABLE MinionsVillains (MinionId INT FOREIGN KEY REFERENCES Minions(Id),VillainId INT FOREIGN KEY REFERENCES Villains(Id),CONSTRAINT PK_MinionsVillains PRIMARY KEY (MinionId, VillainId))";
ExecuteNonQueryCommand(createCountriesSql, connection);
ExecuteNonQueryCommand(createTownsSql, connection);
ExecuteNonQueryCommand(createMinionsSql, connection);
ExecuteNonQueryCommand(createEvilnesFactorSql, connection);
ExecuteNonQueryCommand(createVillainsSql, connection);
ExecuteNonQueryCommand(createMinionsVillainsSql, connection);
string insertCountries = "INSERT INTO Countries ([Name]) VALUES ('Bulgaria'),('England'),('Cyprus'),('Germany'),('Norway')";
string insertTowns = "INSERT INTO Towns ([Name], CountryCode) VALUES ('Plovdiv', 1),('Varna', 1),('Burgas', 1),('Sofia', 1),('London', 2),('Southampton', 2),('Bath', 2),('Liverpool', 2),('Berlin', 3),('Frankfurt', 3),('Oslo', 4)";
string insertMinions = "INSERT INTO Minions (Name,Age, TownId) VALUES('Bob', 42, 3),('Kevin', 1, 1),('Bob ', 32, 6),('Simon', 45, 3),('Cathleen', 11, 2),('Carry ', 50, 10),('Becky', 125, 5),('Mars', 21, 1),('Misho', 5, 10),('Zoe', 125, 5),('Json', 21, 1)";
string insertEvilnessFactor = "INSERT INTO EvilnessFactors (Name) VALUES ('Super good'),('Good'),('Bad'), ('Evil'),('Super evil')";
string insertVillains = "INSERT INTO Villains (Name, EvilnessFactorId) VALUES ('Gru',2),('Victor',1),('Jilly',3),('Miro',4),('Rosen',5),('Dimityr',1),('Dobromir',2)";
string insertMinionsVillains = "INSERT INTO MinionsVillains (MinionId, VillainId) VALUES (4,2),(1,1),(5,7),(3,5),(2,6),(11,5),(8,4),(9,7),(7,1),(1,3),(7,3),(5,3),(4,3),(1,2),(2,1),(2,7)";
ExecuteNonQueryCommand(insertCountries, connection);
ExecuteNonQueryCommand(insertTowns, connection);
ExecuteNonQueryCommand(insertMinions, connection);
ExecuteNonQueryCommand(insertEvilnessFactor, connection);
ExecuteNonQueryCommand(insertVillains, connection);
ExecuteNonQueryCommand(insertMinionsVillains, connection);
connection.Close();
}
}
static void Main(string[] args)
{
var builder = new SqlConnectionStringBuilder()
{
["Server"] = "RZR\\SQLEXPRESS",
["Integrated Security"] = "True"
};
var connection = new SqlConnection(builder.ToString());
connection.Open();
using (connection)
{
try
{
var createDbQuery = "CREATE DATABASE MinionsDB";
ExecuteCommand(createDbQuery, connection);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
builder.Add("DATABASE", "MinionsDB");
connection = new SqlConnection(builder.ToString());
connection.Open();
using (connection)
{
try
{
string cTCCountries = "CREATE TABLE Countries ( Id INT PRIMARY KEY IDENTITY, Name NVARCHAR(50))";
string cTCTowns = "CREATE TABLE Towns ( Id INT PRIMARY KEY IDENTITY, Name NVARCHAR(50), CountryId INT NOT NULL, CONSTRAINT FK_TownCountry FOREIGN KEY (CountryId) REFERENCES Countries(Id))";
string cTCEvilnessFactors = "CREATE TABLE EvilnessFactors ( Id INT PRIMARY KEY, Name NVARCHAR(10) UNIQUE NOT NULL )";
string cTCVillains = "CREATE TABLE Villains ( Id INT PRIMARY KEY IDENTITY, Name NVARCHAR(50), EvilnessFactorId INT CONSTRAINT FK_VillainEvilnessFactor FOREIGN KEY (EvilnessFactorId) REFERENCES EvilnessFactors(Id) )";
string cTCMinions = "CREATE TABLE Minions ( Id INT PRIMARY KEY IDENTITY, Name NVARCHAR(50), Age INT, TownId INT, CONSTRAINT FK_Towns FOREIGN KEY (TownId) REFERENCES Towns(Id) )";
string cTCMinionsVillains = "CREATE TABLE MinionsVillains ( MinionId INT, VillainId INT, CONSTRAINT FK_Minions FOREIGN KEY (MinionId) REFERENCES Minions(Id), CONSTRAINT FK_Villains FOREIGN KEY (VillainId) REFERENCES Villains(Id) )";
ExecuteCommand(cTCCountries, connection);
ExecuteCommand(cTCTowns, connection);
ExecuteCommand(cTCEvilnessFactors, connection);
ExecuteCommand(cTCVillains, connection);
ExecuteCommand(cTCMinions, connection);
ExecuteCommand(cTCMinionsVillains, connection);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
}
private static DbContextOptions <DeviceContext> GetModifedOptions(DbContextOptions <DeviceContext> options,
IHttpContextAccessor httpContentAccessor, IOptions <ConnectionSettings> connectionOptions)
{
ValidateDefaultConnection(connectionOptions);
var connectionBuilder = new SqlConnectionStringBuilder(connectionOptions.Value.DefaultConnection);
connectionBuilder.Remove(Constants.Database);
connectionBuilder.Add(Constants.Database, GetDataBaseName(GetTenantId(httpContentAccessor.HttpContext)));
var contextOptionsBuilder = new DbContextOptionsBuilder <DeviceContext>();
contextOptionsBuilder.UseSqlServer(connectionBuilder.ConnectionString);
return(contextOptionsBuilder.Options);
}
private SqlConnectionStringBuilder ChangeNameDatabase()
{
var sqlConnectionBuilder = new SqlConnectionStringBuilder(this._connectionOptions.Value.DefaultConnection);
var tenant = this._databaseManager.GetTenantById(this.TenantId);
if (tenant == null)
{
throw new ArgumentNullException(nameof(tenant));
}
// Remove old DataBase name from connection string AND add new one
sqlConnectionBuilder.Remove(DatabaseFieldKeyword);
sqlConnectionBuilder.Add(DatabaseFieldKeyword, tenant.Name);
return(sqlConnectionBuilder);
}
