Dynamic Data with ObjectDataSource

Question

User-1757069096 posted

Hi,

I am developing a Dynamic Data web application with Oracle as backend.

I am using Object Data source instead of EntityDataSource or LINQDataSource since the LINQ to SQL model or EntityData Model does not support Oracle, by default.

I am using DynamicObjectdataSource from DynamicDataFutures.

I am able to dynamically generate the necessary fields for a gridview, using an ObjectModel but I am not able to replicate two features:

1. I am not able to navigate through the Foreign keys between the Tables as in a Dynamic Web application against a LINQ ORM.

2. I am not able to use FilterRepeater and not able to register DynamicDataManager as it expects that WhereParamters of IDataSource to be implemented.

Please guide me how to proceed.   

 

Answer 1

User1641955678 posted

Indeed, there are limitations to using DynamicObjectDataSource.  In order for Dynamic Data to work with relationships, it needs to have a way to discover them.  When using Linq To Sql or EF, there are metadata APIs that give you this info.  But when everything is done by calling your custom CRUD methods, that information is not available anywhere.

In the future, we are looking at making these scenarios go further by having a data source that understands both the concept of a business model (as in ObjectDS) and the concept of LINQ queries.

thanks,
David

Answer 2

User-1757069096 posted

Thanks a lot Sir.

Answer 3

User-1005219520 posted

I am developing a Dynamic Data web application with Oracle as backend. I am using Object Data source instead of EntityDataSource or LINQDataSource since the LINQ to SQL model or EntityData Model does not support Oracle, by default.

Oracle providers for EF are in the works. See

http://blogs.msdn.com/adonet/archive/2008/05/06/recent-ado-net-entity-framework-provider-news-demos-and-downloads.aspx<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>http://blogs.msdn.com/adonet/archive/2008/06/05/entity-framework-provider-updates.aspx <o:p></o:p>http://blogs.msdn.com/adonet/archive/2008/06/24/new-sample-provider-demonstrates-oracle-connectivity.aspx <o:p></o:p>

A EF Manager stated:

Since the EF hasn’t yet RTM’d for v1 (“real soon now”tm) , it’s not surprising that none of the third party EF providers have released.  As far as I know, though, the various third party providers are still on track.  I believe several were scheduled to release within 3 months of EF RTM or something like that.