// 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 void Execute_Abritrary_SQL()
{
var columnDefs = new List <string>();
columnDefs.Add("id int IDENTITY(1,1) PRIMARY KEY");
columnDefs.Add("name nTEXT");
_context.CreateTable("test_table", columnDefs);
Assert.True(_context.TableExists("test_table") && _context.DbTableNames.Contains("test_table"));
}
public SqlCeStoreTest()
{
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);
}
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));
}
