public void Can_Delete_from_basic_persistence_provider()
{
using (var db = OpenDbConnection())
{
db.CreateTable<ModelWithFieldsOfDifferentTypes>(true);
var basicProvider = new OrmLitePersistenceProvider(db);
var rowIds = new List<int> { 1, 2, 3, 4, 5 };
var rows = rowIds.ConvertAll(ModelWithFieldsOfDifferentTypes.Create);
rows.ForEach(x => { x.Id = (int)db.Insert(x, selectIdentity: true); });
var deleteRowIds = new List<int> { rows[1].Id, rows[3].Id };
var getRowIds = rows.ConvertAll(x => x.Id);
rows.Where(row => deleteRowIds.Contains(row.Id)).ToList().ForEach(basicProvider.Delete);
var providerRows = basicProvider.GetByIds<ModelWithFieldsOfDifferentTypes>(getRowIds).ToList();
var providerRowIds = providerRows.ConvertAll(x => x.Id);
var remainingIds = rows.ConvertAll(x => x.Id);
deleteRowIds.ForEach(x => remainingIds.Remove(x));
Assert.That(providerRowIds, Is.EquivalentTo(remainingIds));
}
}
public void Can_Delete_from_basic_persistence_provider()
{
using (var db = ConnectionString.OpenDbConnection())
{
db.CreateTable<ModelWithFieldsOfDifferentTypes>(true);
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));
}
}
public void Can_GetById_from_basic_persistence_provider()
{
using (var db = ConnectionString.OpenDbConnection())
{
db.CreateTable<ModelWithFieldsOfDifferentTypes>(true);
var basicProvider = new OrmLitePersistenceProvider(db);
var row = ModelWithFieldsOfDifferentTypes.Create(1);
db.Insert(row);
var providerRow = basicProvider.GetById<ModelWithFieldsOfDifferentTypes>(1);
ModelWithFieldsOfDifferentTypes.AssertIsEqual(providerRow, row);
}
}
public void Load_Northwind_database_with_OrmLite_sqlite_memory_db()
{
NorthwindData.LoadData(false);
GC.Collect();
var stopWatch = new Stopwatch();
stopWatch.Start();
using (var db = ":memory:".OpenDbConnection())
{
using (var client = new OrmLitePersistenceProvider(db))
{
OrmLiteNorthwindTests.CreateNorthwindTables(db);
LoadNorthwindData(client);
}
}
Console.WriteLine("stopWatch.ElapsedMilliseconds: " + stopWatch.ElapsedMilliseconds);
}
public void Load_Northwind_database_with_ormlite_postgresql()
{
OrmLiteConfig.DialectProvider = PostgreSQLDialectProvider.Instance;
NorthwindData.LoadData(false);
GC.Collect();
var stopWatch = new Stopwatch();
stopWatch.Start();
using (var db = OpenDbConnection())
{
using (var client = new OrmLitePersistenceProvider(db))
{
OrmLiteNorthwindTests.CreateNorthwindTables(db);
LoadNorthwindData(client);
}
}
Console.WriteLine("stopWatch.ElapsedMilliseconds: " + stopWatch.ElapsedMilliseconds);
}
public void Can_Store_from_basic_persistence_provider()
{
using (var db = ConnectionString.OpenDbConnection())
{
db.CreateTable<ModelWithFieldsOfDifferentTypes>(true);
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.GetByIds<ModelWithFieldsOfDifferentTypes>(getRowIds).ToList();
var providerRowIds = providerRows.ConvertAll(x => x.Id);
Assert.That(providerRowIds, Is.EquivalentTo(getRowIds));
}
}
public void Load_Northwind_database()
{
OrmLiteConfig.DialectProvider = new FirebirdOrmLiteDialectProvider();
NorthwindData.LoadData(false);
GC.Collect();
var stopWatch = new Stopwatch();
stopWatch.Start();
using (var dbConn = "User=SYSDBA;Password=masterkey;Database=/var/lib/firebird/2.1/data/NorthWind.fdb;DataSource=localhost;Dialect=3;charset=ISO8859_1;".OpenDbConnection())
using (var dbCmd = dbConn.CreateCommand())
{
using (var client = new OrmLitePersistenceProvider(dbConn))
{
OrmLiteNorthwindTests.CreateNorthwindTables(dbCmd);
LoadNorthwindData(client);
}
}
Console.WriteLine("stopWatch.ElapsedMilliseconds: " + stopWatch.ElapsedMilliseconds);
}
public void Can_GetByIds_from_basic_persistence_provider()
{
using (var db = ConnectionString.OpenDbConnection())
using (var dbCmd = db.CreateCommand())
{
dbCmd.CreateTable <ModelWithFieldsOfDifferentTypes>(true);
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 => dbCmd.Insert(x));
var getRowIds = new[] { 2, 4 };
var providerRows = basicProvider.GetByIds <ModelWithFieldsOfDifferentTypes>(getRowIds).ToList();
var providerRowIds = providerRows.ConvertAll(x => x.Id);
Assert.That(providerRowIds, Is.EquivalentTo(getRowIds));
}
}
public OrmLitePersistenceProviderCache(ICacheClient cacheClient, IDbConnection dbConnection)
: base(cacheClient)
{
provider = new OrmLitePersistenceProvider(dbConnection);
}
public OrmLitePersistenceProviderCache(ICacheClient cacheClient, string connectionString)
: base(cacheClient)
{
provider = new OrmLitePersistenceProvider(connectionString);
}
public OrmLitePersistenceProviderCache(ICacheClient cacheClient, IDbConnection dbConnection)
: base(cacheClient)
{
provider = new OrmLitePersistenceProvider(dbConnection);
}
public OrmLitePersistenceProviderCache(ICacheClient cacheClient, string connectionString)
: base(cacheClient)
{
provider = new OrmLitePersistenceProvider(connectionString);
}
