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();
}