a newbie question on Linq To Sql

Question

When I do this manually

public class AdventureWorks : DataContext { public AdventureWorks(string connection) : base(connection) { } public Table<Contact> Contacts; } [Table(Name = "Person.Contact")] public class Contact { [Column(DbType = "int not null", IsPrimaryKey = true, IsDbGenerated = true)] public int ContactID; [Column(DbType = "nvarchar(8) not null")] public string Title; [Column(DbType = "nvarchar(50) not null")] public string FirstName; [Column(DbType = "nvarchar(50) not null")] public string MiddleName; [Column(DbType = "nvarchar(50) not null")] public string LastName; [Column(DbType = "nvarchar(50) not null")] public string EmailAddress; [Column(DbType = "int")] public int EmailPromotion; [Column(DbType = "bit")] public byte NameStyle; [Column(DbType = "varchar(40)")] public string PasswordHash; [Column(DbType = "varchar(40)")] public string PasswordSalt; }

I can use something like this

AdventureWorks db = new AdventureWorks("Integrated Security=sspi"); Contact cont = db.Contacts.Single(c => c.ContactID == 1280);

But If I rely on LINQ surface (designer), drag and drop contact table on the dbml file , I can see db.Contacts, but can not see the "db.Contacts.Single" method.

Is there anything to do with dbml property configiuration?

Please advise.

Thanks a lot.

Dave Markle · Accepted Answer · 2008-12-09 19:46:22Z

4

Are you "using" these two namespaces?

using System.Data.Linq; using System.Linq;

answered Dec 9, 2008 at 19:46

Dave Markle

98.3k20 gold badges152 silver badges172 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

a newbie question on Linq To Sql

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related