/// <summary>Creates a new ModelWithOnlyStringFields.</summary> /// <param name="id">The identifier.</param> /// <returns>The ModelWithOnlyStringFields.</returns> public static ModelWithOnlyStringFields Create(string id) { ModelWithOnlyStringFields modelWithOnlyStringField = new ModelWithOnlyStringFields(); modelWithOnlyStringField.Id = id; modelWithOnlyStringField.Name = "Name"; modelWithOnlyStringField.AlbumId = "AlbumId"; modelWithOnlyStringField.AlbumName = "AlbumName"; return modelWithOnlyStringField; }
/// <summary>Creates a new ModelWithOnlyStringFields.</summary> /// <param name="id">The identifier.</param> /// <returns>The ModelWithOnlyStringFields.</returns> 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_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 void Can_get_data_from_TableWithNamigStrategy_with_GetById() { OrmLite.OrmLiteConfig.DialectProvider.NamingStrategy = OrmLite.OrmLiteConfig.DialectProvider.NamingStrategy = new PrefixNamingStrategy { TablePrefix = "tab_", ColumnPrefix = "col_", }; using (var db = OpenDbConnection()) { db.CreateTable<ModelWithOnlyStringFields>(true); ModelWithOnlyStringFields m = new ModelWithOnlyStringFields() { Id= "999", AlbumId = "112", AlbumName="ElectroShip", Name = "MyNameIsBatman"}; db.Save<ModelWithOnlyStringFields>(m); var modelFromDb = db.GetById<ModelWithOnlyStringFields>("999"); Assert.AreEqual(m.Name, modelFromDb.Name); } OrmLite.OrmLiteConfig.DialectProvider.NamingStrategy= new OrmLiteNamingStrategyBase(); }
public void Can_select_with_filter_from_ModelWithOnlyStringFields_table() { using (var db = OpenDbConnection()) { 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); 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)); } }
public void Can_get_data_from_TableWithNamigStrategy_AfterChangingNamingStrategy() { OrmLite.OrmLiteConfig.DialectProvider.NamingStrategy = OrmLite.OrmLiteConfig.DialectProvider.NamingStrategy = new PrefixNamingStrategy { TablePrefix = "tab_", ColumnPrefix = "col_", }; using (var db = OpenDbConnection()) { 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); modelFromDb = db.GetById<ModelWithOnlyStringFields>("998"); Assert.AreEqual(m.Name, modelFromDb.Name); } OrmLite.OrmLiteConfig.DialectProvider.NamingStrategy= new OrmLiteNamingStrategyBase(); using (var db = OpenDbConnection()) { 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); modelFromDb = db.GetById<ModelWithOnlyStringFields>("998"); Assert.AreEqual(m.Name, modelFromDb.Name); } OrmLite.OrmLiteConfig.DialectProvider.NamingStrategy = OrmLite.OrmLiteConfig.DialectProvider.NamingStrategy = new PrefixNamingStrategy { TablePrefix = "tab_", ColumnPrefix = "col_", }; using (var db = OpenDbConnection()) { 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); modelFromDb = db.GetById<ModelWithOnlyStringFields>("998"); Assert.AreEqual(m.Name, modelFromDb.Name); } OrmLite.OrmLiteConfig.DialectProvider.NamingStrategy= new OrmLiteNamingStrategyBase(); }
public void Can_get_data_from_TableWithUnderscoreSeparatedCompoundNamingStrategy_with_ReadConnectionExtension() { OrmLiteConfig.DialectProvider.NamingStrategy = new UnderscoreSeparatedCompoundNamingStrategy(); using (var db = OpenDbConnection()) { db.CreateTable<ModelWithOnlyStringFields>(true); var m = new ModelWithOnlyStringFields { Id = "997", AlbumId = "112", AlbumName = "ElectroShip", Name = "ReadConnectionExtensionFirst" }; db.Save(m); var modelFromDb = db.First<ModelWithOnlyStringFields>(x => x.Name == "ReadConnectionExtensionFirst"); Assert.AreEqual(m.AlbumName, modelFromDb.AlbumName); } OrmLiteConfig.DialectProvider.NamingStrategy = new OrmLiteNamingStrategyBase(); }