static void Main(string[] args) { using var context = new MundialDBContext(); //var player1 = new Player(); //player1.FullName = "Cristiano Ronaldo"; //player1.Dorsal = 7; //context.Player.Add(player1); //context.SaveChanges(); //var player2 = new Player(); //player2.FullName = "Lionel Messi"; //player2.Dorsal = 10; //var player3 = new Player(); //player3.FullName = "Paolo Guerrero"; //player3.Dorsal = 9; //var player4 = new Player(); //player4.FullName = "Gianluca Lapadula"; //player4.Dorsal = 21; //var players = new List<Player>(); //players.Add(player2); //players.Add(player3); //players.Add(player4); //context.Player.AddRange(players); //context.SaveChanges(); //LINQ Expressions //var searchPlayer = (from p in context.Player // where p.Dorsal == 9 // select p).FirstOrDefault(); //Console.WriteLine("Jugador Encontrado: " // + searchPlayer.FullName // + " Dorsal: " + searchPlayer.Dorsal); //context.Player.Remove(searchPlayer); //context.SaveChanges(); //Console.WriteLine("Jugador eliminado"); //var searchPlayer = (from p in context.Player // where p.Dorsal == 10 // select p).FirstOrDefault(); //searchPlayer.FullName = "Jefferson Farfan"; //context.SaveChanges(); var searchListPlayer = (from p in context.Player where p.Dorsal == 7 select p).ToList(); foreach (var item in searchListPlayer) { Console.WriteLine("Jugador Encontrado: " + item.FullName + " Dorsal: " + item.Dorsal); } //Query Lambda Expressions var searchListPlayerLambda = context.Player.Where(x => x.Dorsal == 7).ToList(); Console.WriteLine("Hello World!"); }
static void Main(string[] args) { // Contiene todo el trabajo using var context = new MundialDBContext(); // ------------------INSERTAR --------------------- // ------------------------------------------------ // METODO PARA AGREGAR INDIVUAL -------------------------------- //var player1 = new Player(); //player1.FullName = "Cristiano Ronaldo"; //player1.Dorsal = 7; //// Context, Nombre de clase - tabla. Add(objeto) //context.Player.Add(player1); //context.SaveChanges(); // METODO PARA AGREGAR EN GRUPO ------------------------------- //var player2 = new Player(); //player2.FullName = "Leonel Messi"; //player2.Dorsal = 10; //var player3 = new Player(); //player3.FullName = "Paolo Guerrero"; //player3.Dorsal = 9; //var players = new List<Player>(); //players.Add(player2); //players.Add(player3); //context.Player.AddRange(players); //context.SaveChanges(); // --------------------------------------- LINQ EXPRESSION ---------------------------------- // ------------------------------------------------------------------------------------------- // ----------------- CONSULTAR -------------------- // ------------------------------------------------ //var searchPlayer = (from p in context.Player // where p.Dorsal == 9 // select p).FirstOrDefault(); //Console.WriteLine("Jugador Encontrado: " // + searchPlayer.FullName // + " Dorsal: " + searchPlayer.Dorsal); // ----------------- REMOVER ---------------------- // ------------------------------------------------ //context.Player.Remove(searchPlayer); //context.SaveChanges(); //Console.WriteLine("Jugador Eliminado: " + searchPlayer.FullName); // ----------------- UPDATE ----------------------- // ------------------------------------------------ //var searchPlayer = (from p in context.Player // where p.Dorsal == 10 // select p).FirstOrDefault(); //searchPlayer.FullName = "Jefferson Farfan"; //context.SaveChanges(); // ----------------- BUSQUEDA MASIVA ----------------------- // --------------------------------------------------------- var searchPlayer = (from p in context.Player where p.Dorsal == 10 select p).ToList(); foreach (var item in searchPlayer) { Console.WriteLine("Jugador Encontrado: " + item.FullName + " Dorsal: " + item.Dorsal); } // --------------------------------------- LAMBDA EXPRESSIONS-------------------------------- // ------------------------------------------------------------------------------------------- var searchListPlayerLambda = context.Player.Where(x => x.Dorsal == 7).ToList(); Console.WriteLine("Hello World!"); }