Data Services Wizard-Open Access-Data Services for .NET4 Version 1

7 posts, 1 answers
  1. Shravan
    Shravan avatar
    10 posts
    Member since:
    Dec 2010

    Posted 15 Jul 2011 Link to this post

    I am using VS 2010 sp1, C#, ORM Q2 2011 on Windows Xp querying SQL Server 2005.

    Although I had no trouble with WCF Endpoints service, I had an error while using the Data Services for .NET 4 Version 1 or 2.

    "There are properties in the selected entities with type(s) not supported by WCF Data Services.
    The full list of supported primitive types can be found here: http://msdn.microsoft.com/en-us/library/bb399213.aspx.
    "

    Now I understand that some data types got messed up. But I am sure, I used just the designer and barely made any changes to that specified in the documentation http://www.telerik.com/help/openaccess-orm/getting-started-root-getting-started-with-dsw.html .

    Any help would be appreciated.

    Thanks,
    Shravan
  2. Answer
    A.Alexandrov
    Admin
    A.Alexandrov avatar
    25 posts

    Posted 18 Jul 2011 Link to this post

    Hi Shravan,

    The error you describe is shown when the model contains entities with properties of the following types:
    Char,
    UInt16,
    UInt32,
    UInt64,
    Nullable<Char>,
    Nullable<UInt16>,
    Nullable<UInt32>,
    Nullable<UInt64>.

    So in order to generate WCF Data Services (Astoria 1/2) you have to check manually each property of all entities, and if there is a property with unsupported type, you have to change it. For instance, change all not supported integer types to Int32 or Int64 and Char to String.
    If you have any other problems or concerns, please do not hesitate to contact us again.

    Regards,
    A.Alexandrov
    the Telerik team

    Register for the Q2 2011 What's New Webinar Week. Mark your calendar for the week starting July 18th and book your seat for a walk through of all the exciting stuff we will ship with the new release!

  3. DevCraft banner
  4. Shravan
    Shravan avatar
    10 posts
    Member since:
    Dec 2010

    Posted 18 Jul 2011 Link to this post

    Changing the types from char to string did really work for Data Services for .NET 4 Version 1 or 2, but I already began working on the WCF Endpoint Services. The designer generated 19 class files, one each for the data tables and the views. But I see only 12 of them being exposed in the WCF EndPoint Service using the Data Services Wizard. I am missing all the views. How do I get them to work?

    I mean it would be pointless if someone said, "You can't use views", ORM seems to be supporting.  ) :

    Shravan
  5. A.Alexandrov
    Admin
    A.Alexandrov avatar
    25 posts

    Posted 20 Jul 2011 Link to this post

    Hello Shravan,

    I am afraid that you will not be able to generate a data service for entities mapped to views - we filter them, because generally CUD operations cannot be made against a view. You will have to use entities mapped to tables instead.

    Best wishes,
    A.Alexandrov
    the Telerik team

    Register for the Q2 2011 What's New Webinar Week. Mark your calendar for the week starting July 18th and book your seat for a walk through of all the exciting stuff we will ship with the new release!

  6. Libertad
    Libertad avatar
    53 posts
    Member since:
    Sep 2008

    Posted 23 Aug 2011 Link to this post

    Hi,
    I've changed all the entities with properties of the types mentioned in above post but the Data Service Wizard doesn't accept my model and tell me about the existing unsupported types in my entities.
    I've created my model from an Oracle database.

    What's the problem?  Is there any verification tools to find these kinds of mismatch types in my model automatically?
    Thanks
  7. Shravan
    Shravan avatar
    10 posts
    Member since:
    Dec 2010

    Posted 23 Aug 2011 Link to this post

    Just change char and char[] to string and string[].
    To be specific, varchar(1), char(1) ....etc. to string.

    There are also other issues somelike precision of Oracle datatypes that automatically get parsed in ORM, but it might be a good idea if you start adding one table at a time then see if you could use the DSW and sortout what creates the issue. Also try to add tables with less relations, and tables with atleast one primary key(identity key) etc.

    Hope you have good luck with this.
    Shravan
  8. A.Alexandrov
    Admin
    A.Alexandrov avatar
    25 posts

    Posted 24 Aug 2011 Link to this post

    Hello Libertad,

    Just to add a note to Shravan's post, maybe you have fixed the types only in the entities that you want to generate, but since Data Services Wizard generates the dependent entities as well(the entities that the selected one have relations to) then you have probably missed fixing their property types also. Unfortunately, the verification that will assist the user by showing them the exact property of the exact entity that has some problems in it will be implemented in a future version of Data Services Wizard, so currently there is no automatic way of resolving such kind of problems. 

    However if you still continue having such problems you can send us your RLINQ file and we will take a debug locally using it and probably give you a solution or a workaround.

    Best wishes,
    A.Alexandrov
    the Telerik team

    Thank you for being the most amazing .NET community! Your unfailing support is what helps us charge forward! We'd appreciate your vote for Telerik in this year's SQL Server Community Awards. We are competing in TWO categories and every vote counts! VOTE for Telerik NOW >>

Back to Top
DevCraft banner