protected void cleanup(Northwind db)
{
try
{
// Get the name of the Order Details table properly evaluating the Annotation
string tableName = null;// db.Vendor.GetSqlFieldSafeName("order details"); //eg. "[Order Details]"
foreach (object obj in typeof(OrderDetail).GetCustomAttributes(true))
{
if (obj is System.Data.Linq.Mapping.TableAttribute)
{
tableName = ((System.Data.Linq.Mapping.TableAttribute)obj).Name;
}
}
string sql = string.Format("DELETE FROM {0} WHERE Quantity={1}", tableName, TestQuantity);
db.ExecuteCommand(sql);
}
catch (Exception)
{
}
}
