I'm having some probs since upgrading to the newest version of Gentle this morning.
The following code, which worked previously, is now throwing a SQLException, \"Incorrect syntax near the keyword 'from'.\"
- Code: Select all
SqlBuilder sb = new SqlBuilder(StatementType.Select, typeof(Page));
SqlStatement stmt = sb.GetStatement(true);
return (ArrayList)ObjectFactory.GetCollection(typeof(Page), stmt.Execute());
If I step through in the debugger, it looks as though the SqlBuilder is generating the SQL \"select from Page\". Ie, with no field names, as it did previously.
Do I need to specify the fields or something?
I haven't seen anyone else having problems, so should I perhaps be retrieving objects in a different way?
Many thanks for any help. Nice work on Gentle.NET. I'm really liking the look of it.