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)); }