public void test_if_ormlite_sql_prepare_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),
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);
for (int i = 2; i < 101; i++)
{
dto.Complex = new object[] { "Foo", "Bar", "Baz", i };
insertCmd.ReparameterizeInsert(dto);
Assert.Greater(insertCmd.ExecuteNonQuery(), 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());
}
}
