public void CreatesSerialPK()
{
var actors = new SQLDocumentList <Actor>("northwind");
var newActor = new Actor {
First_Name = "Joe", Last_Name = "Blow"
};
actors.Add(newActor);
Assert.True(newActor.Actor_ID > 0);
}
public static void Run()
{
Console.WriteLine("Connecting to SQL Document Store...");
var monkies = new SQLDocumentList <Monkey>("northwind");
monkies.Clear();
var sw = new Stopwatch();
sw.Start();
var addRange = new List <Monkey>();
for (int i = 0; i < 10000; i++)
{
addRange.Add(new Monkey {
ID = i, Name = "MONKEY " + i, Birthday = DateTime.Today, Description = "The Monkey on my back"
});
}
var inserted = monkies.AddRange(addRange);
sw.Stop();
Console.WriteLine("Just inserted {0} as documents in {1} ms", inserted, sw.ElapsedMilliseconds);
Console.WriteLine("Loading 100,000 documents");
sw.Reset();
addRange.Clear();
monkies.Clear();
sw.Start();
for (int i = 0; i < 100000; i++)
{
addRange.Add(new Monkey {
ID = i, Name = "MONKEY " + i, Birthday = DateTime.Today, Description = "The Monkey on my back"
});
}
inserted = monkies.AddRange(addRange);
sw.Stop();
Console.WriteLine("Just inserted {0} as documents in {1} ms", inserted, sw.ElapsedMilliseconds);
//use a DB that has an int PK
sw.Reset();
sw.Start();
Console.WriteLine("Loading {0}...", inserted);
monkies.Reload();
sw.Stop();
Console.WriteLine("Loaded {0} documents from SQL Server in {1}ms", inserted, sw.ElapsedMilliseconds);
sw.Reset();
sw.Start();
Console.WriteLine("Querying Middle 100 Documents");
var found = monkies.Where(x => x.ID > 100 && x.ID < 500);
sw.Stop();
Console.WriteLine("Queried {0} documents in {1}ms", found.Count(), sw.ElapsedMilliseconds);
}
public void Bulk_Inserts_Documents_With_String_PK()
{
int INSERT_QTY = 100;
var monkies = new SQLDocumentList<MonkeyDocument>("chinook");
monkies.Clear();
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" });
}
var inserted = monkies.AddRange(addRange);
Assert.True(inserted == INSERT_QTY);
}
public SQLServerDocs()
{
// Start fresh each time, with no existing table, to keep serial PK's from exploding:
if(this.TableExists("ClientDocuments")) {
this.DropTable("ClientDocuments");
}
if (this.TableExists("MonkeyDocuments")) {
this.DropTable("MonkeyDocuments");
}
clientDocs = new SQLDocumentList<ClientDocument>(_connectionStringName);
monkeyDocs = new SQLDocumentList<MonkeyDocument>(_connectionStringName);
clientDocs.Clear();
}
static void InsertsManyActors()
{
var actors = new SQLDocumentList <Actor>("northwind");
var bulkList = new List <Actor>();
for (int i = 0; i < 100; i++)
{
var newActor = new Actor {
First_Name = "Actor " + i, Last_Name = "Test"
};
bulkList.Add(newActor);
}
actors.AddRange(bulkList);
Assert.True(actors.Last().Actor_ID > 90);
}
public void CreatesSerialPK()
{
var actors = new SQLDocumentList <Actor>("northwind");
actors.Clear();
var newActor = new Actor {
First_Name = "Joe", Last_Name = "Blow"
};
actors.Add(newActor);
int newId = newActor.Actor_ID;
actors.Reload();
Assert.True(actors.Any(a => a.Actor_ID == newId));
}
static void InsertsManyMonkeys()
{
int INSERT_QTY = 10000;
var monkies = new SQLDocumentList <Monkey>("northwind");
monkies.Clear();
var addRange = new List <Monkey>();
for (int i = 0; i < INSERT_QTY; i++)
{
addRange.Add(new Monkey {
Name = "MONKEY " + i, Birthday = DateTime.Today, Description = "The Monkey on my back"
});
}
var inserted = monkies.AddRange(addRange);
Assert.True(inserted == INSERT_QTY && monkies.Count == inserted);
}
public SQLServerDocs()
{
docs = new SQLDocumentList <CustomerDocument>("northwind");
//drop and reload
docs.Clear();
}
static void Bulk_Inserts_Documents_With_Serial_PK()
{
int insertQty = 100;
var ClientDocuments = new SQLDocumentList<ClientDocument>("chinook");
var bulkList = new List<ClientDocument>();
for (int i = 0; i < insertQty; i++) {
var newClientDocument = new ClientDocument {
FirstName = "ClientDocument " + i,
LastName = "Test",
Email = "*****@*****.**"
};
bulkList.Add(newClientDocument);
}
int inserted = ClientDocuments.AddRange(bulkList);
// I have NO IDEA why this silliness suddenly became necessary (the .ToList().Last() bit).
// This test worked fine last nite. Now says SQLDocumentList<> has no extension Last() JA - 3/12/2014
Assert.True(inserted == insertQty && ClientDocuments.ToList().Last().ClientDocumentId > insertQty);
}
public static void Run()
{
Console.WriteLine("===========================================================");
Console.WriteLine("SQL SERVER - LOAD A BUNCH OF DOCUMENTS INTO A TABLE");
Console.WriteLine("===========================================================");
Console.WriteLine("Connecting to SQL Document Store...");
// Start clean and fresh . . .
if (Benchmarks.TableExists("clientdocuments"))
{
Benchmarks.DropTable("clientdocuments");
}
var _clientDocuments = new SQLDocumentList<ClientDocument>(_connectionStringName);
_clientDocuments.Clear();
var sw = new Stopwatch();
var addRange = new List<ClientDocument>();
for (int i = 0; i < 10000; i++)
{
addRange.Add(new ClientDocument
{
LastName = "Conery " + i,
FirstName = "Rob",
Email = "*****@*****.**"
});
}
sw.Start();
var inserted = _clientDocuments.AddRange(addRange);
sw.Stop();
Console.WriteLine("\t Just inserted {0} as documents in {1} ms", inserted, sw.ElapsedMilliseconds);
// Start clean and fresh again . . .
_clientDocuments.Clear();
addRange.Clear();
Benchmarks.DropTable("clientdocuments");
_clientDocuments = new SQLDocumentList<ClientDocument>(_connectionStringName);
sw.Reset();
Console.WriteLine("Loading 100,000 documents");
for (int i = 0; i < 100000; i++)
{
addRange.Add(new ClientDocument
{
LastName = "Conery " + i,
FirstName = "Rob",
Email = "*****@*****.**"
});
}
sw.Start();
inserted = _clientDocuments.AddRange(addRange);
sw.Stop();
Console.WriteLine("\t Just inserted {0} as documents in {1} ms", inserted, sw.ElapsedMilliseconds);
//use a DB that has an int PK
sw.Reset();
Console.WriteLine("Loading {0}...", inserted);
sw.Start();
_clientDocuments.Reload();
sw.Stop();
Console.WriteLine("\t Loaded {0} documents from SQL Server in {1} ms", inserted, sw.ElapsedMilliseconds);
sw.Reset();
Console.WriteLine("Querying Middle 100 Documents");
sw.Start();
var found = _clientDocuments.Where(x => x.ClientDocumentId > 100 && x.ClientDocumentId < 500);
sw.Stop();
Console.WriteLine("\t Queried {0} documents in {1}ms", found.Count(), sw.ElapsedMilliseconds);
sw.Reset();
Console.WriteLine("Adds Items in a loop, follows by Bulk Insert");
if (TableExists("items"))
{
DropTable("items");
}
sw.Start();
var list = new List<Item>();
for (int i = 1; i < 6; i++) {
list.Add(new Item() {
Name = "Item no " + i
});
}
var items = new SQLDocumentList<Item>("chinook");
// 1. Add items in a loop
foreach (var item in list) {
items.Add(item);
}
// 2. Add items using AddRange...
items.AddRange(list);
sw.Stop();
Console.WriteLine("\t Added {0} items in a loop, then added same items as bullk insert in {1}", list.Count(), sw.ElapsedMilliseconds);
}
public static void Run()
{
Console.WriteLine("===========================================================");
Console.WriteLine("SQL SERVER - LOAD A BUNCH OF DOCUMENTS INTO A TABLE");
Console.WriteLine("===========================================================");
Console.WriteLine("Connecting to SQL Document Store...");
// Start clean and fresh . . .
if(Benchmarks.TableExists("clientdocuments")) {
Benchmarks.DropTable("clientdocuments");
}
var _clientDocuments = new SQLDocumentList<ClientDocument>(_connectionStringName);
_clientDocuments.Clear();
var sw = new Stopwatch();
var addRange = new List<ClientDocument>();
for (int i = 0; i < 10000; i++) {
addRange.Add(new ClientDocument {
LastName = "Conery " + i,
FirstName = "Rob",
Email = "*****@*****.**" });
}
sw.Start();
var inserted = _clientDocuments.AddRange(addRange);
sw.Stop();
Console.WriteLine("\t Just inserted {0} as documents in {1} ms", inserted, sw.ElapsedMilliseconds);
// Start clean and fresh again . . .
_clientDocuments.Clear();
addRange.Clear();
Benchmarks.DropTable("clientdocuments");
_clientDocuments = new SQLDocumentList<ClientDocument>(_connectionStringName);
sw.Reset();
Console.WriteLine("Loading 100,000 documents");
for (int i = 0; i < 100000; i++) {
addRange.Add(new ClientDocument {
LastName = "Conery " + i,
FirstName = "Rob",
Email = "*****@*****.**"
});
}
sw.Start();
inserted = _clientDocuments.AddRange(addRange);
sw.Stop();
Console.WriteLine("\t Just inserted {0} as documents in {1} ms", inserted, sw.ElapsedMilliseconds);
//use a DB that has an int PK
sw.Reset();
Console.WriteLine("Loading {0}...", inserted);
sw.Start();
_clientDocuments.Reload();
sw.Stop();
Console.WriteLine("\t Loaded {0} documents from SQL Server in {1} ms", inserted, sw.ElapsedMilliseconds);
sw.Reset();
Console.WriteLine("Querying Middle 100 Documents");
sw.Start();
var found = _clientDocuments.Where(x => x.ClientDocumentId > 100 && x.ClientDocumentId < 500);
sw.Stop();
Console.WriteLine("\t Queried {0} documents in {1}ms", found.Count(), sw.ElapsedMilliseconds);
}
static void Bulk_Inserts_Documents_With_Serial_PK()
{
int insertQty = 100;
var ClientDocuments = new SQLDocumentList<ClientDocument>("chinook");
var bulkList = new List<ClientDocument>();
for (int i = 0; i < insertQty; i++) {
var newClientDocument = new ClientDocument {
FirstName = "ClientDocument " + i,
LastName = "Test",
Email = "*****@*****.**"
};
bulkList.Add(newClientDocument);
}
int inserted = ClientDocuments.AddRange(bulkList);
Assert.True(inserted == insertQty && ClientDocuments.Last().ClientDocumentId > insertQty);
}