[Solved] ORM for Sitefinity

[Tarun]

Hi,

I want to use OpenAccess ORM  with sitefinity. Can you suggest which mapping should I use as well I have some new table in sitefinity database and want to create a DAL(Update/Insert/Delete) for sitefinity's custom module. I used forward mapping which only created Update/delete...etc for only sitefinity's table not for our new tables.Also I used reverse mapping which even does not create Update/delete..etc for sitefinity's table.

Please let me know the solution.

Thanks!

[Zoran]

Hi Tarun,

 Could you clarify a bit on what problems did you encounter during your development with OpenAccess and Sitefinity. There should be no issues while using the two products. For example if you use forward mapping you could extend the Sitefinity database or place your classes in a separate database. The Create/Update/Delete operations will be available for those classes through OpenAccess no mater which database you use. If you create some table in the Sitefinity database and do Reverse Mapping, I suggest you to only reverse map that particular table and than do CUD operations only on it. It is nevertheless possible to reverse map the whole Sitefinity database and them modify it thorough OpenAccess, but that is not recommended as the Sitefinity product takes care of the maintenance of its tables. 

Could you be more specific about what are you trying to achieve, and which obstacles did you have while trying to do that? 

Regards,
Zoran
the Telerik team