public IActionResult insertar()
{
using (var db = new LinqContext())
{
var sistemax = new software();
var sistemax2 = new software();
var sietmeax3 = new software();
sistemax.os = "Linux";
sistemax.nombre = "Atom";
sistemax.precio = 30;
sistemax2.os = "Windos";
sistemax2.nombre = "Visual";
sistemax2.precio = 0;
sietmeax3.os = "Os X";
sietmeax3.nombre = "Sublime text";
sietmeax3.precio = 100;
var lista = new List <software>()
{
sistemax, sistemax2, sietmeax3
};
db.software.AddRange(lista);
db.SaveChanges();
}
return(View());
}
private static void TestLocal()
{
int desertSunId;
using (var db = new LinqContext())
{
var startCity = new Club {
Name = "Star City Chess Club", City = "New York"
};
var desertSun = new Club {
Name = "Desert Sun Chess Club", City = "Phoenix"
};
var palmTree = new Club {
Name = "Palm Tree Chess Club", City = "San Diego"
};
db.Clubs.Add(startCity);
db.Clubs.Add(desertSun);
db.Clubs.Add(palmTree);
db.SaveChanges();
desertSunId = desertSun.ClubId;
}
using (var db = new LinqContext())
{
Console.WriteLine("\nLocal Collection Behavior");
Console.WriteLine("===============");
Console.WriteLine($"\nNumber of Clubs Contained in Local Collection:{db.Clubs.Local.Count}");
Console.WriteLine("================");
Console.WriteLine("\nClubs Retrived from Context Object");
Console.WriteLine("================");
foreach (var club in db.Clubs.Take(2))
{
Console.WriteLine($"{club.Name} is located in {club.City}");
}
Console.WriteLine("\nClubs Contained in Context Local Collection");
Console.WriteLine("=================");
foreach (var club in db.Clubs.Local)
{
Console.WriteLine($"{club.Name} is located in {club.City}");
}
db.Clubs.Find(desertSunId);
Console.WriteLine("\nClubs Retrived form Context Object - Revisted");
Console.WriteLine("===============");
foreach (var club in db.Clubs)
{
Console.WriteLine($"{club.Name} is located in {club.City}");
}
Console.WriteLine("\nClubs Contained in Context Local Collection - Revisted");
Console.WriteLine("==============");
foreach (var club in db.Clubs.Local)
{
Console.WriteLine($"{club.Name} is localed in {club.City}");
}
var localClubs = db.Clubs.Local;
var lonesomePintId = -999;
localClubs.Add(new Club
{
City = "Portland",
Name = "Lonesone Pine",
ClubId = lonesomePintId
});
localClubs.Remove(db.Clubs.Find(desertSunId));
Console.WriteLine("\nClub Contained in Context Object - After Adding and Deleting");
Console.WriteLine("=============");
foreach (var club in db.Clubs)
{
Console.WriteLine($"{club.Name} is located in {club.City} with a Entity State of {db.Entry(club).State}");
}
Console.WriteLine("\nClubs Contained in Context Local Collection - After Adding and Deleting");
Console.WriteLine("=============");
foreach (var club in localClubs)
{
Console.WriteLine($"{club.Name} is located in {club.City} with a Entity State of {db.Entry(club).State}");
}
Console.WriteLine("\nPress <enter> to continue");
Console.ReadLine();
}
}
