No support for sql_variant?

Thread is closed for posting
2 posts, 0 answers
  1. Jens
    Jens avatar
    12 posts
    Member since:
    Mar 2009

    Posted 08 Dec 2009 Link to this post


    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?

  2. Ady
    Ady avatar
    589 posts

    Posted 10 Dec 2009 Link to this post

    Hello Jens,

     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,
    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.
Back to Top