public void Save_blob_and_retrieve_it_fetches_it_from_contents_column()
{
SqlServerUtility.RemoveAllTablesFromDefaultDatabase(TestDatabases.SqlServerLobTests);
var configuration = new Configuration();
configuration.SetProperty("connection.provider", typeof(ExternalBlobDriverConnectionProvider).AssemblyQualifiedName);
configuration.SetProperty("dialect", typeof(MsSql2008Dialect).AssemblyQualifiedName);
configuration.SetProperty("connection.driver_class", typeof(SqlClientDriver).AssemblyQualifiedName);
configuration.SetProperty("connection.connection_string", TestDatabases.SqlServerLobTests);
configuration.SetProperty("connection.lob.external.provider", typeof(ByteArrayConnectionProvider).AssemblyQualifiedName);
configuration.SetProperty("show_sql", "true");
configuration.AddAssembly(typeof(Image).Assembly);
new SchemaExport(configuration).Execute(false, true, false);
ISessionFactory sessionFactory = configuration.BuildSessionFactory();
var image = new Image
{
FileName = "test.txt",
ContentType = "text/plain",
Size = 10,
Contents = Blob.Create(new byte[] { 1, 2, 3, 4 }),
Title = "test"
};
Guid imageId;
using (ISession session = sessionFactory.OpenSession())
{
using (ITransaction tx = session.BeginTransaction())
{
session.Save(image);
tx.Commit();
imageId = image.Id;
}
}
using (ISession session = sessionFactory.OpenSession())
{
using (ITransaction tx = session.BeginTransaction())
{
var imageFromDb = session.Get <Image>(imageId);
using (Stream streamReader = imageFromDb.Contents.OpenReader())
{
var buffer = new byte[1024];
int length = streamReader.Read(buffer, 0, buffer.Length);
Assert.Equal(4, length);
Assert.Equal(1, buffer[0]);
Assert.Equal(2, buffer[1]);
Assert.Equal(3, buffer[2]);
Assert.Equal(4, buffer[3]);
}
}
}
}
public void SetFixture(TempFolder data)
{
SqlServerUtility.RemoveAllTablesFromDefaultDatabase(TestDatabases.SqlServerLobTests);
_folder = data.Folder;
}