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

[Shravan]

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

[A.Alexandrov]

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

[Shravan]

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

[A.Alexandrov]

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

[Libertad]

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

[Shravan]

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

[A.Alexandrov]

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