Hi,

is there a way to use CustomDataAccessObjects with ASP.NET Dynamic Data ?

Regards,
Manfred

Hi Manfred,

Can you give more details about what you are trying to do?  Dynamic Data does have an extensible layer that allows it to work with 3rd party O/R mappers.  e.g. it will work with LLBLGen Pro.

David

Hi,

I want that Dynamic Data does not access my Tables directly but indirectly via a Custom DAO-Class like the following one:

class SomeTableDAO {

 SomeEntity saveSomeEntity(...) { ... }

 SomeEntity findSomeEntityById(int id) { ... }

 SomeEntity findSomeEntityByAnotherLinkedEntity(AnotherLinkedEntityId id) { ... }

}

Is there a way to do such things?

Regards,

Manfred

David:

Do you have any further information on the extensibility for the data layer? Does it interface with SubSonic yet?

 - Craig


 

Manfred: Note that Dynamic Data doesn't directly access your tables.  Instead, it talks to Linq To Sql or Entity Framework (or 3rd party) O/R mapper classes.  Entity Framework lets you create conceptual models that are quite different from the underlying database.

Craig: implementing a layer imvolves implementing a System.Web.DynamicData.ModelProviders.DataModelProvider.  We will have some good samples out soon.  We don't have Subsonic support at this time, but it could potentially come down the road.

David

Hi David,

 ok, but let's say I want that saving a Product should result in updating a Product in the Product-Table AND in inserting a row in the product-history-table. How to achieve that?

I've seen in yor MIX-Webcast, that there is a way to create an MVC-Controller for specific entities. Can I use this mechanism for that?

Thx an best wishes,

Manfred

You have a couple of options for this:

1) Add a database trigger to inserting on the Product table to automatically add the entry in the history table.

2) For the Product table set the Insert operations to go through a stored procedure (you can do this in the Linq to SQL designer). Have your stored procedure modify both tables.

3) You can also create a custom Insert or ListDetails page and capture the Inserting event on the DetailsView and when that is fired have some logic that updates the History table.