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.DropAndCreateTable<ModelWithOnlyStringFields>();
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_with_query_by_example()
{
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);
}
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();
}