DevTools for .NET

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

Shravan

Posted on Jul 15, 2011 (permalink)

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

Reply

Answer A.Alexandrov A.Alexandrov

Posted on Jul 18, 2011 (permalink)

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!

Reply

Shravan

Posted on Jul 18, 2011 (permalink)

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

Reply

Libertad

Posted on Aug 23, 2011 (permalink)

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

Reply

Shravan

Posted on Aug 23, 2011 (permalink)

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

Reply