private static SqlLongString CreateData(IQuery query, byte[] data)
{
var lob = query.Session.CreateLargeObject(2048, true);
using (var stream = new ObjectStream(lob)) {
stream.Write(data, 0, data.Length);
stream.Flush();
}
lob.Complete();
return(SqlLongString.Ascii(lob));
}
private static SqlLongString CreateBio(IQuery query, string text)
{
var lob = query.Session.CreateLargeObject(2048, true);
using (var stream = new ObjectStream(lob)) {
using (var streamWriter = new StreamWriter(stream, Encoding.ASCII)) {
streamWriter.Write(text);
streamWriter.Flush();
}
}
lob.Complete();
return(SqlLongString.Ascii(lob));
}
private void AddTestData(string testName, IQuery query)
{
var tableName = ObjectName.Parse("APP.test_table");
var table = query.Access().GetMutableTable(tableName);
var row = table.NewRow();
row["id"] = Field.Integer(1);
row["name"] = Field.String("Antonello Provenzano");
row["age"] = Field.Integer(35);
if (testName.EndsWith("Lob"))
{
row["bio"] = Field.Clob(SqlLongString.Unicode(query, "Some bio about Antonello that is stored in the database"));
}
table.AddRow(row);
}
public static Field Clob(SqlLongString s)
{
return(new Field(PrimitiveTypes.Clob(s.Encoding, (int)s.Length), s));
}
private SqlLongString CreateBio(string text)
{
return(SqlLongString.Ascii(AdminQuery, text));
}
private SqlLongString CreateClobData(IQuery query)
{
const string text = "One simple small string to trigger the LOB data for the test";
return(SqlLongString.Ascii(query, text));
}
