private AllTypesTable Insert_WithValues()
{
var item = new AllTypesTable();
Execute(context => {
SetValues(item);
context.AllTypes.Add(item);
context.SaveChanges();
});
return(item);
}
public void Inserted_And_Retrieved_Values()
{
var item = new AllTypesTable();
var testTime = new DateTime(2012, 2, 6, 8, 51, 33);
using (var context = GetAllTypesDataContext()) {
item.BinaryChar = "binarychar";
item.BinaryMemo = "binarymemo";
item.BinaryVarChar = "binaryvarchar";
////item.Blob = Encoding.Default.GetBytes("blob");
item.Char = "char";
item.Currency = 1.2M;
item.Date = testTime;
item.DateTime = testTime;
item.Decimal = 3.45M;
item.Double = 5.6D;
item.Float = 7.8F;
item.Guid = new Guid("9211FB02-0654-41B7-82DA-6A38EC0DFD9A");
item.Integer = 199;
item.Logical = true;
item.Long = (long)int.MaxValue + 1;
item.Memo = "memo";
item.VarChar = "varchar";
context.AllTypes.Add(item);
context.SaveChanges();
}
using (var context = GetAllTypesDataContext()) {
var item2 = context.AllTypes.ToList().First();
Assert.AreEqual(item.BinaryChar, item2.BinaryChar);
Assert.AreEqual(item.BinaryMemo, item2.BinaryMemo);
Assert.AreEqual(item.BinaryVarChar, item2.BinaryVarChar);
////Assert.AreEqual(item.Blob, item2.Blob);
Assert.AreEqual(item.Char, item2.Char);
Assert.AreEqual(item.Currency, item2.Currency);
Assert.AreEqual(item.Date.Value.Date, item2.Date);
Assert.AreEqual(item.DateTime, item2.DateTime);
Assert.AreEqual(item.Decimal, item2.Decimal);
Assert.AreEqual(item.Double, item2.Double);
Assert.AreEqual(item.Float, item2.Float);
Assert.AreEqual(item.Guid, item2.Guid);
Assert.AreEqual(item.Integer, item2.Integer);
Assert.AreEqual(item.Logical, item2.Logical);
Assert.AreEqual(item.Long, item2.Long);
Assert.AreEqual(item.Memo, item2.Memo);
Assert.AreEqual(item.VarChar, item2.VarChar);
}
}
private void InsertEmptyValues(bool allowNulls)
{
using (var context = GetAllTypesDataContext()) {
var item = new AllTypesTable();
var builder = new VfpConnectionStringBuilder(context.Database.Connection.ConnectionString);
builder.Null = allowNulls;
context.Database.Connection.ConnectionString = builder.ConnectionString;
item.Guid = Guid.NewGuid();
context.AllTypes.Add(item);
context.SaveChanges();
}
}
private static void AssertEqual(AllTypesTable item, AllTypesTable item2)
{
Assert.Equal(item.Id, item2.Id);
Assert.Equal(item.BinaryChar, item2.BinaryChar);
Assert.Equal(item.BinaryMemo, item2.BinaryMemo);
Assert.Equal(item.BinaryVarChar, item2.BinaryVarChar);
Assert.Equal(item.Char, item2.Char);
Assert.Equal(item.Currency, item2.Currency);
Assert.Equal(item.Date.Value.Date, item2.Date);
Assert.Equal(item.DateTime, item2.DateTime);
Assert.Equal(item.Decimal, item2.Decimal);
Assert.Equal(item.Double, item2.Double);
Assert.Equal(item.Float, item2.Float);
Assert.Equal(item.Guid, item2.Guid);
Assert.Equal(item.Integer, item2.Integer);
Assert.Equal(item.Logical, item2.Logical);
Assert.Equal(item.Long, item2.Long);
Assert.Equal(item.Memo, item2.Memo);
Assert.Equal(item.VarChar, item2.VarChar);
}
private static void SetValues(AllTypesTable item)
{
var testTime = new DateTime(2012, 2, 6, 8, 51, 33);
item.BinaryChar = "binarychar";
item.BinaryMemo = "binarymemo";
item.BinaryVarChar = "binaryvarchar";
item.Char = "char";
item.Currency = 1.2M;
item.Date = testTime;
item.DateTime = testTime;
item.Decimal = 3.45M;
item.Double = 5.6D;
item.Float = 7.8F;
item.Guid = new Guid("9211FB02-0654-41B7-82DA-6A38EC0DFD9A");
item.Integer = 199;
item.Logical = true;
item.Long = (long)int.MaxValue + 1;
item.Memo = "memo";
item.VarChar = Guid.NewGuid().ToString().Substring(9);
}
private AllTypesTable Insert_WithEmptyValues(bool allowNulls)
{
var item = new AllTypesTable();
Execute(context => {
var connection = context.Database.GetDbConnection();
var builder = new VfpConnectionStringBuilder(connection.ConnectionString)
{
Null = allowNulls
};
connection.ConnectionString = builder.ConnectionString;
item.Guid = Guid.NewGuid();
context.AllTypes.Add(item);
context.SaveChanges();
});
return(item);
}
private int FindMaxTypeID()
{
try { return(AllTypesTable.Select(x => x.Id).Max()); } catch { return(0); }
}
