Constant(ManagerID, typeof(System.Nullable
))
}
);
return this.CreateQuery(mce);
}
A table mapping must be created to define and map the results coming back. And the definition of the
table mapping is no different than that of calling a stored procedure as in the previous examples. Create
the table mapping by adding the code below:
[Table(Name = "EmployeeInfo")]
public partial class EmployeeInfo
{
private int _contactID;
private string _firstName;
private string _lastName;
private string _Title;
241
Part III: LINQ to SQL
[Column(Name = "ContactID", Storage = "_contactID", DBType = "int")]
public int ContactID
{
get
{
return this._contactID;
}
set
{
if ((this._contactID != value))
{
this._contactID = value;
}
}
}
[Column(Name = "FirstName", Storage = "_firstName", DBType = "nvarchar(50)")]
public string FirstName
{
get
{
return this._firstName;
}
set
{
if ((this._firstName != value))
{
this._firstName = value;
}
}
}
[Column(Name = "LastName", Storage = "_lastName", DBType = "nvarchar(50)")]
public string LastName
{
get
{
return this.
Pages:
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392