public void test_if_ormlite_sql_prepare_update_works_for_image_blobs()
{
var dbFactory = new OrmLiteConnectionFactory(ConnectionString, SqlServerOrmLiteDialectProvider.Instance);
using (var db = dbFactory.OpenDbConnection())
using (var dbConn = db.CreateCommand())
{
dbConn.CreateTable <ImageBlobDto>(true);
var dto = new ImageBlobDto()
{
Image1 = ImageToBytes(ImageBlobResource.Bild),
Image2 = ImageToBytes(ImageBlobResource.Bild2),
Image3 = ImageToBytes(ImageBlobResource.Bild3),
Complex = new object[] { "Foo", "Bar", "Baz", 1 }
};
var provider = OrmLiteConfig.DialectProvider as OrmLiteDialectProviderBase;
Assert.NotNull(provider);
using (var insertCmd = db.CreateInsertStatement(dto))
{
var nInserted = insertCmd.ExecuteNonQuery();
Assert.Greater(nInserted, 0);
}
dto.Id = 1;
dto.Complex = new object[] { "Baz", "Bar", "Foo", 2 };
using (var updateCmd = db.CreateUpdateStatement(dto))
{
var nUpdated = updateCmd.ExecuteNonQuery();
Assert.Greater(nUpdated, 0);
}
}
}
public void test_if_ormlite_sql_text_insert_works_for_image_blobs()
{
var dbFactory = new OrmLiteConnectionFactory(ConnectionString, SqlServerOrmLiteDialectProvider.Instance);
using (var db = dbFactory.OpenDbConnection())
using (var dbConn = db.CreateCommand())
{
dbConn.CreateTable <ImageBlobDto>(true);
var dto = new ImageBlobDto()
{
Image1 = ImageToBytes(ImageBlobResource.Bild),
Image2 = ImageToBytes(ImageBlobResource.Bild2),
Image3 = ImageToBytes(ImageBlobResource.Bild3)
};
dbConn.Insert(dto);
Assert.Greater(0, dbConn.GetLastInsertId());
}
}
