public void Run()
{
using (var context = new Context(SetUpCodeFirst.Connection))
{
TableWithSeveralFieldsType table = new TableWithSeveralFieldsType()
{
MyInt = 10,
MyString = " My current string with leading and trailing spaces ",
MyDateTime = new DateTime(1969, 09, 15, 20, 03, 19)
};
context.TableWithSeveralFieldsTypes.Add(table);
context.SaveChanges();
Console.WriteLine(context.TableWithSeveralFieldsTypes.Select(c => new { c.MyDateTime.Day }).First().Day);
#pragma warning disable 618
Console.WriteLine(context.TableWithSeveralFieldsTypes.Select(c => new { Date = EntityFunctions.AddDays(c.MyDateTime, 4) }).First());
Console.WriteLine(context.TableWithSeveralFieldsTypes.Select(c => new { ElapsedDays = EntityFunctions.DiffDays(c.MyDateTime, c.MyDateTime) }).First().ElapsedDays.Value);
#pragma warning restore 618
// ReSharper disable StringIndexOfIsCultureSpecific.1
Console.WriteLine(context.TableWithSeveralFieldsTypes.Select(c => c.MyString.IndexOf(CanonicalFunctionsTest1.MyStringValue.Substring(5, 4))).First());
// ReSharper restore StringIndexOfIsCultureSpecific.1
Console.WriteLine(context.TableWithSeveralFieldsTypes.Where(c => c.MyString.Contains(CanonicalFunctionsTest1.MyStringValue.Substring(3, 5))).First());
Console.WriteLine(context.TableWithSeveralFieldsTypes.Where(c => c.MyString.StartsWith(CanonicalFunctionsTest1.MyStringValue.Substring(3, 5))).FirstOrDefault());
Console.WriteLine(context.TableWithSeveralFieldsTypes.Where(c => c.MyString.StartsWith(CanonicalFunctionsTest1.MyStringValue.Substring(0, 5))).First());
string stringEnd = CanonicalFunctionsTest1.MyStringValue.Substring(CanonicalFunctionsTest1.MyStringValue.Length - 5, 5);
//Console.WriteLine(context.TableWithSeveralFieldsTypes.Where(c => c.MyString.EndsWith(CanonicalFunctionsTest.MYSTRINGVALUE.Substring(CanonicalFunctionsTest.MYSTRINGVALUE.Length - 5, 5))).First());
Console.WriteLine(context.TableWithSeveralFieldsTypes.Where(c => c.MyString.EndsWith(stringEnd)).First());
}
}
public override void Seed()
{
TableWithSeveralFieldsType table = new TableWithSeveralFieldsType()
{
MyInt = MYINT,
MyDouble = 12.34,
MyString = "Another student",
MyDateTime = new DateTime(1969, 09, 15, 20, 03, 19),
MyBool = true,
MyNullableBool = false
};
Context.TableWithSeveralFieldsTypes.Add(table);
Context.SaveChanges();
}
public void Initialize()
{
Context context = new Context(SetUpCodeFirst.Connection);
TableWithSeveralFieldsType table = new TableWithSeveralFieldsType()
{
MyInt = 10,
MyDouble = MyDoubleValue,
MyString = MyStringValue,
MyDateTime = new DateTime(1969, 09, 15, 20, 03, 19)
};
context.TableWithSeveralFieldsTypes.Add(table);
context.SaveChanges();
context.Dispose();
_insertedRecordId = table.Id;
}
public void Init()
{
Context context = new Context(SetUpCodeFirst.Connection);
TableWithSeveralFieldsType table = new TableWithSeveralFieldsType()
{
MyInt = MYINT,
MyDouble = 12.34,
MyString = "Another student",
MyDateTime = new DateTime(1969, 09, 15, 20, 03, 19),
MyBool = true,
MyNullableBool = false
};
context.TableWithSeveralFieldsTypes.Add(table);
context.SaveChanges();
context.Dispose();
}
public void Initialize()
{
Context context = new Context(SetUpCodeFirst.Connection);
for (int i = 0; i < 30; i++)
{
TableWithSeveralFieldsType table = new TableWithSeveralFieldsType()
{
MyInt = new Random().Next(300),
MyDouble = MYDOUBLEVALUE,
MyString = MYSTRINGVALUE,
MyDateTime = new DateTime(1969, 09, 15, 20, 03, 19)
};
context.TableWithSeveralFieldsTypes.Add(table);
context.SaveChanges();
}
context.Dispose();
}