public void SimpleCRUDTest()
{
var store = new SqlCeDataStore("test.sdf");
store.AddType <TestItem>();
store.CreateStore();
var itemA = new TestItem("ItemA");
var itemB = new TestItem("ItemB");
var itemC = new TestItem("ItemC");
// INSERT
store.Insert(itemA);
store.Insert(itemB);
store.Insert(itemC);
// COUNT
var count = store.Count <TestItem>();
Assert.AreEqual(3, count);
// SELECT
var item = store.Select <TestItem>("Name", itemB.Name).FirstOrDefault();
Assert.IsTrue(item.Equals(itemB));
item = store.Select <TestItem>(3);
Assert.IsTrue(item.Equals(itemC));
// FETCH
// UPDATE
itemC.Name = "NewItem";
itemC.Address = "Changed Address";
itemC.TS = new TimeSpan(8, 23, 30);
store.Update(itemC);
item = store.Select <TestItem>("Name", "ItemC").FirstOrDefault();
Assert.IsNull(item);
item = store.Select <TestItem>("Name", itemC.Name).FirstOrDefault();
Assert.IsTrue(item.Equals(itemC));
// CONTAINS
var exists = store.Contains(itemA);
Assert.IsTrue(exists);
// DELETE
store.Delete(itemA, false);
item = store.Select <TestItem>("Name", itemA.Name).FirstOrDefault();
Assert.IsNull(item);
// CONTAINS
exists = store.Contains(itemA);
Assert.IsFalse(exists);
// COUNT
count = store.Count <TestItem>();
Assert.AreEqual(2, count);
}
private SqlCeDataStore Initialize()
{
var store = new SqlCeDataStore("pubs.sdf");
if (store.StoreExists)
{
store.DeleteStore();
}
store.ConnectionBehavior = ConnectionBehavior.Persistent;
Stopwatch sw = new Stopwatch();
sw.Start();
store.DiscoverTypes(Assembly.GetExecutingAssembly());
sw.Stop();
Debug.WriteLine(string.Format("SQL CE Store Discover:\t{0}s", sw.Elapsed.TotalSeconds));
sw.Start();
store.CreateStore();
sw.Stop();
Debug.WriteLine(string.Format("SQL CE Store Create:\t{0}", sw.Elapsed.TotalSeconds));
CreateTestData(store);
return(store);
}
public void SimpleTransactionTest()
{
var store = new SqlCeDataStore("test_trans.sdf");
store.AddType <LateAddItem>();
if (store.StoreExists)
{
store.DeleteStore();
}
store.CreateStore();
var testEntity = new LateAddItem()
{
ID = -1
};
store.Insert(testEntity);
var id = testEntity.ID;
store.BeginTransaction();
store.Delete <LateAddItem>(id);
// timeout here, at insert
store.Insert(new LateAddItem()
{
ID = -1
});
store.Commit();
}
public void BasicLocalReplicationTest()
{
var source = new SqlCeDataStore("source.sdf");
if (!source.StoreExists)
{
source.CreateStore();
}
source.AddType <TestItem>();
var destination = new SqlCeDataStore("dest.sdf");
if (!destination.StoreExists)
{
destination.CreateStore();
}
// build a replictor to send data to the destiantion store
var replicator = new Replicator(destination, ReplicationBehavior.ReplicateAndDelete);
// replication is opt-in, so tell it what type(s) we want to replicate
replicator.RegisterEntity <TestItem>();
// add the replicator to the source
source.Replicators.Add(replicator);
// watch an event for when data batches go out
replicator.DataReplicated += delegate
{
// get a count
Debug.WriteLine(string.Format("Sent {0} rows", replicator.GetCount <TestItem>()));
};
var rows = 200;
// put some data in the source
for (int i = 0; i < rows; i++)
{
var item = new TestItem(string.Format("Item {0}", i));
source.Insert(item);
}
int remaining = 0;
// loop until the source table is empty
do
{
Thread.Sleep(500);
remaining = source.Count <TestItem>();
} while(remaining > 0);
// make sure the destination has all rows
Assert.AreEqual(rows, destination.Count <TestItem>());
}
public void BuildCleanDB()
{
m_store = new SqlCeDataStore("testDB.sdf");
if (m_store.StoreExists)
{
m_store.DeleteStore();
}
m_store.CreateStore();
m_store.AddType <TestItem>();
}
public DataService()
{
m_store = new SqlCeDataStore("MyData.sdf");
m_store.DeleteStore();
if (!m_store.StoreExists)
{
m_store.CreateStore();
}
m_store.AddType <Customer>();
m_store.AddType <ProductOrder>();
m_store.AddType <ShipAddress>();
m_store.AddType <State>();
m_store.EnsureCompatibility();
}
public void SimpleCRUDTest()
{
bool beforeInsert = false;
bool afterInsert = false;
bool beforeUpdate = false;
bool afterUpdate = false;
bool beforeDelete = false;
bool afterDelete = false;
var store = new SqlCeDataStore("simpleCRUDTest.sdf");
store.AddType <TestItem>();
store.CreateStore();
store.BeforeInsert += delegate
{
beforeInsert = true;
};
store.AfterInsert += delegate
{
afterInsert = true;
};
store.BeforeUpdate += delegate
{
beforeUpdate = true;
};
store.AfterUpdate += delegate
{
afterUpdate = true;
};
store.BeforeDelete += delegate
{
beforeDelete = true;
};
store.AfterDelete += delegate
{
afterDelete = true;
};
var itemA = new TestItem("ItemA");
itemA.UUID = Guid.NewGuid();
itemA.ITest = 5;
itemA.FTest = 3.14F;
itemA.DBTest = 1.4D;
itemA.DETest = 2.678M;
var itemB = new TestItem("ItemB");
var itemC = new TestItem("ItemC");
// INSERT
store.Insert(itemA);
Assert.IsTrue(beforeInsert, "BeforeInsert never fired");
Assert.IsTrue(afterInsert, "AfterInsert never fired");
store.Insert(itemB);
store.Insert(itemC);
// COUNT
var count = store.Count <TestItem>();
Assert.AreEqual(3, count);
// SELECT
var items = store.Select <TestItem>();
Assert.AreEqual(3, items.Count());
var item = store.Select <TestItem>("Name", itemB.Name).FirstOrDefault();
Assert.IsTrue(item.Equals(itemB));
item = store.Select <TestItem>(3);
Assert.IsTrue(item.Equals(itemC));
// FETCH
// UPDATE
itemC.Name = "NewItem";
itemC.Address = "Changed Address";
itemC.TS = new TimeSpan(8, 23, 30);
itemC.BigString = "little string";
// test rollback
store.BeginTransaction();
store.Update(itemC);
item = store.Select <TestItem>(3);
Assert.IsTrue(item.Name == itemC.Name);
store.Rollback();
item = store.Select <TestItem>(3);
Assert.IsTrue(item.Name != itemC.Name);
// test commit
store.BeginTransaction(System.Data.IsolationLevel.Unspecified);
store.Update(itemC);
store.Commit();
Assert.IsTrue(beforeUpdate, "BeforeUpdate never fired");
Assert.IsTrue(afterUpdate, "AfterUpdate never fired");
item = store.Select <TestItem>("Name", "ItemC").FirstOrDefault();
Assert.IsNull(item);
item = store.Select <TestItem>("Name", itemC.Name).FirstOrDefault();
Assert.IsTrue(item.Equals(itemC));
// CONTAINS
var exists = store.Contains(itemA);
Assert.IsTrue(exists);
// DELETE
store.Delete(itemA);
Assert.IsTrue(beforeDelete, "BeforeDelete never fired");
Assert.IsTrue(afterDelete, "AfterDelete never fired");
item = store.Select <TestItem>("Name", itemA.Name).FirstOrDefault();
Assert.IsNull(item);
// CONTAINS
exists = store.Contains(itemA);
Assert.IsFalse(exists);
// COUNT
count = store.Count <TestItem>();
Assert.AreEqual(2, count);
// this will create the table in newer versions of ORM
store.AddType <LateAddItem>();
var newitems = store.Select <LateAddItem>(false);
Assert.IsNotNull(newitems);
}
public void Initialize()
{
Store = new SqlCeDataStore("pubs.sdf");
if (Store.StoreExists)
{
Store.DeleteStore();
}
Store.ConnectionBehavior = ConnectionBehavior.Persistent;
Stopwatch sw = new Stopwatch();
sw.Start();
Store.DiscoverTypes(Assembly.GetExecutingAssembly());
sw.Stop();
Debug.WriteLine(string.Format("SQL CE Store Discover:\t{0}s", sw.Elapsed.TotalSeconds));
sw.Start();
Store.CreateStore();
sw.Stop();
Debug.WriteLine(string.Format("SQL CE Store Create:\t{0}", sw.Elapsed.TotalSeconds));
CreateTestData();
}
public void BasicDynamicCRUDTest()
{
var fieldList = new List <FieldAttribute>();
fieldList.Add(new FieldAttribute()
{
FieldName = "ID",
IsPrimaryKey = true,
DataType = System.Data.DbType.Int32
});
fieldList.Add(new FieldAttribute()
{
FieldName = "FirstName",
DataType = System.Data.DbType.String
});
fieldList.Add(new FieldAttribute()
{
FieldName = "LastName",
DataType = System.Data.DbType.String,
AllowsNulls = false
});
var definition = new DynamicEntityDefinition("People", fieldList, KeyScheme.Identity);
var store = new SqlCeDataStore(Path.Combine(TestContext.TestDir, "test.sdf"));
store.CreateStore();
Assert.IsFalse(store.TableExists(definition.EntityName));
store.RegisterDynamicEntity(definition);
Assert.IsTrue(store.TableExists(definition.EntityName));
var entity = new DynamicEntity("People");
entity.Fields["FirstName"] = "John";
entity.Fields["LastName"] = "Doe";
store.Insert(entity);
entity = new DynamicEntity("People");
entity.Fields["FirstName"] = "Jim";
entity.Fields["LastName"] = "Smith";
store.Insert(entity);
entity = new DynamicEntity("People");
entity.Fields["FirstName"] = "Sam";
entity.Fields["LastName"] = "Adams";
store.Insert(entity);
var items = store.Select("People");
DumpData(items);
store.Delete("People", items.First().Fields["ID"]);
items = store.Select("People");
DumpData(items);
store.Delete("People", "LastName", "Smith");
items = store.Select("People");
DumpData(items);
var person = items.First();
person.Fields["FirstName"] = "Joe";
person.Fields["LastName"] = "Satriani";
store.Update(person);
items = store.Select("People");
DumpData(items);
// now let's change the structure and see what happens
fieldList.Add(new FieldAttribute()
{
FieldName = "Middle_Name",
DataType = System.Data.DbType.Double,
AllowsNulls = true // this has to be true to add a column
});
var newDefinition = new DynamicEntityDefinition("People", fieldList, KeyScheme.Identity);
store.RegisterDynamicEntity(newDefinition, true);
items = store.Select("People");
}