Scott Klein
"Professional LINQ"
ExecuteMethodCall
(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())),
salesPersonID);
}
}
[Table(Name = "SalesPersonOrders")]
public partial class OrdersBySalesPersonID
{
}
}
Next, define the column properties that create a mapping for the columns being returned by the stored
procedure. Within the partial class, add the following code (you do not need to add the partial class
definition; it is included here as a reference). As you learned about earlier in this chapter, defining the
230
Chapter 11: LINQ to SQL Queries
columns is done by attributing a property with the Column attribute and adding parameters that define
the column name and data type.
[Table(Name = "SalesPersonOrders")]
public partial class OrdersBySalesPersonID
{
private int _productID;
private string _productName;
private int _salesPersonID;
private string _firstName;
private string _middleName;
private string _lastName;
private decimal _unitPrice;
[Column(Name = "ProductID", Storage = "_productID", DBType = "int")]
public int ProductID
{
get
{
return this.
Pages:
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377