using System;
using System.Collections.Generic;
using System.Linq;
using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.Text;
namespace ConsoleApplication1
{
    [Table(Name = "Person.Contact")]
    public class m_Contact
    {
        private string _ContactID;
        [Column(IsPrimaryKey = true, Storage = "_ContactID")]
        public string ContactID
        {
            get { return this._ContactID; }
            set { this._ContactID = value; }
        }
        private string _LastName;
        [Column(Storage = "_LastName")]
        public string LastName
        {
            get { return this._LastName; }
            set { this._LastName = value; }
        }
    }
    internal class Program
    {
        private static void Main(string[] args)
        {
            DataContext db =
                new DataContext(
                    @"Server=xxx.xxx.xxx.xxx;Initial Catalog=AdventureWorks;User ID=xxxxxx;Password=xxxxxx;Trusted_Connection=False;");
            Table<m_Contact> test = db.GetTable<m_Contact>();
            db.Log = Console.Out;
            IQueryable<m_Contact> query = from cont in test
                        where cont.LastName == "Adams"
                        select cont;

            foreach (m_Contact item in query)
            {
                Console.WriteLine("ID={0}", item.LastName);
            }
            Console.ReadLine();
        }
    }
}