Linq - to - SQL InsertOnSubmit Example

///

/// To add new dimensional parameter values
///

///
///
public static bool Insert(List lstdimparaassignmnet)
{
bool result = false;

try
{
DataAccessDataContext db = new DataAccessDataContext();

//To insert new Material parameter
if (lstdimparaassignmnet.Count > 0)
{
foreach (CustomTableClass m in lstdimparaassignmnet)
{
List lsttemp = new List();

//To check material values is already exist
lsttemp = (from dpa in db.CustomTable
where dpa.CustomTableField1 == m.CustomTableClassProperty1
select dpa).ToList();
if (lsttemp.Count > 0)
{
CustomTableClass dpaobj = new CustomTableClass ();
//dpaobj = lsttemp[0];
dpaobj.Field1= m.CustomTableClassProperty1 ;
dpaobj.Field2 = m.CustomTableClassProperty2 ;
dpaobj.field3 = m.CustomTableClassProperty3 ;
dpaobj.field4 = m.CustomTableClassProperty4 ;
db.SubmitChanges();
}


}
result = true;
}
catch (Exception Ex)
{
Message( "Error on asssigning Values")
result = false;
return result;
}
return result;
}