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