public void Can_get_data_from_TableWithNamigStrategy_with_query_by_example() { OrmLite.OrmLiteConfig.DialectProvider.NamingStrategy = OrmLite.OrmLiteConfig.DialectProvider.NamingStrategy = new PrefixNamingStrategy { TablePrefix = "tab_", ColumnPrefix = "col_", }; using (var db = new OrmLiteConnectionFactory(ConnectionString, FirebirdDialect.Provider).Open()) { db.CreateTable<ModelWithOnlyStringFields>(true); ModelWithOnlyStringFields m = new ModelWithOnlyStringFields() { Id = "998", AlbumId = "112", AlbumName = "ElectroShip", Name = "QueryByExample" }; db.Save<ModelWithOnlyStringFields>(m); var modelFromDb = db.Where<ModelWithOnlyStringFields>(new {Name = "QueryByExample"})[0]; Assert.AreEqual(m.Name, modelFromDb.Name); } OrmLite.OrmLiteConfig.DialectProvider.NamingStrategy = new OrmLiteNamingStrategyBase(); }
public static ModelWithOnlyStringFields Create(string id) { ModelWithOnlyStringFields modelWithOnlyStringField = new ModelWithOnlyStringFields(); modelWithOnlyStringField.Id = id; modelWithOnlyStringField.Name = "Name"; modelWithOnlyStringField.AlbumId = "AlbumId"; modelWithOnlyStringField.AlbumName = "AlbumName"; return modelWithOnlyStringField; }
public static ModelWithOnlyStringFields Create(string id) { ModelWithOnlyStringFields modelWithOnlyStringField = new ModelWithOnlyStringFields(); modelWithOnlyStringField.Id = id; modelWithOnlyStringField.Name = "Name"; modelWithOnlyStringField.AlbumId = "AlbumId"; modelWithOnlyStringField.AlbumName = "AlbumName"; return(modelWithOnlyStringField); }
public void Can_select_with_filter_from_ModelWithOnlyStringFields_table() { using (var db = new OrmLiteConnectionFactory(ConnectionString, FirebirdDialect.Provider).Open()) { db.CreateTable<ModelWithOnlyStringFields>(true); var rowIds = new List<string>(new[] {"id-1", "id-2", "id-3"}); rowIds.ForEach(x => db.Insert(ModelWithOnlyStringFields.Create(x))); var filterRow = ModelWithOnlyStringFields.Create("id-4"); filterRow.AlbumName = "FilteredName"; db.Insert(filterRow); var rows = db.Where<ModelWithOnlyStringFields>(new {filterRow.AlbumName}); var dbRowIds = rows.ConvertAll(x => x.Id); Assert.That(dbRowIds, Has.Count.EqualTo(1)); Assert.That(dbRowIds[0], Is.EqualTo(filterRow.Id)); rows = db.Where<ModelWithOnlyStringFields>(new {filterRow.AlbumName}); dbRowIds = rows.ConvertAll(x => x.Id); Assert.That(dbRowIds, Has.Count.EqualTo(1)); Assert.That(dbRowIds[0], Is.EqualTo(filterRow.Id)); var queryByExample = new ModelWithOnlyStringFields {AlbumName = filterRow.AlbumName}; rows = db.ByExampleWhere<ModelWithOnlyStringFields>(queryByExample, excludeNulls: true); dbRowIds = rows.ConvertAll(x => x.Id); Assert.That(dbRowIds, Has.Count.EqualTo(1)); Assert.That(dbRowIds[0], Is.EqualTo(filterRow.Id)); rows = db.Query<ModelWithOnlyStringFields>( "SELECT * FROM ModelWithOnlyStringFields WHERE AlbumName = @AlbumName", new {filterRow.AlbumName}); dbRowIds = rows.ConvertAll(x => x.Id); Assert.That(dbRowIds, Has.Count.EqualTo(1)); Assert.That(dbRowIds[0], Is.EqualTo(filterRow.Id)); } }