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()); } }