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