public void MapingNotAutoIncPk()
{
var db = new SqlCeDocumentStore<MonkeyDocument>(_connectionStringName);
var pkMap = db.TableMapping.PrimaryKeyMapping;
Assert.Single(pkMap);
Assert.Equal("Name", pkMap[0].PropertyName);
Assert.Equal("Name", pkMap[0].ColumnName);
Assert.Equal(typeof(string), pkMap[0].DataType);
Assert.False(pkMap[0].IsAutoIncementing);
}
public void MapingNotAutoIncPk()
{
var db = new SqlCeDocumentStore <MonkeyDocument>(_connectionStringName);
var pkMap = db.TableMapping.PrimaryKeyMapping;
Assert.Single(pkMap);
Assert.Equal("Name", pkMap[0].PropertyName);
Assert.Equal("Name", pkMap[0].ColumnName);
Assert.Equal(typeof(string), pkMap[0].DataType);
Assert.False(pkMap[0].IsAutoIncementing);
}
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 void Bulk_Inserts_Documents_With_String_PK()
{
int INSERT_QTY = 100;
var addRange = new List<MonkeyDocument>();
for (int i = 0; i < INSERT_QTY; i++) {
addRange.Add(new MonkeyDocument { Name = "MONKEY " + i, Birthday = DateTime.Today, Description = "The Monkey on my back" });
}
IBiggyStore<MonkeyDocument> monkeyDocuments = new SqlCeDocumentStore<MonkeyDocument>(_connectionStringName);
var inserted = monkeyDocuments.Add(addRange);
// Reload, make sure everything was persisted:
var monkeys = new BiggyList<MonkeyDocument>(new SqlCeDocumentStore<MonkeyDocument>(_connectionStringName));
Assert.True(monkeys.Count() == INSERT_QTY);
}
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 void Bulk_Inserts_Documents_With_String_PK()
{
int INSERT_QTY = 100;
var addRange = new List <MonkeyDocument>();
for (int i = 0; i < INSERT_QTY; i++)
{
addRange.Add(new MonkeyDocument {
Name = "MONKEY " + i, Birthday = DateTime.Today, Description = "The Monkey on my back"
});
}
IBiggyStore <MonkeyDocument> monkeyDocuments = new SqlCeDocumentStore <MonkeyDocument>(_connectionStringName);
var inserted = monkeyDocuments.Add(addRange);
// Reload, make sure everything was persisted:
var monkeys = new BiggyList <MonkeyDocument>(new SqlCeDocumentStore <MonkeyDocument>(_connectionStringName));
Assert.True(monkeys.Count() == INSERT_QTY);
}
public void IBiggyDocumentStore_Add_A_Lot_Of_Records()
{
_clientDocs = new SqlCeDocumentStore<ClientDocument>(_connectionStringName);
int recordsCnt = 500;
List<ClientDocument> clients = new List<ClientDocument>(500);
foreach (var i in Enumerable.Range(0, recordsCnt))
{
clients.Add(new ClientDocument {
Email = "client" + i + "@domain.com",
FirstName = "client#" + i,
LastName = "last#" + i
});
}
var result = _clientDocs.BulkInsert(clients);
// check for Pks
Assert.Equal(recordsCnt, result.Last().ClientDocumentId);
var newList = _clientDocs.LoadAll();
Assert.Equal(recordsCnt, newList.Count);
}
public void IBiggyDocumentStore_Add_A_Lot_Of_Records()
{
_clientDocs = new SqlCeDocumentStore <ClientDocument>(_connectionStringName);
int recordsCnt = 500;
List <ClientDocument> clients = new List <ClientDocument>(500);
foreach (var i in Enumerable.Range(0, recordsCnt))
{
clients.Add(new ClientDocument {
Email = "client" + i + "@domain.com",
FirstName = "client#" + i,
LastName = "last#" + i
});
}
var result = _clientDocs.BulkInsert(clients);
// check for Pks
Assert.Equal(recordsCnt, result.Last().ClientDocumentId);
var newList = _clientDocs.LoadAll();
Assert.Equal(recordsCnt, newList.Count);
}
