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