Menu
▾
▴
[Nhibernate-commit] SF.net SVN: nhibernate:[4986] trunk/nhibernate/src/NHibernate.Test
|
From: <fab...@us...> - 2010-06-18 04:33:12
|
Revision: 4986
http://nhibernate.svn.sourceforge.net/nhibernate/?rev=4986&view=rev
Author: fabiomaulo
Date: 2010-06-18 04:33:05 +0000 (Fri, 18 Jun 2010)
Log Message:
-----------
Refactoring of Linq readonly tests (overboost)
Modified Paths:
--------------
trunk/nhibernate/src/NHibernate.Test/App.config
trunk/nhibernate/src/NHibernate.Test/Linq/LinqTestCase.cs
trunk/nhibernate/src/NHibernate.Test/Linq/ParameterisedQueries.cs
trunk/nhibernate/src/NHibernate.Test/Linq/ProjectionsTests.cs
trunk/nhibernate/src/NHibernate.Test/Linq/ReadonlyTestCase.cs
trunk/nhibernate/src/NHibernate.Test/Linq/SelectionTests.cs
trunk/nhibernate/src/NHibernate.Test/Linq/WhereTests.cs
trunk/nhibernate/src/NHibernate.Test/NHibernate.Test.build
trunk/nhibernate/src/NHibernate.Test/NHibernate.Test.csproj
Added Paths:
-----------
trunk/nhibernate/src/NHibernate.Test/DbScripts/
trunk/nhibernate/src/NHibernate.Test/DbScripts/MsSql2008DialectLinqReadonlyCreateScript.sql
trunk/nhibernate/src/NHibernate.Test/DbScripts/MsSql2008DialectLinqReadonlyDropScript.sql
trunk/nhibernate/src/NHibernate.Test/Linq/LinqReadonlyTestsContext.cs
trunk/nhibernate/src/NHibernate.Test/Linq/NorthwindDbCreator.cs
Modified: trunk/nhibernate/src/NHibernate.Test/App.config
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/App.config 2010-05-29 19:25:32 UTC (rev 4985)
+++ trunk/nhibernate/src/NHibernate.Test/App.config 2010-06-18 04:33:05 UTC (rev 4986)
@@ -61,7 +61,7 @@
<!-- This is the System.Data.dll provider for MSSQL Server -->
<property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
- <property name="dialect">NHibernate.Dialect.MsSql2005Dialect</property>
+ <property name="dialect">NHibernate.Dialect.MsSql2008Dialect</property>
<property name="connection.connection_string">Server=localhost\sqlexpress;initial catalog=nhibernate;Integrated Security=SSPI</property>
<property name="show_sql">false</property>
Added: trunk/nhibernate/src/NHibernate.Test/DbScripts/MsSql2008DialectLinqReadonlyCreateScript.sql
===================================================================
(Binary files differ)
Property changes on: trunk/nhibernate/src/NHibernate.Test/DbScripts/MsSql2008DialectLinqReadonlyCreateScript.sql
___________________________________________________________________
Added: svn:mime-type
+ application/octet-stream
Added: trunk/nhibernate/src/NHibernate.Test/DbScripts/MsSql2008DialectLinqReadonlyDropScript.sql
===================================================================
(Binary files differ)
Property changes on: trunk/nhibernate/src/NHibernate.Test/DbScripts/MsSql2008DialectLinqReadonlyDropScript.sql
___________________________________________________________________
Added: svn:mime-type
+ application/octet-stream
Added: trunk/nhibernate/src/NHibernate.Test/Linq/LinqReadonlyTestsContext.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/Linq/LinqReadonlyTestsContext.cs (rev 0)
+++ trunk/nhibernate/src/NHibernate.Test/Linq/LinqReadonlyTestsContext.cs 2010-06-18 04:33:05 UTC (rev 4986)
@@ -0,0 +1,139 @@
+using System.Collections.Generic;
+using System.Data;
+using System.Data.SqlClient;
+using System.IO;
+using System.Linq;
+using System.Reflection;
+using NHibernate.Cfg;
+using NHibernate.Connection;
+using NHibernate.Tool.hbm2ddl;
+using NUnit.Framework;
+
+namespace NHibernate.Test.Linq
+{
+ [SetUpFixture]
+ public class LinqReadonlyTestsContext
+ {
+ private IEnumerable<string> Mappings
+ {
+ get
+ {
+ return new[]
+ {
+ "Linq.Mappings.Customer.hbm.xml",
+ "Linq.Mappings.Employee.hbm.xml",
+ "Linq.Mappings.Order.hbm.xml",
+ "Linq.Mappings.OrderLine.hbm.xml",
+ "Linq.Mappings.Product.hbm.xml",
+ "Linq.Mappings.ProductCategory.hbm.xml",
+ "Linq.Mappings.Region.hbm.xml",
+ "Linq.Mappings.Shipper.hbm.xml",
+ "Linq.Mappings.Supplier.hbm.xml",
+ "Linq.Mappings.Territory.hbm.xml",
+ "Linq.Mappings.AnotherEntity.hbm.xml",
+ "Linq.Mappings.Role.hbm.xml",
+ "Linq.Mappings.User.hbm.xml",
+ "Linq.Mappings.TimeSheet.hbm.xml",
+ "Linq.Mappings.Animal.hbm.xml",
+ "Linq.Mappings.Patient.hbm.xml"
+ };
+ }
+ }
+
+ [SetUp]
+ public void CreateNorthwindDb()
+ {
+ Configuration configuration = Configure();
+ string scripFileName = GetScripFileName(configuration, "LinqReadonlyCreateScript");
+ if (File.Exists(scripFileName))
+ {
+ ExecuteScriptFile(configuration, scripFileName);
+ }
+ else
+ {
+ // may crash with NUnit2.5+ test runner
+ new SchemaExport(configuration).Create(false, true);
+ ISessionFactory sessionFactory = configuration.BuildSessionFactory();
+ CreateTestData(sessionFactory);
+ }
+ }
+
+ private void ExecuteScriptFile(Configuration configuration, string scripFileName)
+ {
+ var file = new FileInfo(scripFileName);
+ string script = file.OpenText().ReadToEnd().Replace("GO", "");
+ var connectionProvider = ConnectionProviderFactory.NewConnectionProvider(configuration.Properties);
+ using (var conn = connectionProvider.GetConnection())
+ {
+ if (conn.State == ConnectionState.Closed)
+ {
+ conn.Open();
+ }
+ using (var command = conn.CreateCommand())
+ {
+ command.CommandText = script;
+ command.ExecuteNonQuery();
+ }
+ }
+ }
+
+ [TearDown]
+ public void DestroyNorthwindDb()
+ {
+ Configuration configuration = Configure();
+ string scripFileName = GetScripFileName(configuration, "LinqReadonlyDropScript");
+ if (File.Exists(scripFileName))
+ {
+ ExecuteScriptFile(configuration, scripFileName);
+ }
+ else
+ {
+ new SchemaExport(configuration).Drop(false, true);
+ }
+ }
+
+ private string GetScripFileName(Configuration configuration,string postFix)
+ {
+ var dialect = Dialect.Dialect.GetDialect(configuration.Properties);
+ return Path.Combine("DbScripts", dialect.GetType().Name + postFix + ".sql");
+ }
+
+ private Configuration Configure()
+ {
+ var configuration = new Configuration();
+ if (TestConfigurationHelper.hibernateConfigFile != null)
+ configuration.Configure(TestConfigurationHelper.hibernateConfigFile);
+
+ configuration.SetProperty(Environment.ConnectionProvider, typeof (DriverConnectionProvider).AssemblyQualifiedName);
+
+ string assemblyName = "NHibernate.Test";
+ Assembly assembly = Assembly.Load(assemblyName);
+
+ foreach (string file in Mappings.Select(mf => assemblyName + "." + mf))
+ {
+ configuration.AddResource(file, assembly);
+ }
+
+ return configuration;
+ }
+
+ private void CreateTestData(ISessionFactory sessionFactory)
+ {
+ using (IStatelessSession session = sessionFactory.OpenStatelessSession())
+ using (ITransaction tx = session.BeginTransaction())
+ {
+ NorthwindDbCreator.CreateNorthwindData(session);
+
+ tx.Commit();
+ }
+
+ using (ISession session = sessionFactory.OpenSession())
+ using (ITransaction tx = session.BeginTransaction())
+ {
+ NorthwindDbCreator.CreateMiscTestData(session);
+ NorthwindDbCreator.CreatePatientData(session);
+ tx.Commit();
+ }
+ }
+ }
+}
\ No newline at end of file
Modified: trunk/nhibernate/src/NHibernate.Test/Linq/LinqTestCase.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/Linq/LinqTestCase.cs 2010-05-29 19:25:32 UTC (rev 4985)
+++ trunk/nhibernate/src/NHibernate.Test/Linq/LinqTestCase.cs 2010-06-18 04:33:05 UTC (rev 4986)
@@ -1,3572 +1,73 @@
using System;
using System.Collections;
using System.Collections.Generic;
-using System.Linq;
using NHibernate.Test.Linq.Entities;
using NUnit.Framework;
namespace NHibernate.Test.Linq
{
- public class LinqTestCase : ReadonlyTestCase
- {
- private Northwind _northwind;
- private ISession _session;
+ public class LinqTestCase : ReadonlyTestCase
+ {
+ private Northwind _northwind;
+ private ISession _session;
- protected override bool PerformDbDataSetup
- {
- get { return true; }
- }
+ protected override string MappingsAssembly
+ {
+ get { return "NHibernate.Test"; }
+ }
- protected override bool PerformDbDataTeardown
- {
- get { return true; }
- }
+ protected override IList Mappings
+ {
+ get
+ {
+ return new[]
+ {
+ "Linq.Mappings.Customer.hbm.xml",
+ "Linq.Mappings.Employee.hbm.xml",
+ "Linq.Mappings.Order.hbm.xml",
+ "Linq.Mappings.OrderLine.hbm.xml",
+ "Linq.Mappings.Product.hbm.xml",
+ "Linq.Mappings.ProductCategory.hbm.xml",
+ "Linq.Mappings.Region.hbm.xml",
+ "Linq.Mappings.Shipper.hbm.xml",
+ "Linq.Mappings.Supplier.hbm.xml",
+ "Linq.Mappings.Territory.hbm.xml",
+ "Linq.Mappings.AnotherEntity.hbm.xml",
+ "Linq.Mappings.Role.hbm.xml",
+ "Linq.Mappings.User.hbm.xml",
+ "Linq.Mappings.TimeSheet.hbm.xml",
+ "Linq.Mappings.Animal.hbm.xml",
+ "Linq.Mappings.Patient.hbm.xml"
+ };
+ }
+ }
- protected override string MappingsAssembly
- {
- get { return "NHibernate.Test"; }
- }
+ protected Northwind db
+ {
+ get { return _northwind; }
+ }
- protected override IList Mappings
- {
- get
- {
- return new[]
- {
- "Linq.Mappings.Customer.hbm.xml",
- "Linq.Mappings.Employee.hbm.xml",
- "Linq.Mappings.Order.hbm.xml",
- "Linq.Mappings.OrderLine.hbm.xml",
- "Linq.Mappings.Product.hbm.xml",
- "Linq.Mappings.ProductCategory.hbm.xml",
- "Linq.Mappings.Region.hbm.xml",
- "Linq.Mappings.Shipper.hbm.xml",
- "Linq.Mappings.Supplier.hbm.xml",
- "Linq.Mappings.Territory.hbm.xml",
- "Linq.Mappings.AnotherEntity.hbm.xml",
- "Linq.Mappings.Role.hbm.xml",
- "Linq.Mappings.User.hbm.xml",
- "Linq.Mappings.TimeSheet.hbm.xml",
- "Linq.Mappings.Animal.hbm.xml",
- "Linq.Mappings.Patient.hbm.xml"
+ protected ISession session
+ {
+ get { return _session; }
+ }
- };
- }
- }
+ protected override void OnSetUp()
+ {
+ base.OnSetUp();
- private void CreateTestData()
- {
- using (IStatelessSession session = _sessions.OpenStatelessSession())
- using (ITransaction tx = session.BeginTransaction())
- {
- CreateNorthwindData(session);
+ _session = OpenSession();
+ _northwind = new Northwind(_session);
+ }
- tx.Commit();
- }
-
- using (ISession session = _sessions.OpenSession())
- using (ITransaction tx = session.BeginTransaction())
- {
- CreateMiscTestData(session);
- CreatePatientData(session);
- tx.Commit();
- }
- }
-
- private void CreateMiscTestData(ISession session)
- {
- var roles = new[]
- {
- new Role()
- {
- Name = "Admin",
- IsActive = true,
- Entity = new AnotherEntity()
- {
- Output = "this is output..."
- }
- },
- new Role()
- {
- Name = "User",
- IsActive = false
- }
- };
-
- var users = new[]
- {
- new User("ayende", DateTime.Today)
- {
- Role = roles[0],
- InvalidLoginAttempts = 4,
- Enum1 = EnumStoredAsString.Medium,
- Enum2 = EnumStoredAsInt32.High,
- Component = new UserComponent()
- {
- Property1 = "test1",
- Property2 = "test2",
- OtherComponent = new UserComponent2()
- {
- OtherProperty1 = "othertest1"
- }
- }
- },
- new User("rahien", new DateTime(1998, 12, 31))
- {
- Role = roles[1],
- InvalidLoginAttempts = 5,
- Enum1 = EnumStoredAsString.Small,
- Component = new UserComponent()
- {
- Property2 = "test2"
- }
- },
- new User("nhibernate", new DateTime(2000, 1, 1))
- {
- InvalidLoginAttempts = 6,
- LastLoginDate = DateTime.Now.AddDays(-1),
- Enum1 = EnumStoredAsString.Medium
- }
- };
-
- var timesheets = new[]
- {
- new Timesheet
- {
- SubmittedDate = DateTime.Today,
- Submitted = true
- },
- new Timesheet
- {
- SubmittedDate = DateTime.Today.AddDays(-1),
- Submitted = false,
- Entries = new List<TimesheetEntry>
- {
- new TimesheetEntry
- {
- EntryDate = DateTime.Today,
- NumberOfHours = 6,
- Comments = "testing 123"
- },
- new TimesheetEntry
- {
- EntryDate = DateTime.Today.AddDays(1),
- NumberOfHours = 14
- }
- }
- },
- new Timesheet
- {
- SubmittedDate = DateTime.Now.AddDays(1),
- Submitted = true,
- Entries = new List<TimesheetEntry>
- {
- new TimesheetEntry
- {
- EntryDate = DateTime.Now.AddMinutes(20),
- NumberOfHours = 4
- },
- new TimesheetEntry
- {
- EntryDate = DateTime.Now.AddMinutes(10),
- NumberOfHours = 8,
- Comments = "testing 456"
- },
- new TimesheetEntry
- {
- EntryDate = DateTime.Now.AddMinutes(13),
- NumberOfHours = 7
- },
- new TimesheetEntry
- {
- EntryDate = DateTime.Now.AddMinutes(45),
- NumberOfHours = 38
- }
- }
- }
- };
-
- ((IList<User>)timesheets[0].Users).Add(users[0]);
- ((IList<User>)timesheets[1].Users).Add(users[0]);
- ((IList<User>)timesheets[0].Users).Add(users[1]);
-
- var animals = new Animal[]
+ protected override void OnTearDown()
+ {
+ if (_session.IsOpen)
{
- new Animal() { SerialNumber = "123", BodyWeight = 100 },
- new Lizard() { SerialNumber = "789", BodyWeight = 40, BodyTemperature = 14 },
- new Lizard() { SerialNumber = "1234", BodyWeight = 30, BodyTemperature = 18 },
- new Dog() { SerialNumber = "5678", BodyWeight = 156, BirthDate = new DateTime(1980, 07, 11) },
- new Dog() { SerialNumber = "9101", BodyWeight = 205, BirthDate = new DateTime(1980, 12, 13) },
- new Cat() { SerialNumber = "1121", BodyWeight = 115, Pregnant = true }
- };
+ _session.Close();
+ }
+ }
- animals[0].Children = new[] { animals[3], animals[4] }.ToList();
- animals[5].Father = animals[3];
- animals[5].Mother = animals[4];
-
- animals[1].Children = new[] { animals[5] }.ToList();
-
- foreach (Role role in roles)
- session.Save(role);
-
- foreach (User user in users)
- session.Save(user);
-
- foreach (Timesheet timesheet in timesheets)
- session.Save(timesheet);
-
- foreach (Animal animal in animals)
- session.Save(animal);
- }
-
- private void CreatePatientData(ISession session)
- {
- State newYork = new State
- {
- Abbreviation = "NY",
- FullName = "New York"
- };
- State florida = new State
- {
- Abbreviation = "FL",
- FullName = "Florida"
- };
-
- Physician drDobbs = new Physician
- {
- Name = "Dr Dobbs"
- };
- Physician drWatson = new Physician
- {
- Name = "Dr Watson"
- };
-
- PatientRecord bobBarkerRecord = new PatientRecord
- {
- Name = new PatientName
- {
- FirstName = "Bob",
- LastName = "Barker"
- },
- Address = new PatientAddress
- {
- AddressLine1 = "123 Main St",
- City = "New York",
- State = newYork,
- ZipCode = "10001"
- },
- BirthDate = new DateTime(1930, 1, 1),
- Gender = Gender.Male
- };
-
- PatientRecord johnDoeRecord1 = new PatientRecord
- {
- Name = new PatientName
- {
- FirstName = "John",
- LastName = "Doe"
- },
- Address = new PatientAddress
- {
- AddressLine1 = "123 Main St",
- City = "Tampa",
- State = florida,
- ZipCode = "33602"
- },
- BirthDate = new DateTime(1969, 1, 1),
- Gender = Gender.Male
- };
-
- PatientRecord johnDoeRecord2 = new PatientRecord
- {
- Name = new PatientName
- {
- FirstName = "John",
- LastName = "Doe"
- },
- Address = new PatientAddress
- {
- AddressLine1 = "123 Main St",
- AddressLine2 = "Apt 2",
- City = "Tampa",
- State = florida,
- ZipCode = "33602"
- },
- BirthDate = new DateTime(1969, 1, 1)
- };
-
- Patient bobBarker = new Patient(new[] { bobBarkerRecord }, false, drDobbs);
- Patient johnDoe = new Patient(new[] { johnDoeRecord1, johnDoeRecord2 }, true, drWatson);
-
- session.Save(newYork);
- session.Save(florida);
- session.Save(drDobbs);
- session.Save(drWatson);
- session.Save(bobBarker);
- session.Save(johnDoe);
- }
-
- private void CreateNorthwindData(IStatelessSession session)
- {
- var shippers = new List<Shipper>();
- var shipper = new Shipper { ShipperId = 1, CompanyName = "Speedy Express", PhoneNumber = "(503) 555-9831", Reference = new Guid("356E4A7E-B027-4321-BA40-E2677E6502CF") }; session.Insert(shipper); shippers.Add(shipper);
- shipper = new Shipper { ShipperId = 2, CompanyName = "United Package", PhoneNumber = "(503) 555-3199", Reference = new Guid("6DFCD0D7-4D2E-4525-A502-3EA9AA52E965") }; session.Insert(shipper); shippers.Add(shipper);
- shipper = new Shipper { ShipperId = 3, CompanyName = "Federal Shipping", PhoneNumber = "(503) 555-9931", Reference = new Guid("716F114B-E253-4166-8C76-46E6F340B58F") }; session.Insert(shipper); shippers.Add(shipper);
-
- var categories = new List<ProductCategory>();
- var category = new ProductCategory { CategoryId = 1, Name = "Beverages", Description = "Soft drinks, coffees, teas, beers, and ales" }; session.Insert(category); categories.Add(category);
- category = new ProductCategory { CategoryId = 2, Name = "Condiments", Description = "Sweet and savory sauces, relishes, spreads, and seasonings" }; session.Insert(category); categories.Add(category);
- category = new ProductCategory { CategoryId = 3, Name = "Confections", Description = "Desserts, candies, and sweet breads" }; session.Insert(category); categories.Add(category);
- category = new ProductCategory { CategoryId = 4, Name = "Dairy Products", Description = "Cheeses" }; session.Insert(category); categories.Add(category);
- category = new ProductCategory { CategoryId = 5, Name = "Grains/Cereals", Description = "Breads, crackers, pasta, and cereal" }; session.Insert(category); categories.Add(category);
- category = new ProductCategory { CategoryId = 6, Name = "Meat/Poultry", Description = "Prepared meats" }; session.Insert(category); categories.Add(category);
- category = new ProductCategory { CategoryId = 7, Name = "Produce", Description = "Dried fruit and bean curd" }; session.Insert(category); categories.Add(category);
- category = new ProductCategory { CategoryId = 8, Name = "Seafood", Description = "Seaweed and fish" }; session.Insert(category); categories.Add(category);
-
- var suppliers = new List<Supplier>();
- var supplier = new Supplier { SupplierId = 1, CompanyName = "Exotic Liquids", ContactName = "Charlotte Cooper", ContactTitle = "Purchasing Manager", HomePage = "", Address = new Address("49 Gilbert St.", "London", "", "EC1 4SD", "UK", "(171) 555-2222", "") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 2, CompanyName = "New Orleans Cajun Delights", ContactName = "Shelley Burke", ContactTitle = "Order Administrator", HomePage = "#CAJUN.HTM#", Address = new Address("P.O. Box 78934", "New Orleans", "LA", "70117", "USA", "(100) 555-4822", "") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 3, CompanyName = "Grandma Kelly's Homestead", ContactName = "Regina Murphy", ContactTitle = "Sales Representative", HomePage = "", Address = new Address("707 Oxford Rd.", "Ann Arbor", "MI", "48104", "USA", "(313) 555-5735", "(313) 555-3349") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 4, CompanyName = "Tokyo Traders", ContactName = "Yoshi Nagase", ContactTitle = "Marketing Manager", HomePage = "", Address = new Address("9-8 Sekimai Musashino-shi", "Tokyo", "", "100", "Japan", "(03) 3555-5011", "") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 5, CompanyName = "Cooperativa de Quesos 'Las Cabras'", ContactName = "Antonio del Valle Saavedra", ContactTitle = "Export Administrator", HomePage = "", Address = new Address("Calle del Rosal 4", "Oviedo", "Asturias", "33007", "Spain", "(98) 598 76 54", "") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 6, CompanyName = "Mayumi's", ContactName = "Mayumi Ohno", ContactTitle = "Marketing Representative", HomePage = "Mayumi's (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps/mayumi.htm#", Address = new Address("92 Setsuko Chuo-ku", "Osaka", "", "545", "Japan", "(06) 431-7877", "") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 7, CompanyName = "Pavlova, Ltd.", ContactName = "Ian Devling", ContactTitle = "Marketing Manager", HomePage = "", Address = new Address("74 Rose St. Moonie Ponds", "Melbourne", "Victoria", "3058", "Australia", "(03) 444-2343", "(03) 444-6588") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 8, CompanyName = "Specialty Biscuits, Ltd.", ContactName = "Peter Wilson", ContactTitle = "Sales Representative", HomePage = "", Address = new Address("29 King's Way", "Manchester", "", "M14 GSD", "UK", "(161) 555-4448", "") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 9, CompanyName = "PB Knäckebröd AB", ContactName = "Lars Peterson", ContactTitle = "Sales Agent", HomePage = "", Address = new Address("Kaloadagatan 13", "Göteborg", "", "S-345 67", "Sweden", "031-987 65 43", "031-987 65 91") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 10, CompanyName = "Refrescos Americanas LTDA", ContactName = "Carlos Diaz", ContactTitle = "Marketing Manager", HomePage = "", Address = new Address("Av. das Americanas 12.890", "Sao Paulo", "", "5442", "Brazil", "(11) 555 4640", "") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 11, CompanyName = "Heli Süßwaren GmbH & Co. KG", ContactName = "Petra Winkler", ContactTitle = "Sales Manager", HomePage = "", Address = new Address("Tiergartenstraße 5", "Berlin", "", "10785", "Germany", "(010) 9984510", "") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 12, CompanyName = "Plutzer Lebensmittelgroßmärkte AG", ContactName = "Martin Bein", ContactTitle = "International Marketing Mgr.", HomePage = "Plutzer (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps/plutzer.htm#", Address = new Address("Bogenallee 51", "Frankfurt", "", "60439", "Germany", "(069) 992755", "") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 13, CompanyName = "Nord-Ost-Fisch Handelsgesellschaft mbH", ContactName = "Sven Petersen", ContactTitle = "Coordinator Foreign Markets", HomePage = "", Address = new Address("Frahmredder 112a", "Cuxhaven", "", "27478", "Germany", "(04721) 8713", "(04721) 8714") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 14, CompanyName = "Formaggi Fortini s.r.l.", ContactName = "Elio Rossi", ContactTitle = "Sales Representative", HomePage = "#FORMAGGI.HTM#", Address = new Address("Viale Dante, 75", "Ravenna", "", "48100", "Italy", "(0544) 60323", "(0544) 60603") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 15, CompanyName = "Norske Meierier", ContactName = "Beate Vileid", ContactTitle = "Marketing Manager", HomePage = "", Address = new Address("Hatlevegen 5", "Sandvika", "", "1320", "Norway", "(0)2-953010", "") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 16, CompanyName = "Bigfoot Breweries", ContactName = "Cheryl Saylor", ContactTitle = "Regional Account Rep.", HomePage = "", Address = new Address("3400 - 8th Avenue Suite 210", "Bend", "OR", "97101", "USA", "(503) 555-9931", "") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 17, CompanyName = "Svensk Sjöföda AB", ContactName = "Michael Björn", ContactTitle = "Sales Representative", HomePage = "", Address = new Address("Brovallavägen 231", "Stockholm", "", "S-123 45", "Sweden", "08-123 45 67", "") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 18, CompanyName = "Aux joyeux ecclésiastiques", ContactName = "Guylène Nodier", ContactTitle = "Sales Manager", HomePage = "", Address = new Address("203, Rue des Francs-Bourgeois", "Paris", "", "75004", "France", "(1) 03.83.00.68", "(1) 03.83.00.62") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 19, CompanyName = "New England Seafood Cannery", ContactName = "Robb Merchant", ContactTitle = "Wholesale Account Agent", HomePage = "", Address = new Address("Order Processing Dept. 2100 Paul Revere Blvd.", "Boston", "MA", "02134", "USA", "(617) 555-3267", "(617) 555-3389") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 20, CompanyName = "Leka Trading", ContactName = "Chandra Leka", ContactTitle = "Owner", HomePage = "", Address = new Address("471 Serangoon Loop, Suite #402", "Singapore", "", "0512", "Singapore", "555-8787", "") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 21, CompanyName = "Lyngbysild", ContactName = "Niels Petersen", ContactTitle = "Sales Manager", HomePage = "", Address = new Address("Lyngbysild Fiskebakken 10", "Lyngby", "", "2800", "Denmark", "43844108", "43844115") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 22, CompanyName = "Zaanse Snoepfabriek", ContactName = "Dirk Luchte", ContactTitle = "Accounting Manager", HomePage = "", Address = new Address("Verkoop Rijnweg 22", "Zaandam", "", "9999 ZZ", "Netherlands", "(12345) 1212", "(12345) 1210") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 23, CompanyName = "Karkki Oy", ContactName = "Anne Heikkonen", ContactTitle = "Product Manager", HomePage = "", Address = new Address("Valtakatu 12", "Lappeenranta", "", "53120", "Finland", "(953) 10956", "") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 24, CompanyName = "G'day, Mate", ContactName = "Wendy Mackenzie", ContactTitle = "Sales Representative", HomePage = "G'day Mate (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps/gdaymate.htm#", Address = new Address("170 Prince Edward Parade Hunter's Hill", "Sydney", "NSW", "2042", "Australia", "(02) 555-5914", "(02) 555-4873") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 25, CompanyName = "Ma Maison", ContactName = "Jean-Guy Lauzon", ContactTitle = "Marketing Manager", HomePage = "", Address = new Address("2960 Rue St. Laurent", "Montréal", "Québec", "H1J 1C3", "Canada", "(514) 555-9022", "") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 26, CompanyName = "Pasta Buttini s.r.l.", ContactName = "Giovanni Giudici", ContactTitle = "Order Administrator", HomePage = "", Address = new Address("Via dei Gelsomini, 153", "Salerno", "", "84100", "Italy", "(089) 6547665", "(089) 6547667") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 27, CompanyName = "Escargots Nouveaux", ContactName = "Marie Delamare", ContactTitle = "Sales Manager", HomePage = "", Address = new Address("22, rue H. Voiron", "Montceau", "", "71300", "France", "85.57.00.07", "") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 28, CompanyName = "Gai pâturage", ContactName = "Eliane Noz", ContactTitle = "Sales Representative", HomePage = "", Address = new Address("Bat. B 3, rue des Alpes", "Annecy", "", "74000", "France", "38.76.98.06", "38.76.98.58") }; session.Insert(supplier); suppliers.Add(supplier);
- supplier = new Supplier { SupplierId = 29, CompanyName = "Forêts d'érables", ContactName = "Chantal Goulet", ContactTitle = "Accounting Manager", HomePage = "", Address = new Address("148 rue Chasseur", "Ste-Hyacinthe", "Québec", "J2S 7S8", "Canada", "(514) 555-2955", "(514) 555-2921") }; session.Insert(supplier); suppliers.Add(supplier);
-
- var employees = new List<Employee>();
- var employee = new Employee { EmployeeId = 1, LastName = "Davolio", FirstName = "Nancy", Title = "Sales Representative", TitleOfCourtesy = "Ms.", BirthDate = DateTime.Parse("Dec 8 1948 12:00AM"), HireDate = DateTime.Parse("May 1 1992 12:00AM"), Address = new Address("507 - 20th Ave. E.Apt. 2A", "Seattle", "WA", "98122", "USA", "(206) 555-9857", null), Extension = "5467", Notes = "Education includes a BA in psychology from Colorado State University in 1970. She also completed 'The Art of the Cold Call.' Nancy is a member of Toastmasters International." }; session.Insert(employee); employees.Add(employee);
- employee = new Employee { EmployeeId = 2, LastName = "Fuller", FirstName = "Andrew", Title = "Vice President, Sales", TitleOfCourtesy = "Dr.", BirthDate = DateTime.Parse("Feb 19 1952 12:00AM"), HireDate = DateTime.Parse("Aug 14 1992 12:00AM"), Address = new Address("908 W. Capital Way", "Tacoma", "WA", "98401", "USA", "(206) 555-9482", null), Extension = "3457", Notes = "Andrew received his BTS commercial in 1974 and a Ph.D. in international marketing from the University of Dallas in 1981. He is fluent in French and Italian and reads German. He joined the company as a sales representative, was promoted to sales manager in January 1992 and to vice president of sales in March 1993. Andrew is a member of the Sales Management Roundtable, the Seattle Chamber of Commerce, and the Pacific Rim Importers Association." }; session.Insert(employee); employees.Add(employee);
- employee = new Employee { EmployeeId = 3, LastName = "Leverling", FirstName = "Janet", Title = "Sales Representative", TitleOfCourtesy = "Ms.", BirthDate = DateTime.Parse("Aug 30 1963 12:00AM"), HireDate = DateTime.Parse("Apr 1 1992 12:00AM"), Address = new Address("722 Moss Bay Blvd.", "Kirkland", "WA", "98033", "USA", "(206) 555-3412", null), Extension = "3355", Notes = "Janet has a BS degree in chemistry from Boston College (1984). She has also completed a certificate program in food retailing management. Janet was hired as a sales associate in 1991 and promoted to sales representative in February 1992." }; session.Insert(employee); employees.Add(employee);
- employee = new Employee { EmployeeId = 4, LastName = "Peacock", FirstName = "Margaret", Title = "Sales Representative", TitleOfCourtesy = "Mrs.", BirthDate = DateTime.Parse("Sep 19 1937 12:00AM"), HireDate = DateTime.Parse("May 3 1993 12:00AM"), Address = new Address("4110 Old Redmond Rd.", "Redmond", "WA", "98052", "USA", "(206) 555-8122", null), Extension = "5176", Notes = "Margaret holds a BA in English literature from Concordia College (1958) and an MA from the American Institute of Culinary Arts (1966). She was assigned to the London office temporarily from July through November 1992." }; session.Insert(employee); employees.Add(employee);
- employee = new Employee { EmployeeId = 5, LastName = "Buchanan", FirstName = "Steven", Title = "Sales Manager", TitleOfCourtesy = "Mr.", BirthDate = DateTime.Parse("Mar 4 1955 12:00AM"), HireDate = DateTime.Parse("Oct 17 1993 12:00AM"), Address = new Address("14 Garrett Hill", "London", "", "SW1 8JR", "UK", "(71) 555-4848", null), Extension = "3453", Notes = "Steven Buchanan graduated from St. Andrews University, Scotland, with a BSC degree in 1976. Upon joining the company as a sales representative in 1992, he spent 6 months in an orientation program at the Seattle office and then returned to his permanent post in London. He was promoted to sales manager in March 1993. Mr. Buchanan has completed the courses 'Successful Telemarketing' and 'International Sales Management.' He is fluent in French." }; session.Insert(employee); employees.Add(employee);
- employee = new Employee { EmployeeId = 6, LastName = "Suyama", FirstName = "Michael", Title = "Sales Representative", TitleOfCourtesy = "Mr.", BirthDate = DateTime.Parse("Jul 2 1963 12:00AM"), HireDate = DateTime.Parse("Oct 17 1993 12:00AM"), Address = new Address("Coventry HouseMiner Rd.", "London", "", "EC2 7JR", "UK", "(71) 555-7773", null), Extension = "428", Notes = "Michael is a graduate of Sussex University (MA, economics, 1983) and the University of California at Los Angeles (MBA, marketing, 1986). He has also taken the courses 'Multi-Cultural Selling' and 'Time Management for the Sales Professional.' He is fluent in Japanese and can read and write French, Portuguese, and Spanish." }; session.Insert(employee); employees.Add(employee);
- employee = new Employee { EmployeeId = 7, LastName = "King", FirstName = "Robert", Title = "Sales Representative", TitleOfCourtesy = "Mr.", BirthDate = DateTime.Parse("May 29 1960 12:00AM"), HireDate = DateTime.Parse("Jan 2 1994 12:00AM"), Address = new Address("Edgeham HollowWinchester Way", "London", "", "RG1 9SP", "UK", "(71) 555-5598", null), Extension = "465", Notes = "Robert King served in the Peace Corps and traveled extensively before completing his degree in English at the University of Michigan in 1992, the year he joined the company. After completing a course entitled 'Selling in Europe,' he was transferred to the London office in March 1993." }; session.Insert(employee); employees.Add(employee);
- employee = new Employee { EmployeeId = 8, LastName = "Callahan", FirstName = "Laura", Title = "Inside Sales Coordinator", TitleOfCourtesy = "Ms.", BirthDate = DateTime.Parse("Jan 9 1958 12:00AM"), HireDate = DateTime.Parse("Mar 5 1994 12:00AM"), Address = new Address("4726 - 11th Ave. N.E.", "Seattle", "WA", "98105", "USA", "(206) 555-1189", null), Extension = "2344", Notes = "Laura received a BA in psychology from the University of Washington. She has also completed a course in business French. She reads and writes French." }; session.Insert(employee); employees.Add(employee);
- employee = new Employee { EmployeeId = 9, LastName = "Dodsworth", FirstName = "Anne", Title = "Sales Representative", TitleOfCourtesy = "Ms.", BirthDate = DateTime.Parse("Jan 27 1966 12:00AM"), HireDate = DateTime.Parse("Nov 15 1994 12:00AM"), Address = new Address("7 Houndstooth Rd.", "London", "", "WG2 7LT", "UK", "(71) 555-4444", null), Extension = "452", Notes = "Anne has a BA degree in English from St. Lawrence College. She is fluent in French and German." }; session.Insert(employee); employees.Add(employee);
-
- employees.Where(e => e.LastName == "Davolio").First().Superior = employees.Where(e => e.LastName == "Fuller").First();
- employees.Where(e => e.LastName == "Leverling").First().Superior = employees.Where(e => e.LastName == "Fuller").First();
- employees.Where(e => e.LastName == "Peacock").First().Superior = employees.Where(e => e.LastName == "Fuller").First();
- employees.Where(e => e.LastName == "Buchanan").First().Superior = employees.Where(e => e.LastName == "Fuller").First();
- employees.Where(e => e.LastName == "Suyama").First().Superior = employees.Where(e => e.LastName == "Buchanan").First();
- employees.Where(e => e.LastName == "King").First().Superior = employees.Where(e => e.LastName == "Buchanan").First();
- employees.Where(e => e.LastName == "Callahan").First().Superior = employees.Where(e => e.LastName == "Fuller").First();
- employees.Where(e => e.LastName == "Dodsworth").First().Superior = employees.Where(e => e.LastName == "Buchanan").First();
-
- var customers = new List<Customer>();
- var customer = new Customer { CustomerId = "ALFKI", CompanyName = "Alfreds Futterkiste", ContactName = "Maria Anders", ContactTitle = "Sales Representative", Address = new Address("Obere Str. 57", "Berlin", "", "12209", "Germany", "030-0074321", "030-0076545") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "ANATR", CompanyName = "Ana Trujillo Emparedados y helados", ContactName = "Ana Trujillo", ContactTitle = "Owner", Address = new Address("Avda. de la Constitución 2222", "México D.F.", "", "05021", "Mexico", "(5) 555-4729", "(5) 555-3745") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "ANTON", CompanyName = "Antonio Moreno Taquería", ContactName = "Antonio Moreno", ContactTitle = "Owner", Address = new Address("Mataderos 2312", "México D.F.", "", "05023", "Mexico", "(5) 555-3932", "") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "AROUT", CompanyName = "Around the Horn", ContactName = "Thomas Hardy", ContactTitle = "Sales Representative", Address = new Address("120 Hanover Sq.", "London", "", "WA1 1DP", "UK", "(171) 555-7788", "(171) 555-6750") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "BERGS", CompanyName = "Berglunds snabbköp", ContactName = "Christina Berglund", ContactTitle = "Order Administrator", Address = new Address("Berguvsvägen 8", "Luleå", "", "S-958 22", "Sweden", "0921-12 34 65", "0921-12 34 67") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "BLAUS", CompanyName = "Blauer See Delikatessen", ContactName = "Hanna Moos", ContactTitle = "Sales Representative", Address = new Address("Forsterstr. 57", "Mannheim", "", "68306", "Germany", "0621-08460", "0621-08924") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "BLONP", CompanyName = "Blondesddsl père et fils", ContactName = "Frédérique Citeaux", ContactTitle = "Marketing Manager", Address = new Address("24, place Kléber", "Strasbourg", "", "67000", "France", "88.60.15.31", "88.60.15.32") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "BOLID", CompanyName = "Bólido Comidas preparadas", ContactName = "Martín Sommer", ContactTitle = "Owner", Address = new Address("C/ Araquil, 67", "Madrid", "", "28023", "Spain", "(91) 555 22 82", "(91) 555 91 99") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "BONAP", CompanyName = "Bon app'", ContactName = "Laurence Lebihan", ContactTitle = "Owner", Address = new Address("12, rue des Bouchers", "Marseille", "", "13008", "France", "91.24.45.40", "91.24.45.41") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "BOTTM", CompanyName = "Bottom-Dollar Markets", ContactName = "Elizabeth Lincoln", ContactTitle = "Accounting Manager", Address = new Address("23 Tsawassen Blvd.", "Tsawassen", "BC", "T2F 8M4", "Canada", "(604) 555-4729", "(604) 555-3745") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "BSBEV", CompanyName = "B's Beverages", ContactName = "Victoria Ashworth", ContactTitle = "Sales Representative", Address = new Address("Fauntleroy Circus", "London", "", "EC2 5NT", "UK", "(171) 555-1212", "") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "CACTU", CompanyName = "Cactus Comidas para llevar", ContactName = "Patricio Simpson", ContactTitle = "Sales Agent", Address = new Address("Cerrito 333", "Buenos Aires", "", "1010", "Argentina", "(1) 135-5555", "(1) 135-4892") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "CENTC", CompanyName = "Centro comercial Moctezuma", ContactName = "Francisco Chang", ContactTitle = "Marketing Manager", Address = new Address("Sierras de Granada 9993", "México D.F.", "", "05022", "Mexico", "(5) 555-3392", "(5) 555-7293") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "CHOPS", CompanyName = "Chop-suey Chinese", ContactName = "Yang Wang", ContactTitle = "Owner", Address = new Address("Hauptstr. 29", "Bern", "", "3012", "Switzerland", "0452-076545", "") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "COMMI", CompanyName = "Comércio Mineiro", ContactName = "Pedro Afonso", ContactTitle = "Sales Associate", Address = new Address("Av. dos Lusíadas, 23", "Sao Paulo", "SP", "05432-043", "Brazil", "(11) 555-7647", "") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "CONSH", CompanyName = "Consolidated Holdings", ContactName = "Elizabeth Brown", ContactTitle = "Sales Representative", Address = new Address("Berkeley Gardens 12 Brewery", "London", "", "WX1 6LT", "UK", "(171) 555-2282", "(171) 555-9199") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "DRACD", CompanyName = "Drachenblut Delikatessen", ContactName = "Sven Ottlieb", ContactTitle = "Order Administrator", Address = new Address("Walserweg 21", "Aachen", "", "52066", "Germany", "0241-039123", "0241-059428") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "DUMON", CompanyName = "Du monde entier", ContactName = "Janine Labrune", ContactTitle = "Owner", Address = new Address("67, rue des Cinquante Otages", "Nantes", "", "44000", "France", "40.67.88.88", "40.67.89.89") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "EASTC", CompanyName = "Eastern Connection", ContactName = "Ann Devon", ContactTitle = "Sales Agent", Address = new Address("35 King George", "London", "", "WX3 6FW", "UK", "(171) 555-0297", "(171) 555-3373") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "ERNSH", CompanyName = "Ernst Handel", ContactName = "Roland Mendel", ContactTitle = "Sales Manager", Address = new Address("Kirchgasse 6", "Graz", "", "8010", "Austria", "7675-3425", "7675-3426") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "FAMIA", CompanyName = "Familia Arquibaldo", ContactName = "Aria Cruz", ContactTitle = "Marketing Assistant", Address = new Address("Rua Orós, 92", "Sao Paulo", "SP", "05442-030", "Brazil", "(11) 555-9857", "") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "FISSA", CompanyName = "FISSA Fabrica Inter. Salchichas S.A.", ContactName = "Diego Roel", ContactTitle = "Accounting Manager", Address = new Address("C/ Moralzarzal, 86", "Madrid", "", "28034", "Spain", "(91) 555 94 44", "(91) 555 55 93") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "FOLIG", CompanyName = "Folies gourmandes", ContactName = "Martine Rancé", ContactTitle = "Assistant Sales Agent", Address = new Address("184, chaussée de Tournai", "Lille", "", "59000", "France", "20.16.10.16", "20.16.10.17") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "FOLKO", CompanyName = "Folk och fä HB", ContactName = "Maria Larsson", ContactTitle = "Owner", Address = new Address("Åkergatan 24", "Bräcke", "", "S-844 67", "Sweden", "0695-34 67 21", "") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "FRANK", CompanyName = "Frankenversand", ContactName = "Peter Franken", ContactTitle = "Marketing Manager", Address = new Address("Berliner Platz 43", "München", "", "80805", "Germany", "089-0877310", "089-0877451") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "FRANR", CompanyName = "France restauration", ContactName = "Carine Schmitt", ContactTitle = "Marketing Manager", Address = new Address("54, rue Royale", "Nantes", "", "44000", "France", "40.32.21.21", "40.32.21.20") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "FRANS", CompanyName = "Franchi S.p.A.", ContactName = "Paolo Accorti", ContactTitle = "Sales Representative", Address = new Address("Via Monte Bianco 34", "Torino", "", "10100", "Italy", "011-4988260", "011-4988261") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "FURIB", CompanyName = "Furia Bacalhau e Frutos do Mar", ContactName = "Lino Rodriguez", ContactTitle = "Sales Manager", Address = new Address("Jardim das rosas n. 32", "Lisboa", "", "1675", "Portugal", "(1) 354-2534", "(1) 354-2535") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "GALED", CompanyName = "Galería del gastrónomo", ContactName = "Eduardo Saavedra", ContactTitle = "Marketing Manager", Address = new Address("Rambla de Cataluña, 23", "Barcelona", "", "08022", "Spain", "(93) 203 4560", "(93) 203 4561") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "GODOS", CompanyName = "Godos Cocina Típica", ContactName = "José Pedro Freyre", ContactTitle = "Sales Manager", Address = new Address("C/ Romero, 33", "Sevilla", "", "41101", "Spain", "(95) 555 82 82", "") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "GOURL", CompanyName = "Gourmet Lanchonetes", ContactName = "André Fonseca", ContactTitle = "Sales Associate", Address = new Address("Av. Brasil, 442", "Campinas", "SP", "04876-786", "Brazil", "(11) 555-9482", "") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "GREAL", CompanyName = "Great Lakes Food Market", ContactName = "Howard Snyder", ContactTitle = "Marketing Manager", Address = new Address("2732 Baker Blvd.", "Eugene", "OR", "97403", "USA", "(503) 555-7555", "") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "GROSR", CompanyName = "GROSELLA-Restaurante", ContactName = "Manuel Pereira", ContactTitle = "Owner", Address = new Address("5ª Ave. Los Palos Grandes", "Caracas", "DF", "1081", "Venezuela", "(2) 283-2951", "(2) 283-3397") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "HANAR", CompanyName = "Hanari Carnes", ContactName = "Mario Pontes", ContactTitle = "Accounting Manager", Address = new Address("Rua do Paço, 67", "Rio de Janeiro", "RJ", "05454-876", "Brazil", "(21) 555-0091", "(21) 555-8765") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "HILAA", CompanyName = "HILARION-Abastos", ContactName = "Carlos Hernández", ContactTitle = "Sales Representative", Address = new Address("Carrera 22 con Ave. Carlos Soublette #8-35", "San Cristóbal", "Táchira", "5022", "Venezuela", "(5) 555-1340", "(5) 555-1948") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "HUNGC", CompanyName = "Hungry Coyote Import Store", ContactName = "Yoshi Latimer", ContactTitle = "Sales Representative", Address = new Address("City Center Plaza 516 Main St.", "Elgin", "OR", "97827", "USA", "(503) 555-6874", "(503) 555-2376") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "HUNGO", CompanyName = "Hungry Owl All-Night Grocers", ContactName = "Patricia McKenna", ContactTitle = "Sales Associate", Address = new Address("8 Johnstown Road", "Cork", "Co. Cork", "", "Ireland", "2967 542", "2967 3333") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "ISLAT", CompanyName = "Island Trading", ContactName = "Helen Bennett", ContactTitle = "Marketing Manager", Address = new Address("Garden House Crowther Way", "Cowes", "Isle of Wight", "PO31 7PJ", "UK", "(198) 555-8888", "") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "KOENE", CompanyName = "Königlich Essen", ContactName = "Philip Cramer", ContactTitle = "Sales Associate", Address = new Address("Maubelstr. 90", "Brandenburg", "", "14776", "Germany", "0555-09876", "") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "LACOR", CompanyName = "La corne d'abondance", ContactName = "Daniel Tonini", ContactTitle = "Sales Representative", Address = new Address("67, avenue de l'Europe", "Versailles", "", "78000", "France", "30.59.84.10", "30.59.85.11") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "LAMAI", CompanyName = "La maison d'Asie", ContactName = "Annette Roulet", ContactTitle = "Sales Manager", Address = new Address("1 rue Alsace-Lorraine", "Toulouse", "", "31000", "France", "61.77.61.10", "61.77.61.11") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "LAUGB", CompanyName = "Laughing Bacchus Wine Cellars", ContactName = "Yoshi Tannamuri", ContactTitle = "Marketing Assistant", Address = new Address("1900 Oak St.", "Vancouver", "BC", "V3F 2K1", "Canada", "(604) 555-3392", "(604) 555-7293") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "LAZYK", CompanyName = "Lazy K Kountry Store", ContactName = "John Steel", ContactTitle = "Marketing Manager", Address = new Address("12 Orchestra Terrace", "Walla Walla", "WA", "99362", "USA", "(509) 555-7969", "(509) 555-6221") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "LEHMS", CompanyName = "Lehmanns Marktstand", ContactName = "Renate Messner", ContactTitle = "Sales Representative", Address = new Address("Magazinweg 7", "Frankfurt a.M.", "", "60528", "Germany", "069-0245984", "069-0245874") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "LETSS", CompanyName = "Let's Stop N Shop", ContactName = "Jaime Yorres", ContactTitle = "Owner", Address = new Address("87 Polk St. Suite 5", "San Francisco", "CA", "94117", "USA", "(415) 555-5938", "") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "LILAS", CompanyName = "LILA-Supermercado", ContactName = "Carlos González", ContactTitle = "Accounting Manager", Address = new Address("Carrera 52 con Ave. Bolívar #65-98 Llano Largo", "Barquisimeto", "Lara", "3508", "Venezuela", "(9) 331-6954", "(9) 331-7256") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "LINOD", CompanyName = "LINO-Delicateses", ContactName = "Felipe Izquierdo", ContactTitle = "Owner", Address = new Address("Ave. 5 de Mayo Porlamar", "I. de Margarita", "Nueva Esparta", "4980", "Venezuela", "(8) 34-56-12", "(8) 34-93-93") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "LONEP", CompanyName = "Lonesome Pine Restaurant", ContactName = "Fran Wilson", ContactTitle = "Sales Manager", Address = new Address("89 Chiaroscuro Rd.", "Portland", "OR", "97219", "USA", "(503) 555-9573", "(503) 555-9646") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "MAGAA", CompanyName = "Magazzini Alimentari Riuniti", ContactName = "Giovanni Rovelli", ContactTitle = "Marketing Manager", Address = new Address("Via Ludovico il Moro 22", "Bergamo", "", "24100", "Italy", "035-640230", "035-640231") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "MAISD", CompanyName = "Maison Dewey", ContactName = "Catherine Dewey", ContactTitle = "Sales Agent", Address = new Address("Rue Joseph-Bens 532", "Bruxelles", "", "B-1180", "Belgium", "(02) 201 24 67", "(02) 201 24 68") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "MEREP", CompanyName = "Mère Paillarde", ContactName = "Jean Fresnière", ContactTitle = "Marketing Assistant", Address = new Address("43 rue St. Laurent", "Montréal", "Québec", "H1J 1C3", "Canada", "(514) 555-8054", "(514) 555-8055") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "MORGK", CompanyName = "Morgenstern Gesundkost", ContactName = "Alexander Feuer", ContactTitle = "Marketing Assistant", Address = new Address("Heerstr. 22", "Leipzig", "", "04179", "Germany", "0342-023176", "") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "NORTS", CompanyName = "North/South", ContactName = "Simon Crowther", ContactTitle = "Sales Associate", Address = new Address("South House 300 Queensbridge", "London", "", "SW7 1RZ", "UK", "(171) 555-7733", "(171) 555-2530") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "OCEAN", CompanyName = "Océano Atlántico Ltda.", ContactName = "Yvonne Moncada", ContactTitle = "Sales Agent", Address = new Address("Ing. Gustavo Moncada 8585 Piso 20-A", "Buenos Aires", "", "1010", "Argentina", "(1) 135-5333", "(1) 135-5535") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "OLDWO", CompanyName = "Old World Delicatessen", ContactName = "Rene Phillips", ContactTitle = "Sales Representative", Address = new Address("2743 Bering St.", "Anchorage", "AK", "99508", "USA", "(907) 555-7584", "(907) 555-2880") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "OTTIK", CompanyName = "Ottilies Käseladen", ContactName = "Henriette Pfalzheim", ContactTitle = "Owner", Address = new Address("Mehrheimerstr. 369", "Köln", "", "50739", "Germany", "0221-0644327", "0221-0765721") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "PARIS", CompanyName = "Paris spécialités", ContactName = "Marie Bertrand", ContactTitle = "Owner", Address = new Address("265, boulevard Charonne", "Paris", "", "75012", "France", "(1) 42.34.22.66", "(1) 42.34.22.77") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "PERIC", CompanyName = "Pericles Comidas clásicas", ContactName = "Guillermo Fernández", ContactTitle = "Sales Representative", Address = new Address("Calle Dr. Jorge Cash 321", "México D.F.", "", "05033", "Mexico", "(5) 552-3745", "(5) 545-3745") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "PICCO", CompanyName = "Piccolo und mehr", ContactName = "Georg Pipps", ContactTitle = "Sales Manager", Address = new Address("Geislweg 14", "Salzburg", "", "5020", "Austria", "6562-9722", "6562-9723") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "PRINI", CompanyName = "Princesa Isabel Vinhos", ContactName = "Isabel de Castro", ContactTitle = "Sales Representative", Address = new Address("Estrada da saúde n. 58", "Lisboa", "", "1756", "Portugal", "(1) 356-5634", "") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "QUEDE", CompanyName = "Que Delícia", ContactName = "Bernardo Batista", ContactTitle = "Accounting Manager", Address = new Address("Rua da Panificadora, 12", "Rio de Janeiro", "RJ", "02389-673", "Brazil", "(21) 555-4252", "(21) 555-4545") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "QUEEN", CompanyName = "Queen Cozinha", ContactName = "Lúcia Carvalho", ContactTitle = "Marketing Assistant", Address = new Address("Alameda dos Canàrios, 891", "Sao Paulo", "SP", "05487-020", "Brazil", "(11) 555-1189", "") }; session.Insert(customer); customers.Add(customer);
- customer = new Customer { CustomerId = "QUICK", CompanyName = "QUICK-Stop", ContactName = "Horst Kloss", ContactTitle = "Accounting Manager", Address = new Address("Taucherstraße 10", "Cunewalde", "", "01307", "Germany", "0372-035188", "") }; session.Insert(custom...
[truncated message content] |
