public void GenerateProceduresFromExistingDatabaseTest()
{
// Arrange
var dbFactory = new SqlServerDatabaseFactory
{
ConnectionString = "server=(local);database=Store;integrated security=yes;"
};
// Act
var database = dbFactory.Import();
foreach (var table in database.Tables)
{
var codeBuilder = new SqlStoredProcedureCodeBuilder
{
Table = table,
OutputDirectory = "C:\\Temp\\CatFactory.SqlServer\\StoredProceduresExistingDatabase",
ForceOverwrite = true
};
codeBuilder.CreateFile();
}
// Assert
}
public void GenerateProceduresFromMockDatabaseTest()
{
// Arrange
var database = Databases.Store;
// Act
foreach (var table in database.Tables)
{
var codeBuilder = new SqlStoredProcedureCodeBuilder
{
Table = table,
OutputDirectory = "C:\\Temp\\CatFactory.SqlServer\\StoredProceduresMockingDatabase",
ForceOverwrite = true
};
codeBuilder.CreateFile();
}
// Assert
}
public void ScaffoldProceduresFromMockDatabaseTest()
{
// Arrange
var database = Databases.Blogging;
// Act
foreach (var table in database.Tables)
{
var codeBuilder = new SqlStoredProcedureCodeBuilder
{
Database = database,
Table = table,
OutputDirectory = @"C:\Temp\CatFactory.SqlServer\StoredProceduresFromMockingDatabase",
ForceOverwrite = true
};
codeBuilder.CreateFile();
}
// Assert
}
public async Task ScaffoldProceduresFromExistingDatabaseAsync()
{
// Arrange
var database = await SqlServerDatabaseFactory
.ImportAsync("server=(local);database=OnlineStore;integrated security=yes;");
// Act
foreach (var table in database.Tables)
{
var codeBuilder = new SqlStoredProcedureCodeBuilder
{
Database = database,
Table = table,
OutputDirectory = @"C:\Temp\CatFactory.SqlServer\StoredProceduresFromExistingDatabase",
ForceOverwrite = true
};
codeBuilder.CreateFile();
}
// Assert
}
