ashimaz (1) [Avatar] Offline
#1
Following code is how to pass NULL to SQL using parameter

myCmd.Parameters.Add("@Phone", SqlDbType.Decimal).Value = string.IsNullOrEmpty(txtPhone.Text) ? DBNull.Value : (object)Decimal.Parse(txtPhone.Text);

Any idea how to do this in LINQ to SQL

Phone = string.IsNullOrEmpty(txtPhone.Text) ? null : Convert.ToDecimal(txtPhone.Text),

This way its give error since the field Phone in SQL is numeric..