internal static int CreatePriceList() { TechTestDataContext db = new TechTestDataContext(); int maxID = (from distPriceList in db.DistributorPriceLists select distPriceList.PriceListID).Max(); maxID++; DistributorPriceList distributorPriceList = new DistributorPriceList() { PriceListID = maxID }; db.DistributorPriceLists.InsertOnSubmit(distributorPriceList); db.SubmitChanges(); return maxID; }