Linq to SQL SP parameters

Question

I have a SP which I want to call from linq. The SP have 5 parameters but i only want to pass/need to 2 of them. how would I call the SP as when i go to add the parameters in code it wont build as it want all 5.

Accepted Answer

You'd have something like this:

```
MyDbDataContext db = new MyDbDataContext();

db.MyStoredProc(customerID, "sometext", null, null, null);
```

Success/failure would depend on the SQL statements inside your sproc dealing with nulls on those last 3 parameters.

Linq to SQL SP parameters

Solution

Problem