OR Mapping Tools and WCSF (VB.NET)

Topics: Web Client Software Factory, UIP Application Block discussion, User Forum
Aug 29, 2007 at 3:35 AM
Hi All

I would like to use some OR Mapping tools with WCSF (VB.NET)? Any good tools could be used?

Aug 29, 2007 at 6:12 AM
Hi Alex, I have been succesfully combining WCSF and the new v3 Web Service Software Factory in a production environment where my data layer is provided by NHibernate. I don't have much experience with other ORM's, and I do now that development on NHibernate has been moving slow the last couple of months. But NHibernate's stability has impressed me. If I would be running Visual Studio 2008, I probably consider the new Entity Framework as soon as it adds support for non-Microsoft databases (my customer demands Oracle for their databases).

Just drop me a message if you want to find out more.

Aug 30, 2007 at 12:20 PM
We evaluate - until now - successfully Subsonic. Subsonic is not a "true" ORM but it can handle easy and in a very "RoR" way Data Layer. So if your development start from the database try subsonic but if you prefer model - > database then use NHibernate.

Oct 18, 2007 at 12:14 AM
Hi Nikos,
I've been successfully testing SubSonic as well. I am very interested in hearing how you have incorporated SubSonic into WCSF. Are you placing it inside a Business Module? Foundational Module? Some other type of entity? Any details you can provide would be very helpful.


Feb 29, 2008 at 2:56 PM
Hi Terry,

I am really sorry that I am miss (somehow) you post, :(
Our approach is based at the Responsive Composite Web Client Reference Implementation. We place the subsonic at a different entity (OrdersRepository.Services)
I have to tell you that recently we replace it with the Castle ActiveRecord but in the same way.

Once again sorry for the delay - any ideas or thoughts would be very helpfully and welcome for me to.

Feb 29, 2008 at 2:56 PM
Edited Feb 29, 2008 at 2:58 PM
--Please Ignore or delete the second message (just an error)
Feb 29, 2008 at 7:31 PM
Have you all looked at the Repository Factory here on CodePlex?
It is very simple, but it is what we have used to create data tiers in the OrderManagement RI. Of course, to make life simple for users and not require installing databases, we replaced all the SQL stuff with XML.

Michael Puleio - patterns & practices

Mar 1, 2008 at 7:56 PM
In addtion to the Repository Factory, there are a host of options available at the platform level, third-party and OS. At the platform level there is LINQ to SQL and the Entity Framework. Third party vendors like IdeaBlade and Deklarit. Finally you look to the OS alternatives such as NHibernate, LLBGen and Subsonic.

David Hayden:http://www.davidhayden.com/blog/dave/ has several posts on different ORM tools with WCSF ncluding using NHibernate ActiveRecord.

WCSF allows you to wire up your own custom services for retrieving entities, addressing ORM concerns. This enables you to bring in the framework of choice.

Mar 2, 2008 at 11:51 PM
Try LLBLGen. By next week they will release a LINQ to LLBLGen provider so a common construct can be used by the devopment team. You have to pay for the product but their support is definitely worth the price as every support case I have opened has been fixed with a new release with in 12 hours.