/// <summary> /// Create a new Customer object. /// </summary> /// <param name="id">Initial value of the Id property.</param> /// <param name="name">Initial value of the Name property.</param> public static Customer CreateCustomer(global::System.Int64 id, global::System.String name) { Customer customer = new Customer(); customer.Id = id; customer.Name = name; return customer; }
static void Main(string[] args) { // =============== 构造数据 =============== Console.ForegroundColor = ConsoleColor.Green; int customerCount = 10000; List<Customer> customers = new List<Customer>(); for (int i = 0; i < customerCount; i++) { Customer customer = new Customer() { Name = "Dennis Gao" + i, Address = "Beijing" + i, Phone = "18888888888" + i, }; customers.Add(customer); Console.Write("."); } Console.WriteLine(); try { // =============== 插入数据 =============== Console.WriteLine(string.Format( "Begin to insert {0} customers into database...", customerCount)); Stopwatch watch = Stopwatch.StartNew(); using (RetailEntities context = new RetailEntities()) { context.BulkInsert(customers); context.SaveChanges(); } watch.Stop(); Console.WriteLine(string.Format( "Done, {0} customers are inserted, cost {1} milliseconds.", customerCount, watch.ElapsedMilliseconds)); } catch (Exception ex) { Console.WriteLine(FlattenException(ex)); } Console.WriteLine("====================================="); // =============== 查询结果 =============== try { using (RetailEntities context = new RetailEntities()) { int countOfCustomers = context.Customers.AsQueryable().Count(); Console.WriteLine(string.Format( "Now, we have {0} customers.", countOfCustomers)); } } catch (Exception ex) { Console.WriteLine(FlattenException(ex)); } Console.WriteLine("====================================="); // =============== 清理 =============== Console.WriteLine(); Console.WriteLine("Press any key to close..."); Console.ReadKey(); }
/// <summary> /// Deprecated Method for adding a new object to the Customers EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToCustomers(Customer customer) { base.AddObject("Customers", customer); }