public void Start() { var config = new MigForwardingConfiguration(); var dbContext = new MigDbContext(config); dbContext.Upgrade(); Console.ReadKey(); dbContext.Downgrade(); _semaphoreSlim = new SemaphoreSlim(0); while (true) { Console.WriteLine("It is {0} and all is well.", DateTime.Now); var result = dbContext.SelectTop50(); foreach (DataRow dataRow in result.Rows) { foreach (var item in dataRow.ItemArray) { Console.WriteLine(item); } } Thread.Sleep(3000); if (_semaphoreSlim.Wait(500)) { OnStopping(); break; } } }
private string BuildConnectionString(MigForwardingConfiguration config) { // Initialize the connection string builder for the // underlying provider. SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder { // Set the properties for the data source. DataSource = config.Source, InitialCatalog = config.Catalog, MultipleActiveResultSets = true, ApplicationName = "EntityFramework" }; if (!config.IntergratedSecurity) { sqlBuilder.UserID = config.SqlUsername; sqlBuilder.Password = config.SqlPassword; } sqlBuilder.IntegratedSecurity = config.IntergratedSecurity; // Build the SqlConnection connection string. string providerString = sqlBuilder.ToString(); Console.WriteLine(providerString); Console.ReadKey(); return(providerString); // Initialize the EntityConnectionStringBuilder. EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder(); //Set the provider name. //entityBuilder.Provider = providerName; // Set the provider-specific connection string. //entityBuilder.ProviderConnectionString = providerString; // Set the Metadata location. //entityBuilder.Metadata = @"res://*/AdventureWorksModel.csdl| // res://*/AdventureWorksModel.ssdl| // res://*/AdventureWorksModel.msl"; //Console.WriteLine(entityBuilder.ToString()); using (EntityConnection conn = new EntityConnection(entityBuilder.ToString())) { conn.Open(); Console.WriteLine("Just testing the connection."); conn.Close(); } }
public MigDbContext(MigForwardingConfiguration config) { Config = config; ConnectionString = BuildConnectionString(); }