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