static void Main(string[] args) { //write into SQL database using entity framework //Console.WriteLine("Enter employee first name "); //string fname = Console.ReadLine(); //Console.WriteLine("Enter employee last name "); //string lname = Console.ReadLine(); //Console.WriteLine("Enter employee gender "); //string gender = Console.ReadLine(); //Console.WriteLine("Enter employee salary "); //int salary = Int32.Parse(Console.ReadLine()); //Console.WriteLine("Enter department ID "); //int deptId = Int32.Parse(Console.ReadLine()); //using (var context = new CS155Entities()) //{ // var employee = new Employee() // { // FirstName = fname, // LastName = lname, // Gender = gender, // Salary = salary, // DepartmentId = deptId // }; // context.Employees.Add(employee); // context.SaveChanges(); //} //Reading from SQL database using entity framework using (var context = new CS155Entities()) { foreach (var emp in context.Employees) { Console.Write(" " + emp.FirstName + " " + emp.LastName + " " + emp.Gender + " " + emp.Salary + " " + emp.Department.Name); Console.WriteLine(); } ; Console.ReadKey(); } }
static void Main(string[] args) { //writing into sql database //Console.WriteLine("Enter employee first name"); //string fname = Console.ReadLine(); //Console.WriteLine("Enter employee last name"); //string lname = Console.ReadLine(); //Console.WriteLine("Enter employee gender"); //string gender = Console.ReadLine(); //Console.WriteLine("Enter employee Salary"); //int salary = Int32.Parse(Console.ReadLine()); //Console.WriteLine("Enter employee ID name"); //int departmentId = Int32.Parse(Console.ReadLine()); //using (var context = new CS155Entities()) //{ // var employee = new Employee() // { // FirstName = "Red", // LastName = "Foreman", // Gender = "Male", // Salary = 5000, // DepartmentId = 2 // }; // context.Employees.Add(employee); // context.SaveChanges(); //} // reading a sql database using (var context = new CS155Entities()) { foreach (var emp in context.Employees) { Console.WriteLine($"{emp.FirstName} {emp.LastName} {emp.Gender} {emp.Salary} {emp.DepartmentId}"); } } }