private static void Main()
{
var context = new ValueConversionsContext();
CreateDatabase(context);
Console.Clear();
DisplayDemoStep("Add a new be true to the database");
context.BeTrues.Add(new BeTrue
{
DaNe = true,
Dn = true,
JaNein = true,
Jn = true,
MyOwnTruth = true,
HisOwnTruth = true,
HerOwnTruth = true,
OneMinusOne = true,
TrueFalse = true,
YesNo = true,
Yn = true,
SiNo = true,
Sn = true
});
context.SaveChanges();
Console.ReadLine();
DisplayDemoStep("Get some be trues from the database");
context.BeTrues.Where(beTrue =>
beTrue.DaNe ||
beTrue.Dn ||
beTrue.JaNein ||
beTrue.Jn ||
!beTrue.MyOwnTruth ||
!beTrue.HisOwnTruth ||
!beTrue.HerOwnTruth ||
!beTrue.OneMinusOne ||
!beTrue.TrueFalse ||
!beTrue.YesNo ||
!beTrue.Yn ||
!beTrue.SiNo ||
!beTrue.Sn
)
.ToList();
Console.ReadLine();
DisplayDemoStep("Get all be trues from the database");
foreach (var beTrue in context.BeTrues.ToList())
{
DisplayText(beTrue.MyOwnTruth.ToString());
}
}
private static void Main()
{
var context = new ValueConversionsContext();
CreateDatabase(context);
Console.Clear();
DisplayDemoStep("Add a few entities to the database");
for (int i = 0; i < 5; i++)
{
context.SomeEntities.Add(new SomeEntity
{
SomeDateTime = DateTime.Now,
SomeGuid = Guid.NewGuid(),
SomeInt = new Random().Next(1_000_000),
SomeDouble = new Random().NextDouble() * 10_000,
SomeEnum = (SomeEnum) new Random().Next(3),
SomeFlagsEnum = SomeFlagsEnum.First | SomeFlagsEnum.Second
});
private static void Main()
{
var context = new ValueConversionsContext();
CreateDatabase(context);
Console.Clear();
DisplayDemoStep("Add a few entities to the database");
for (int i = 0; i < 5; i++)
{
context.SomeEntities.Add(new SomeEntity
{
SomeDateTime = DateTime.Now.AddYears(-i),
SomeGuid = Guid.Empty,
SomeInt = -i,
SomeDouble = double.MinValue + i,
});
}
context.SaveChanges();
Console.ReadLine();
int someInt = -4;
DisplayDemoStep($"Get the entity with {nameof(SomeEntity.SomeInt)} equals to {someInt}");
var entity = context.SomeEntities.FirstOrDefault(entity => entity.SomeInt == someInt);
if (entity is null)
{
DisplayText($"The entity with {nameof(SomeEntity.SomeInt)} equals to {someInt} NOT found.");
}
else
{
DisplayText($"The entity with {nameof(SomeEntity.SomeInt)} equals to {someInt} found.");
}
Console.ReadLine();
someInt = 0;
DisplayDemoStep($"Get entities with {nameof(SomeEntity.SomeInt)} less then {someInt}");
var entities = context.SomeEntities.Where(entity => entity.SomeInt < someInt).ToList();
if (!entities.Any())
{
DisplayText($"Entities with {nameof(SomeEntity.SomeInt)} less then {someInt} NOT found.");
}
else
{
DisplayText($"Entities with {nameof(SomeEntity.SomeInt)} less then {someInt} found.");
}
Console.ReadLine();
DisplayDemoStep($"Add additional entities and get them ordered by {nameof(SomeEntity.SomeInt)}");
for (int i = 0; i < 5; i++)
{
context.SomeEntities.Add(new SomeEntity
{
SomeDateTime = DateTime.Now.AddYears(i),
SomeGuid = Guid.Empty,
SomeInt = i,
SomeDouble = double.MinValue + i,
});
}
context.SaveChanges();
entities = context.SomeEntities.OrderBy(entity => entity.SomeInt).ToList();
foreach (var someEntity in entities)
{
DisplayText(someEntity.SomeInt.ToString());
}
Console.ReadLine();
}