public void Can_loop_each_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 dbRowIds = new List <string>();
var rows = db.Each <ModelWithOnlyStringFields>("AlbumName = {0}", filterRow.AlbumName);
foreach (var row in rows)
{
dbRowIds.Add(row.Id);
}
Assert.That(dbRowIds, Has.Count.EqualTo(1));
Assert.That(dbRowIds[0], Is.EqualTo(filterRow.Id));
}
}
public void Can_loop_each_string_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 dbRowIds = new List <string>();
foreach (var row in db.Each <ModelWithOnlyStringFields>())
{
dbRowIds.Add(row.Id);
}
Assert.That(dbRowIds, Is.EquivalentTo(rowIds));
}
}
public void Can_loop_each_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 dbRowIds = new List<string>();
var rows = db.Each<ModelWithOnlyStringFields>("AlbumName = {0}", filterRow.AlbumName);
foreach (var row in rows)
{
dbRowIds.Add(row.Id);
}
Assert.That(dbRowIds, Has.Count.EqualTo(1));
Assert.That(dbRowIds[0], Is.EqualTo(filterRow.Id));
}
}
public void Can_loop_each_string_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 dbRowIds = new List<string>();
foreach (var row in db.Each<ModelWithOnlyStringFields>())
{
dbRowIds.Add(row.Id);
}
Assert.That(dbRowIds, Is.EquivalentTo(rowIds));
}
}