I am trying to perform a simple OQL query:
string
queryString = "select org from Org as org where org.id = \"1\"";
IObjectScope scope = Database.Get("DatabaseConnection1").GetObjectScope();
IQuery oqlQuery = scope.GetOqlQuery(queryString);
IQueryResult result = oqlQuery.Execute();
and I get this error:
Invalid syntax: Did you mean '... FROM OrgExtent AS ...' ?
In the online docs, I see the example of "EmployeeExtent". What is this "extent" part?
The name of my table is "Org". I am trying to query a single record whose id equals 1. Any example you can provide or correction to my code would be appreciated.