Linq To Sql进阶系列（三）CUD和Log

CreateDatabase
Northwind db = new Northwind("You connection string"); //注意database项，起一个不存在的数据库名称
db.Log = Console.Out;
if (!db.DatabaseExists()) //如果，数据库不存在
db.CreateDatabase(); //创建数据库

var newCustomer = new Customer { CustomerID = "MCSFT",
CompanyName = "Microsoft",
ContactName = "John Doe",
ContactTitle = "Sales Manager",
Address = "1 Microsoft Way",
City = "Redmond",
Region = "WA",
PostalCode = "98052",
Country = "USA",
Phone = "(425) 555-1234",
Fax = null
};
db.Customers.Add(newCustomer);
db.SubmitChanges();

[Column(Storage="_OrderID", AutoSync=AutoSync.OnInsert, DbType="Int NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)]
public int OrderID
{
get
{
return this._OrderID;
}
set
{
if ((this._OrderID != value))
{
this.OnOrderIDChanging(value);
this.SendPropertyChanging();
this._OrderID = value;
this.SendPropertyChanged("OrderID");
this.OnOrderIDChanged();
}
}
}

Orders o = new Orders();
o.ShipAddress = "Test";
db.Orders.Add(o);
db.SubmitChanges();
Console.WriteLine(o.OrderID);

INSERT INTO [dbo].[Orders]([CustomerID], [EmployeeID], [OrderDate], [RequiredDate], [ShippedDate], [ShipVia], [Freight], [ShipName], [ShipAddress], [ShipCity], [ShipRegion], [ShipPostalCode], [ShipCountry]) VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12)
SELECT [t0].[OrderID]
FROM [dbo].[Orders] AS [t0]
WHERE [t0].[OrderID] = (SCOPE_IDENTITY())
-- @p0: Input StringFixedLength (Size = 5; Prec = 0; Scale = 0) []
-- @p1: Input Int32 (Size = 0; Prec = 0; Scale = 0) []
-- @p2: Input DateTime (Size = 0; Prec = 0; Scale = 0) []
-- @p3: Input DateTime (Size = 0; Prec = 0; Scale = 0) []
-- @p4: Input DateTime (Size = 0; Prec = 0; Scale = 0) []
-- @p5: Input Int32 (Size = 0; Prec = 0; Scale = 0) []
-- @p6: Input Currency (Size = 0; Prec = 19; Scale = 4) []
-- @p7: Input String (Size = 0; Prec = 0; Scale = 0) []
-- @p8: Input String (Size = 4; Prec = 0; Scale = 0) [Test]
-- @p9: Input String (Size = 0; Prec = 0; Scale = 0) []
-- @p10: Input String (Size = 0; Prec = 0; Scale = 0) []
-- @p11: Input String (Size = 0; Prec = 0; Scale = 0) []
-- @p12: Input String (Size = 0; Prec = 0; Scale = 0) []
-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20706.1