public void BlobWithoutLength()
{
if (Dialect is MySQLDialect)
{
Assert.Ignore("Not fixed for MySQLDialect, still generating a varchar(255) column for StringClob without length");
}
int id;
// buildup a string the exceed the mapping
string str = GetFixedLengthString12000();
using (ISession sess = OpenSession())
using (ITransaction tx = sess.BeginTransaction())
{
// create and save the entity
StringLengthEntity entity = new StringLengthEntity();
entity.Blob = str;
sess.Save(entity);
tx.Commit();
id = entity.ID;
}
using (ISession sess = OpenSession())
using (ITransaction tx = sess.BeginTransaction())
{
StringLengthEntity loaded = sess.Get <StringLengthEntity>(id);
Assert.IsNotNull(loaded);
Assert.AreEqual(12000, loaded.Blob.Length);
Assert.AreEqual(str, loaded.Blob);
tx.Commit();
}
}
public void StringSqlType()
{
int id;
// buildup a string the exceed the mapping
string str = GetFixedLengthString12000();
using (ISession sess = OpenSession())
using (ITransaction tx = sess.BeginTransaction())
{
// create and save the entity
StringLengthEntity entity = new StringLengthEntity();
entity.StringSqlType = str;
sess.Save(entity);
tx.Commit();
id = entity.ID;
}
using (ISession sess = OpenSession())
using (ITransaction tx = sess.BeginTransaction())
{
StringLengthEntity loaded = sess.Get <StringLengthEntity>(id);
Assert.IsNotNull(loaded);
Assert.AreEqual(12000, loaded.StringSqlType.Length);
Assert.AreEqual(str, loaded.StringSqlType);
tx.Commit();
}
}
public void BlobSqlType()
{
int id;
// buildup a string the exceed the mapping
string str = GetFixedLengthString12000();
using (ISession sess = OpenSession())
using (ITransaction tx = sess.BeginTransaction())
{
// create and save the entity
StringLengthEntity entity = new StringLengthEntity();
entity.BlobSqlType = str;
sess.Save(entity);
tx.Commit();
id = entity.ID;
}
using (ISession sess = OpenSession())
using (ITransaction tx = sess.BeginTransaction())
{
StringLengthEntity loaded = sess.Get<StringLengthEntity>(id);
Assert.IsNotNull(loaded);
Assert.AreEqual(12000, loaded.BlobSqlType.Length);
Assert.AreEqual(str, loaded.BlobSqlType);
tx.Commit();
}
}
public async Task BlobSqlTypeAsync()
{
int id;
// buildup a string the exceed the mapping
string str = GetFixedLengthString12000();
using (ISession sess = OpenSession())
using (ITransaction tx = sess.BeginTransaction())
{
// create and save the entity
StringLengthEntity entity = new StringLengthEntity();
entity.BlobSqlType = str;
await(sess.SaveAsync(entity));
await(tx.CommitAsync());
id = entity.ID;
}
using (ISession sess = OpenSession())
using (ITransaction tx = sess.BeginTransaction())
{
StringLengthEntity loaded = await(sess.GetAsync <StringLengthEntity>(id));
Assert.IsNotNull(loaded);
Assert.AreEqual(12000, loaded.BlobSqlType.Length);
Assert.AreEqual(str, loaded.BlobSqlType);
await(tx.CommitAsync());
}
}
public async Task StringHugeLengthAsync()
{
if (Sfi.ConnectionProvider.Driver is OdbcDriver || Dialect is MsSqlCeDialect)
{
Assert.Ignore("NH-4065, not fixed for Odbc and MsSqlCe");
}
int id;
// buildup a string the exceed the mapping
string str = GetFixedLengthString12000();
using (ISession sess = OpenSession())
using (ITransaction tx = sess.BeginTransaction())
{
// create and save the entity
StringLengthEntity entity = new StringLengthEntity();
entity.StringHugeLength = str;
await(sess.SaveAsync(entity));
await(tx.CommitAsync());
id = entity.ID;
}
using (ISession sess = OpenSession())
using (ITransaction tx = sess.BeginTransaction())
{
StringLengthEntity loaded = await(sess.GetAsync <StringLengthEntity>(id));
Assert.IsNotNull(loaded);
Assert.AreEqual(12000, loaded.StringHugeLength.Length);
Assert.AreEqual(str, loaded.StringHugeLength);
await(tx.CommitAsync());
}
}
public void StringHugeLength()
{
if (Sfi.ConnectionProvider.Driver is OdbcDriver)
{
Assert.Ignore("NH-4065, not fixed for Odbc");
}
int id;
// buildup a string the exceed the mapping
string str = GetFixedLengthString12000();
using (ISession sess = OpenSession())
using (ITransaction tx = sess.BeginTransaction())
{
// create and save the entity
StringLengthEntity entity = new StringLengthEntity();
entity.StringHugeLength = str;
sess.Save(entity);
tx.Commit();
id = entity.ID;
}
using (ISession sess = OpenSession())
using (ITransaction tx = sess.BeginTransaction())
{
StringLengthEntity loaded = sess.Get <StringLengthEntity>(id);
Assert.IsNotNull(loaded);
Assert.AreEqual(12000, loaded.StringHugeLength.Length);
Assert.AreEqual(str, loaded.StringHugeLength);
tx.Commit();
}
}
public void StringHugeLength()
{
if (Sfi.ConnectionProvider.Driver is OdbcDriver || Dialect is MsSqlCeDialect)
{
Assert.Ignore("NH-4065, not fixed for Odbc and MsSqlCe");
}
if (Dialect.GetTypeName(SqlTypeFactory.GetString(10000)) != Dialect.GetLongestTypeName(DbType.String))
{
Assert.Ignore("Current dialect does support limited strings of 10 000 characters");
}
int id;
// buildup a string the exceed the mapping
string str = GetFixedLengthString12000();
using (ISession sess = OpenSession())
using (ITransaction tx = sess.BeginTransaction())
{
// create and save the entity
StringLengthEntity entity = new StringLengthEntity();
entity.StringHugeLength = str;
sess.Save(entity);
tx.Commit();
id = entity.ID;
}
using (ISession sess = OpenSession())
using (ITransaction tx = sess.BeginTransaction())
{
StringLengthEntity loaded = sess.Get <StringLengthEntity>(id);
Assert.IsNotNull(loaded);
Assert.AreEqual(12000, loaded.StringHugeLength.Length);
Assert.AreEqual(str, loaded.StringHugeLength);
tx.Commit();
}
}