public void ToStatement_OneFilter_ShouldReturnExpectedSqlString()
{
var factory = new SqlCeFactory();
var @params = new List <IDataParameter>();
var paramValue = factory.AddParam(1, @params);
Assert.AreEqual("@p0", paramValue);
Assert.AreEqual(1, @params.Count);
}
public void CreateTable_WithOnePrimaryKeyAttribute_ShouldCreateConstraint()
{
var store = SqlCeFactory.CreateStore("CreateTable_WithOnePrimaryKeyAttribute_ShouldCreateConstraint.sdf");
store.AddType <Book>();
if (store.StoreExists)
{
store.DeleteStore();
}
store.CreateStore();
var sql = "SELECT COUNT(*) FROM information_schema.table_constraints WHERE CONSTRAINT_NAME = \'ORM_PK_Book\'";
Assert.AreEqual(1, store.ExecuteScalar(sql));
}
public void Init()
{
var datasource = TestContext.CurrentContext.Test.MethodName + ".sdf";
Debug.WriteLine(string.Format("Database is available here:{0}", Path.Combine(TestContext.CurrentContext.WorkDirectory, datasource)));
DataStore = SqlCeFactory.CreateStore(datasource);
if (DataStore.StoreExists)
{
DataStore.DeleteStore();
}
DataStore.AddType <Book>();
DataStore.AddType <BookVersion>();
DataStore.CreateOrUpdateStore();
DataStore.Cache = new EntitiesCache();
BookRepository = new BookRepository(DataStore);
DatastoreNoCache = SqlCeFactory.CreateStore(datasource);
DatastoreNoCache.AddType <Book>();
DatastoreNoCache.AddType <BookVersion>();
NoCachedBookVersionRepository = new BookVersionRepository(DatastoreNoCache);
BookVersionRepository = new BookVersionRepository(DataStore);
}
public void CreateTable_WithOneIndexAttribute_ShouldCreateIndex()
{
var store = SqlCeFactory.CreateStore("CreateTable_WithIndexAttribute_ShouldCreateIndex.sdf");
store.AddType <IndexedClass>();
if (store.StoreExists)
{
store.DeleteStore();
}
store.CreateStore();
var sql = "SELECT COUNT(*) FROM information_schema.indexes WHERE INDEX_NAME = \'ORM_IDX_IndexedClass_MonIndex_ASC\'";
Assert.AreEqual(4, store.ExecuteScalar(sql));
sql = "SELECT COUNT(*) FROM information_schema.indexes WHERE INDEX_NAME = \'ORM_IDX_IndexedClass_Searchable_ASC\'";
Assert.AreEqual(1, store.ExecuteScalar(sql));
sql = "SELECT COUNT(*) FROM information_schema.indexes WHERE INDEX_NAME = \'ORM_IDX_IndexedClass_Unique_ASC\'";
Assert.AreEqual(1, store.ExecuteScalar(sql));
sql = "SELECT COUNT(*) FROM information_schema.indexes WHERE INDEX_NAME = \'ORM_IDX_IndexedClass_SearchableAndUnique_ASC\'";
Assert.AreEqual(1, store.ExecuteScalar(sql));
}
protected override ISqlDataStore CreateStore(string datasource)
{
return(SqlCeFactory.CreateStore(datasource));
}
protected virtual ISqlDataStore CreateStore(string datasource)
{
return(SqlCeFactory.CreateStore(datasource));
}
