public void Can_GetById_from_basic_persistence_provider() { using (var db = new OrmLiteConnectionFactory(ConnectionString, FirebirdDialect.Provider).Open()) { db.DropAndCreateTable <ModelWithFieldsOfDifferentTypes>(); //var basicProvider = new OrmLitePersistenceProvider(db); var row = ModelWithFieldsOfDifferentTypes.Create(1); db.Insert(row); var providerRow = db.SingleById <ModelWithFieldsOfDifferentTypes>(1); ModelWithFieldsOfDifferentTypes.AssertIsEqual(providerRow, row); } }
public void Can_Store_from_basic_persistence_provider() { using (var db = new OrmLiteConnectionFactory(ConnectionString, FirebirdDialect.Provider).Open()) { db.DropAndCreateTable <ModelWithFieldsOfDifferentTypes>(); var basicProvider = new OrmLitePersistenceProvider(db); var rowIds = new List <int> { 1, 2, 3, 4, 5 }; var rows = rowIds.ConvertAll(x => ModelWithFieldsOfDifferentTypes.Create(x)); rows.ForEach(x => basicProvider.Store(x)); var getRowIds = new[] { 2, 4 }; var providerRows = db.SelectByIds <ModelWithFieldsOfDifferentTypes>(getRowIds).ToList(); var providerRowIds = providerRows.ConvertAll(x => x.Id); Assert.That(providerRowIds, Is.EquivalentTo(getRowIds)); } }
public void Can_Delete_from_basic_persistence_provider() { using (var db = new OrmLiteConnectionFactory(ConnectionString, FirebirdDialect.Provider).Open()) { db.DropAndCreateTable <ModelWithFieldsOfDifferentTypes>(); var basicProvider = new OrmLitePersistenceProvider(db); var rowIds = new List <int> { 1, 2, 3, 4, 5 }; var rows = rowIds.ConvertAll(x => ModelWithFieldsOfDifferentTypes.Create(x)); rows.ForEach(x => db.Insert(x)); var deleteRowIds = new List <int> { 2, 4 }; foreach (var row in rows) { if (deleteRowIds.Contains(row.Id)) { basicProvider.Delete(row); } } var providerRows = basicProvider.GetByIds <ModelWithFieldsOfDifferentTypes>(rowIds).ToList(); var providerRowIds = providerRows.ConvertAll(x => x.Id); var remainingIds = new List <int>(rowIds); deleteRowIds.ForEach(x => remainingIds.Remove(x)); Assert.That(providerRowIds, Is.EquivalentTo(remainingIds)); } }