Order ord = new Order
{
OrderID = 12000,
ShipCity = "Seattle",
OrderDate = DateTime.Now
};
db.Orders.InsertOnSubmit(ord);
try
{
db.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
db.SubmitChanges();
}
Use above code as sample, try this way.
Hope this will help !!!