public override IDataProvider CreateDataProvider(string connectionString) { var provider = new SQLite3DataProvider(connectionString); provider.ExecuteNonQuery( SQLite3.Raw("CREATE TABLE [TableExistsTest] ([Column1] INT)") ); return(provider); }
public void Single_Flat_POCO() { using (var dataProvider = new SQLite3DataProvider("Data Source=:memory:;Mode=Memory")) { var schema = new SchemaBuilder() .Define <FlatPoco>() .Build(); var table = new EntityTable <FlatPoco>(schema, dataProvider); var store = new SqlEntityStore <FlatPoco>(schema, dataProvider); var entity = new FlatPoco { String = "Test String" }; new[]
public void Insert_Maps_Generated_Primary_Key() { var entity = new WithIntPK(); using (var dataProvider = new SQLite3DataProvider("Data Source=:memory:;Mode=Memory")) { var schema = new SchemaBuilder() .Define <WithIntPK>() .Build(); var table = new EntityTable <WithIntPK>(schema, dataProvider); var sqlEntityStore = new SqlEntityStore <WithIntPK>(schema, dataProvider); table.CreateTable().Execute(); sqlEntityStore.Insert(entity).Execute(); } Assert.AreNotEqual(0, entity.Id); }