Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
- }
- AdventureWorks db = new AdventureWorks("Integrated Security=sspi");
- Contact cont = db.Contacts.Single(c => c.ContactID == 1280);
- using System.Data.Linq;
- using System.Linq;
Add Comment
Please, Sign In to add comment