Data context & database create

var db = new MyDataContext(@"server=.SQLEXPRESS;database=my;integrated security=SSPI");

if (!db.DatabaseExists()) db.CreateDatabase();

var r = new string[] { "WA", "OR" };

var customers = from c in db.Customers

where c is Customer &&

(c.Region==null || r.Contains(c.Region))

select c;

var customer = new Customer() {

CustID = "CHIPS",

CompanyName = "Mr. Chips" };

db.Customers.InsertOnSubmit(customer);

db.SubmitChanges();

customer.ContactName = "Adam";

customer.Location = null;

db.SubmitChanges();

var only = db.Customers.SingleOrDefault(c

=> c.CustID == "CHIPS");

var first = db.Customers.FirstOrDefault(c

=> c.CustID == "CHIPS");

var page3 = (from c in db.Customers

orderby c.ContactName, c.City descending

select c).Skip(10).Take(5);

db.Customers.DeleteOnSubmit(customer);

db.SubmitChanges();

var totals = from c in db.Customers

group c by c.Country into g

select new Summary { Country = g.Key,

CustomerCount = g.Count(),

OrdCount = g.Sum(a=> a.Orders.Count)};

var labels = (from c in db.Customers

join o in db.Orders

on c.CustID equals o.CustID

select new { name = c.ContactName,

address = o.ShipAddress

}).Distinct();

[Table(Name="dbo.Customers")]

[InheritanceMapping(Code="C",

Type=typeof(Customer), IsDefault=true)]

[InheritanceMapping(Code="T",

Type=typeof(TopCustomer)]

[Column(Storage="_CustomerID",

DbType="Int NOT NULL", Name="custid",

IsPrimaryKey=true)]

[Column(Storage="_Category",

DbType="Char(1)",

IsDiscriminator=true)]

[Column(Storage="_Ver", IsVersion=true

AutoSync=AutoSync.Always,

UpdateCheck=UpdateCheck.Never,

DbType="rowversion NOT NULL",

CanBeNull=false, IsDbGenerated=true)]

[Association(Name="Country_Customer",

Storage="_Country", ThisKey="CoID",

IsForeignKey=true)]

var r = from c in db.Customers

join o in db.Orders on

new { c=c.CustID, r=c.Country } equals

new { c=o.CustID, r=o.ShipCountry }

into j

from jo in j.DefaultIfEmpty()

select new { c, jo };

Alıntı...