Ejemplo n.º 1
0
        public static void Main()
        {
            NorthwindEntities db = new NorthwindEntities();

            using (db)
            {
                db.Employees.Include("Territories");

                var employeesData = db.Employees
                    .Select(e =>
                    new
                    {
                        Employee = e,
                        Territories = e.Territories.Select(t => t.TerritoryDescription)
                    })
                    .ToList();

                foreach (var data in employeesData)
                {
                    Console.WriteLine(data.Employee.FirstName + " " + data.Employee.LastName);
                    Console.WriteLine("Territories:");
                    foreach (var teritory in data.Territories)
                    {
                        Console.WriteLine(teritory);
                    }
                    Console.WriteLine(new string('-', 50));
                }
            }
        }
        public static void UpdateCustomer(
           string id,
           string commpanyName,
           string contactName,
           string contactTitle,
           string address,
           string city,
           string region,
           string postalCode,
           string country,
           string phone,
           string fax)
        {
            var db = new NorthwindEntities();

            using (db)
            {
                Customer customer = db.Customers.Where(c => c.CustomerID == id).FirstOrDefault();

                customer.CustomerID = id;
                customer.CompanyName = commpanyName;
                customer.ContactName = contactName;
                customer.ContactTitle = contactTitle;
                customer.Address = address;
                customer.City = city;
                customer.Region = region;
                customer.PostalCode = postalCode;
                customer.Country = country;
                customer.Phone = phone;
                customer.Fax = fax;

                db.SaveChanges();
            }
        }
        public static void DeleteCustomerById(string id)
        {
            var db = new NorthwindEntities();

            using (db)
            {
                Customer customer = db.Customers.Where(c => c.CustomerID == id).FirstOrDefault();
                db.Customers.Remove(customer);

                db.SaveChanges();
            }
        }
Ejemplo n.º 4
0
        public static void Main()
        {
            var db = new NorthwindEntities();

            using (db)
            {
                var customers = db.Orders
                    .Where(o => o.OrderDate.Value.Year == 1997 && o.ShipCountry == "Canada")
                    .Select(o => o.Customer)
                    .ToList();

                foreach (var customer in customers)
                {
                    Console.WriteLine(customer.ContactName);
                }
            }
        }
Ejemplo n.º 5
0
        public static void SelectCustomers()
        {
            NorthwindEntities db = new NorthwindEntities();
            string nativeSqlQuery = @"SELECT c.[CustomerID], c.[CompanyName], c.[ContactName], c.[ContactTitle],
                                        c.[Address], c.[City], c.[Region], c.[PostalCode], c.[Country], c.[Phone], c.[Fax]
                                      FROM Northwind.dbo.Orders o
                                            INNER JOIN Northwind.dbo.Customers c
                                            ON (o.CustomerID = c.CustomerID)
                                            WHERE YEAR(o.OrderDate) = 1997 AND o.ShipCountry = 'Canada'";

            using (db)
            {
                var queryResult = db.Database.SqlQuery<CustomerFromDatabase>(nativeSqlQuery);
                var customers = queryResult.ToList();

                foreach (var customer in customers)
                {
                    Console.WriteLine(customer.ContactName);
                }
            }
        }
Ejemplo n.º 6
0
        public static void Main()
        {
            NorthwindEntities db = new NorthwindEntities();

            string regionName = "RJ";
            DateTime startDate = new DateTime(1996, 7, 16);
            DateTime endDate = new DateTime(1997, 5, 6);

            using (db)
            {

                var sales = db.Orders
                    .Where(o =>  startDate <= o.ShippedDate && endDate >= o.ShippedDate && o.ShipRegion == regionName)
                    .ToList();

                foreach (var sale in sales)
                {
                    Console.WriteLine(string.Format("{0} -> {1}", sale.ShipRegion, sale.ShippedDate));
                }
            }
        }
Ejemplo n.º 7
0
        public static void Main()
        {
            NorthwindEntities db = new NorthwindEntities();

            string differentConnectionString = ConfigurationManager.ConnectionStrings["NorthwindEntities"].ConnectionString;
            Console.WriteLine(differentConnectionString);

            using (db)
            {
                bool created = db.Database.CreateIfNotExists();

                if (created)
                {
                    Console.WriteLine("Database NorthwindTwin created!");
                }
                else
                {
                    Console.WriteLine("Database NorthwindTwin already exist!");
                }
            }
        }
Ejemplo n.º 8
0
        public static void Main()
        {
            NorthwindEntities dbOne = new NorthwindEntities();
            NorthwindEntities dbTwo = new NorthwindEntities();

            dbOne.Database.Connection.Open();

            Employee employee = new Employee()
            {
                LastName = "Minkov",
                FirstName = "Doncho",
                Title = "Dev Manager",
                TitleOfCourtesy = "Mr",
                BirthDate = new DateTime(1990, 08, 08),
                HireDate = new DateTime(2009, 05, 05),
                Address = "str.Alexander Malinov 31",
                City = "Sofia",
                PostalCode = "1001",
                Country = "Bulgaria"
            };

            dbOne.Employees.Add(employee);
            dbOne.SaveChanges();

            dbTwo.Database.Connection.Open();

            Employee employeeToUpdate = dbTwo.Employees
                .Where(e => e.City.Equals("Sofia"))
                .FirstOrDefault();

            employeeToUpdate.City = "London";
            employeeToUpdate.Address = "Downing Street 10";
            dbTwo.SaveChanges();

            dbOne.Database.Connection.Close();
            dbTwo.Database.Connection.Close();
        }
        public static void InsertCustomer(
            string id,
            string commpanyName,
            string contactName,
            string contactTitle,
            string address,
            string city,
            string region,
            string postalCode,
            string country,
            string phone,
            string fax)
        {
            var db = new NorthwindEntities();

            using (db)
            {
                Customer customer = new Customer()
                {
                    CustomerID = id,
                    CompanyName = commpanyName,
                    ContactName = contactName,
                    ContactTitle = contactTitle,
                    Address = address,
                    City = city,
                    Region = region,
                    PostalCode = postalCode,
                    Country = country,
                    Phone = phone,
                    Fax = fax
                };

                db.Customers.Add(customer);
                db.SaveChanges();
            }
        }