public void ProviderType_WhenProviderNameIsSql2008_ValueIsReflectedInProperty() { var connectionStringFake = new Mock<IConnectionString>(); connectionStringFake.Setup(f => f.Provider).Returns("Sql2008"); var connectionInfo = new SisoConnectionInfo(connectionStringFake.Object); Assert.AreEqual(StorageProviders.Sql2008, connectionInfo.ProviderType); }
public void CTor_ConnectionInfoWithDbName_ServerConnectionInfoGainsNoDbName() { var cnInfo = new SisoConnectionInfo( @"sisodb:provider=Sql2008||plain:Data Source=.\sqlexpress;Initial Catalog=DummyDb;Integrated Security=True"); var db = new SqlDatabase(cnInfo); Assert.AreEqual(@"Data Source=.\sqlexpress;Initial Catalog=;Integrated Security=True", db.ServerConnectionInfo.ConnectionString.PlainString); }
public void InitializeExisting_WhenDatabaseDoesNotExist_ThrowsSisoDbException() { DbHelper.DropDatabase(LocalConstants.TempDbName); var connectionInfo = new SisoConnectionInfo(LocalConstants.ConnectionStringNameForTemp); var db = new SqlDatabase(connectionInfo); Assert.Throws<SisoDbException>(() => db.InitializeExisting()); }
public void CTor_ConnectionInfoWithDbName_ExtractsCorrectDbName() { var cnInfo = new SisoConnectionInfo( @"sisodb:provider=Sql2008||plain:Data Source=.\sqlexpress;Initial Catalog=DummyDb;Integrated Security=True"); var db = new SqlDatabase(cnInfo); Assert.AreEqual("DummyDb", db.Name); }
public void ForServerConnection_WhenServerExists_ConnectionIsAgainstMaster() { var connectionInfo = new SisoConnectionInfo(LocalConstants.ConnectionStringNameForTemp); var db = new SqlDatabase(connectionInfo); using (var dbClient = new SqlDbClient(db.ServerConnectionInfo, false)) { Assert.AreEqual("master", dbClient.DbName); } }
public void Exists_WhenItExists_ReturnsTrue() { DbHelper.EnsureDbExists(LocalConstants.TempDbName); var connectionInfo = new SisoConnectionInfo(LocalConstants.ConnectionStringNameForTemp); var db = new SqlDatabase(connectionInfo); var dbExists = db.Exists(); Assert.IsTrue(dbExists); }
public SisoDbContactRepository() { string connectionString = WebConfigurationManager.ConnectionStrings["default"] .ConnectionString; var connectionInfo = new SisoConnectionInfo( string.Format(@"sisodb:provider=Sql2008||plain:{0}", connectionString)); var factory = new SisoDbFactory(); _database = factory.CreateDatabase(connectionInfo); _database.CreateIfNotExists(); }
public void ForDatabaseConnection_WhenDatabaseExists_ConnectionIsAgainstSpecifiedDb() { DbHelper.EnsureDbExists(LocalConstants.TempDbName); var connectionInfo = new SisoConnectionInfo(LocalConstants.ConnectionStringNameForTemp); var db = new SqlDatabase(connectionInfo); using (var dbClient = new SqlDbClient(db.ConnectionInfo, false)) { Assert.AreEqual("SisoDb.IntegrationTests.Temp", dbClient.DbName); } }
public void InitializeExisting_WhenDatabaseExists_CreatesSisoSysTables() { DbHelper.EnsureDbExists(LocalConstants.TempDbName); var connectionInfo = new SisoConnectionInfo(LocalConstants.ConnectionStringNameForTemp); var db = new SqlDatabase(connectionInfo); db.InitializeExisting(); var identitiesTableExists = DbHelper.TableExists("SisoDbIdentities"); Assert.IsTrue(identitiesTableExists); }
public void DeleteIfExists_WhenDatabaseExists_DatabaseGetsDropped() { DbHelper.EnsureDbExists(LocalConstants.TempDbName); var connectionInfo = new SisoConnectionInfo(LocalConstants.ConnectionStringNameForTemp); var db = new SqlDatabase(connectionInfo); db.DeleteIfExists(); var dbExists = db.Exists(); Assert.IsFalse(dbExists); }
public void CreateIfNotExists_WhenNoDatabaseExists_DatabaseGetsCreated() { DbHelper.DropDatabase(LocalConstants.TempDbName); var connectionInfo = new SisoConnectionInfo(LocalConstants.ConnectionStringNameForTemp); var db = new SqlDatabase(connectionInfo); db.CreateIfNotExists(); var dbExists = DbHelper.DatabaseExists(LocalConstants.TempDbName); Assert.IsTrue(dbExists); }
static void Main(string[] args) { Console.WriteLine("Hi. Goto the Profiling-app and open Program.cs and ensure that you are satisfied with the connection string."); Console.ReadKey(); return; var cnInfo = new SisoConnectionInfo(@"sisodb:provider=Sql2008||plain:Data source=.;Initial catalog=SisoDbLab;Integrated security=SSPI;"); var db = new SisoDatabase(cnInfo); db.EnsureNewDatabase(); ProfilingInserts(db, 1000, 5); Console.ReadKey(); }
public void Initialize() { var connectionInfo = new SisoConnectionInfo(LocalConstants.ConnectionStringName); var database = new SisoDatabase(connectionInfo); database.EnsureNewDatabase(); }