public override IMigrationProcessor Create(string connectionString, IAnnouncer announcer, IMigrationProcessorOptions options)
{
var factory = new SqlServerDbFactory();
var accessTokenFactory = new AccessTokenFactory(_clientId, _certThumbPrint, StoreLocation.CurrentUser);
var accessToken = accessTokenFactory.GetTokenAsync(_authority, "https://database.windows.net/").GetAwaiter().GetResult();
var connection = new SqlConnection(connectionString)
{
AccessToken = accessToken
};
return(new SqlServerProcessor(connection, new SqlServer2014Generator(), announcer, options, factory));
}
static void Main(string[] args)
{
// Registering databases is optional. You can create a SqlServerDatabase directly from
// the connection string if you prefer.
var factory = new SqlServerDbFactory("Server=localhost\\SqlExpress;Database=BizArkTest;Trusted_Connection=Yes;");
BaDatabase.Register("MyDatabase", factory.Create);
//NOTE: If you want to run this project, the database is located in the BizArk.Data.Tests project (Data directory).
BaTableObjectExamples.CreatePerson();
//BaTableObjectExamples.UpdateBirthDate();
Console.WriteLine("Press any key to exit.");
Console.ReadKey(true);
}
public void RegisterSqlServerDbFactoryTest()
{
var connStr1 = "db=test1";
var connStr2 = "db=test2";
var factory = new SqlServerDbFactory(connStr1);
BaDatabase.Register("test1", factory.Create);
factory = new SqlServerDbFactory(connStr2);
BaDatabase.Register("test2", factory.Create);
var db = BaDatabase.Create("test1") as SqlServerDatabase;
Assert.IsNotNull(db);
Assert.AreEqual(connStr1, db.ConnectionString);
db = BaDatabase.Create("test2") as SqlServerDatabase;
Assert.IsNotNull(db);
Assert.AreEqual(connStr2, db.ConnectionString);
BaDatabase.Unregister("test1");
BaDatabase.Unregister("test2");
}
