This question is locked. New answers and comments are not allowed.
Hi,
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):
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?
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() |
Can you help? Is using sql_variant supported at all?
1 Answer, 1 is accepted
0
Hello Jens,
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
I'm sorry to admit but the sql_variant type is currently not supported and I cannot provide you an exact timeframe when we would implement support for it.
Sincerely yours,Ady
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.