Database

MyDataContext dataContext = new MyDataContext();<br />
Product myProduct = dataContext.Products.SingleOrDefault<Product>(p => p.Id == productId);

public abstract class BaseTable<T>
{
    public static T FromId(int id)
    {
        MyDatabaseDataContext dataContext = DatabaseContextHelper.GetDatabaseContext();

        StringBuilder sql = new StringBuilder();
        sql.Append("SELECT ");

        MetaTable metaTable = dataContext.Mapping.MappingSource.GetModel(typeof(TopicDatabaseDataContext))
                                        .GetMetaType(typeof(T)).Table;

        foreach (MetaDataMember dm in metaTable.RowType.DataMembers)
        {
            if (dm.DbType != null)
            {
                sql.Append(dm.MappedName).Append(",");
            }
        }

        sql.Remove(sql.Length - 1, 1);

        sql.Append(" FROM ").Append(metaTable.TableName).Append(" WHERE Id = ").Append(id);

        return dataContext.ExecuteQuery<T>(sql.ToString()).FirstOrDefault<T>();
    }
}

CREATE DATABASE [ATCommon] ON  PRIMARY <br />
( NAME = N'ATCommon', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ATCommon.mdf' , SIZE = 40768KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )<br />
 LOG ON <br />
( NAME = N'ATCommon_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ATCommon_log.ldf' , SIZE = 5184KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)<br />
 COLLATE SQL_Latin1_General_CP1_CI_AS<br />
END