Description
For example, here is an EF generated query:
SELECT `c`.`departmentid`, `c`.`budget`, `c`.`instructorid`, `c`.`name`, `c`.`rowversion`, `c`.`startdate`
|
FROM `contoso`.`department`.`department` AS `c`
|
And here is the JSON written to the database via the EF provider:
{
|
"$id": "1",
|
"departmentID": 1,
|
"name": "English",
|
"budget": 350000,
|
"startDate": "2007-09-01T00:00:00",
|
"instructorID": 9,
|
"rowVersion": null,
|
"administrator": {
|
"$id": "2",
|
"hireDate": "1995-03-11T00:00:00",
|
"courseAssignments": null,
|
"officeAssignment": null,
|
"id": 9,
|
"lastName": "Abercrombie",
|
"firstMidName": "Kim",
|
"fullName": "Abercrombie, Kim"
|
},
|
"courses": null
|
}
|
SQL++ is case sensitive, so this is what the output from the server is:
[
|
{
|
"budget": 350000,
|
"name": "English"
|
},
|
{
|
"budget": 100000,
|
"name": "Mathematics"
|
},
|
{
|
"budget": 350000,
|
"name": "Engineering"
|
},
|
{
|
"budget": 100000,
|
"name": "Economics"
|
}
|
]
|