// SqlCe has an open session limit - bulk inserts have to be precisely implemented public SqlCeBulkInsertsTest() { var context = new SqlCeCache(_connectionStringName); // Build a table to play with from scratch each time: if (context.TableExists("Client")) { context.DropTable("Client"); } var columnDefs = new List <string>(); columnDefs.Add("ClientId int IDENTITY(1,1) PRIMARY KEY NOT NULL"); columnDefs.Add("LastName nText NOT NULL"); columnDefs.Add("FirstName nText NOT NULL"); columnDefs.Add("Email nText NOT NULL"); context.CreateTable("Client", columnDefs); // Build a table to play with from scratch each time: if (context.TableExists("ClientDocuments")) { context.DropTable("ClientDocuments"); } if (context.TableExists("MonkeyDocuments")) { context.DropTable("MonkeyDocuments"); } }
public SqlCeDocumentStoreTest() { var context = new SqlCeCache(_connectionStringName); // Build a table to play with from scratch each time: if (context.TableExists("ClientDocuments")) { context.DropTable("ClientDocuments"); } if (context.TableExists("MonkeyDocuments")) { context.DropTable("MonkeyDocuments"); } clientDocs = new SqlCeDocumentStore<ClientDocument>(_connectionStringName); monkeyDocs = new SqlCeDocumentStore<MonkeyDocument>(_connectionStringName); }
public SqlCeDocumentStoreTest() { var context = new SqlCeCache(_connectionStringName); // Build a table to play with from scratch each time: if (context.TableExists("ClientDocuments")) { context.DropTable("ClientDocuments"); } if (context.TableExists("MonkeyDocuments")) { context.DropTable("MonkeyDocuments"); } clientDocs = new SqlCeDocumentStore <ClientDocument>(_connectionStringName); monkeyDocs = new SqlCeDocumentStore <MonkeyDocument>(_connectionStringName); }
public SqlCeCacheTest() { _context = new SqlCeCache(_connectionStringName); if (_context.TableExists("test_table")) { _context.DropTable("test_table"); } }
public SqlCeContextTest() { _context = new SqlCeCache(_connectionStringName); if (_context.TableExists("test_table")) { _context.DropTable("test_table"); } }
// SqlCe has an open session limit - bulk inserts have to be precisely implemented public SqlCeBulkInsertsTest() { var context = new SqlCeCache(_connectionStringName); // Build a table to play with from scratch each time: if (context.TableExists("Client")) { context.DropTable("Client"); } var columnDefs = new List<string>(); columnDefs.Add("ClientId int IDENTITY(1,1) PRIMARY KEY NOT NULL"); columnDefs.Add("LastName nText NOT NULL"); columnDefs.Add("FirstName nText NOT NULL"); columnDefs.Add("Email nText NOT NULL"); context.CreateTable("Client", columnDefs); // Build a table to play with from scratch each time: if (context.TableExists("ClientDocuments")) { context.DropTable("ClientDocuments"); } if (context.TableExists("MonkeyDocuments")) { context.DropTable("MonkeyDocuments"); } }
public BiggyListWithSQL() { var context = new SqlCeCache("chinook"); // Build a table to play with from scratch each time: if (context.TableExists("Client")) { context.DropTable("Client"); } var columnDefs = new List <string>(); columnDefs.Add("ClientId int IDENTITY(1,1) PRIMARY KEY NOT NULL"); columnDefs.Add("LastName nText NOT NULL"); columnDefs.Add("FirstName nText NOT NULL"); columnDefs.Add("Email nText NOT NULL"); context.CreateTable("Client", columnDefs); _clients = new BiggyList <Client>(new SqlCeStore <Client>(_connectionStringName)); }
public void Creates_New_Table_With_Arbitrary_SQL() { var exists = _context.TableExists("test_table"); Assert.False(exists); }