Database

DBCC SHRINKDATABASE ('MYDATABASE', 0,TRUNCATEONLY)

<br />
ID     Name     PriceEffectiveDate      Price<br />
----   ----   --------------------      -----<br />
1      Shoe    1-1-2006                 $1<br />
2      Glove   1-1-2006                 $2<br />
...<br />
41     Shoe    1-1-2007                 $2<br />
<br />
(etc)<br />

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>();
    }
}