Databases Reference
In-Depth Information
Listing 19-2. LinqToSql.cs
using System;
using System.Linq;
using System.Data.Linq;
using System.Data.Linq.Mapping;
namespace Chapter19
{
[Table]
public class Customers
{
[Column]
public string customerId;
[Column]
public string companyName;
[Column]
public string city;
[Column]
public string country;
}
class LinqToSql
{
static void Main(string[] args)
{
// connection string
string connString = @"
server = .\sqlexpress;
integrated security = true;
database = northwind
";
// create data context
DataContext db = new DataContext(connString);
// create typed table
Table<Customers> customers = db.GetTable<Customers>();
Search WWH ::




Custom Search