Question

我们如何从SDF(网络矩阵)数据库中选择数据,

// Northwnd inherits from System.Data.Linq.DataContext.
Northwnd nw = new Northwnd(@"northwnd.mdf");
// or, if you are not using SQL Server Express
// Northwnd nw = new Northwnd("Database=Northwind;Server=server_name;Integrated Security=SSPI");

var companyNameQuery =
    from cust in nw.Customers
    where cust.City == "London"
    select cust.CompanyName;

foreach (var customer in companyNameQuery)
{
    Console.WriteLine(customer);
}

参考:http://msdn.microsoft.com/en-us/library/b399398.aspx

感谢你的帮助

Answer 1

我认为,Linq To SQL正式得到SQL服务器CE 4.0的支持,尽管Code First 方法 ,另一篇则涉及 < a href="http://www.mikesdotnetting.com/article/185/building-A-Razor-Web-Pages-Site-One-Database-First-and-Enitity-Framework", rel=“nofolpolth> 查看数据库第一个方法。

友情链接