I'm just getting started using OpenAccess, and the first database I'm trying to map fails :-(
I'm using the ReverseMapping wizard to map to a database; it warns me about some missing PKs (those were on views which cannot have a pk, but that was easy to fix) and sql_variants which it cannot map ("Unable to resolve .NET type for SQL type - sql_variant"). The code preview shows that these columns were mapped to the object type, which would be perfectly ok for me, so I commented out the #error statement in the generated code.
However, when running the app it throws an exception ("Ungültiger Spaltenname" is German for "Invalid column name" btw):
|Error executing query: Telerik.OpenAccess.RT.sql.SQLException: Ungültiger Spaltenname 'val_class'.
|Ungültiger Spaltenname 'val_id'.
| bei Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()
I don't even know where these column names come from - there's not a single column in the whole database that's named like those...
Can you help? Is using sql_variant supported at all?