public static DataTable GetContentsOf(string tableName)
{
using (var dbContext = new ProductsDbContext())
using (var connection = new SqlCeConnection(dbContext.Database.Connection.ConnectionString))
using (var command = connection.CreateCommand())
{
var sql = "SELECT* FROM " + tableName;
command.CommandText = sql;
var adapter = new SqlCeDataAdapter(command);
var dataSet = new DataSet();
adapter.Fill(dataSet);
return dataSet.Tables[0];
}
//var connection = new SqlConnection(ConnectionString);
//using (connection)
//{
// connection.Open();
// var command = new SqlCommand("SELECT * FROM " + tableName, connection);
// var adapter = new SqlDataAdapter(command);
// var dataSet = new DataSet();
// adapter.Fill(dataSet);
// return dataSet.Tables[0];
//}
}
public BuilderSettings DoSetup()
{
DbConfiguration.SetConfiguration(new IntegrationTestConfiguration());
using (var db = new ProductsDbContext())
{
db.Database.Delete();
}
BuilderSettings builderSettings = new BuilderSettings();
if (_setup)
return builderSettings;
_setup = true;
var productRepository = Dependency.Resolve<IProductRepository>();
var taxTypeRepository = Dependency.Resolve<ITaxTypeRepository>();
var categoryRepository = Dependency.Resolve<ICategoryRepository>();
builderSettings.SetCreatePersistenceMethod<Product>(productRepository.Create);
builderSettings.SetCreatePersistenceMethod<IList<Product>>(productRepository.CreateAll);
builderSettings.SetCreatePersistenceMethod<TaxType>(taxTypeRepository.Create);
builderSettings.SetCreatePersistenceMethod<IList<TaxType>>(taxTypeRepository.CreateAll);
builderSettings.SetCreatePersistenceMethod<Category>(categoryRepository.Create);
builderSettings.SetCreatePersistenceMethod<IList<Category>>(categoryRepository.CreateAll);
builderSettings.SetUpdatePersistenceMethod<Category>(categoryRepository.Save);
builderSettings.SetUpdatePersistenceMethod<IList<Category>>(categoryRepository.SaveAll);
return builderSettings;
}
