I'm building some tables for my controls and administration back-end. which ORM or Data Access Later practices does Umbraco core team or experienced Umbraco developers recommend ?
Subsonic is an excellent piece of software, can be a bit cumbersome to setup in your solution - and is easily deployed.
Dbml's are very easy to get started with, integrates seamlessly into to your VS2008 solution - but is a bit more cumbersome to deply since the connection string is compiled into the dll instead of read from a config file.
I'd recommend Subsonic over dbml's since you will probably have to build and deploy your DAL numerous times.
I like to share to this comunity my last project that is an ORM (Object Relational Mappging).
To have experienced several ORMs noticed that there were certain attributes that make it unique but not found a ORM that meeting all the qualities I wanted and not found one that was really simple to use, then for that I have created this new ORM that gathers all of the qualities I want in a ORM beyond that the best feature is the simplicity of use.
Hi,
I think this really depends on your requirements. If its only ever going to be a few tables and the data schema is simple, then a sub-sonic or a linq-to-sql will be fine - whichever you've more experience with.
I personally like nhibernate, using fluent-nhibernate to auto-map and generate my schema, as I know I can do lots of complicated stuff if i want to, but don't want to think about it prematurely. I haven't used this inside umbraco - not that it would be too hard.
Go for whatever you have experience with, or if you don't, whatever you can find most/easiest documentation for.
Recommended ORM or Data Access practices
Hey Folks,
I'm building some tables for my controls and administration back-end. which ORM or Data Access Later practices does Umbraco core team or experienced Umbraco developers recommend ?
Thanks !
Hi,
I would recommend
http://www.mindscape.co.nz/products/LightSpeed/default.aspx
I haven't used it on an Umbraco project though.
There is an free version that allows up to 8 class models so you can try it out.
Cheers
Paul
(disclaimer: I know the developers - they are Microsoft gurus: Microsoft MVP, Microsoft Regional Director etc)
Hi,
I am using SubSonic. Its open source and contains almost everything i need for creating data layer.
Also no problem to integrate it to Umbraco.
I have done alot with subsonic to create umbraco dashboards. Its lightweight and very easy to use and best of all opensource.
Regards
Ismail
After trying a number of ORM's we opted for Entity Spaces. It's not free but the support is excellent and works well with Umbraco.
Take a look here: http://www.entityspaces.com
Kevin Farrow
Revision Software
http://www.revisionsoftware.com
I've used both SubSonic and Linq-to-SQL dbml.
Subsonic is an excellent piece of software, can be a bit cumbersome to setup in your solution - and is easily deployed.
Dbml's are very easy to get started with, integrates seamlessly into to your VS2008 solution - but is a bit more cumbersome to deply since the connection string is compiled into the dll instead of read from a config file.
I'd recommend Subsonic over dbml's since you will probably have to build and deploy your DAL numerous times.
Regards
Jesper Hauge
oh yeah i have also used http://www.llblgen.com/defaultgeneric.aspx cost money though, however the generator wizard is dead easy to use.
Regards
Ismail
Another vote for SubSonic from us.
The Commerce for Umbraco project uses SubSonic and it 'lightens' the data-access burden substantially for us.
One of our favorite features is the Scaffold control that allows you to connect to and edit a table's data in about 15-seconds.
-Paul
Hi,
I like to share to this comunity my last project that is an ORM (Object Relational Mappging).
To have experienced several ORMs noticed that there were certain attributes that make it unique but not found a ORM that meeting all the qualities I wanted and not found one that was really simple to use, then for that I have created this new ORM that gathers all of the qualities I want in a ORM beyond that the best feature is the simplicity of use.
If someone wants to try can download it now from the official site http://entityorm.uuuq.com
There is also de documentation in pdf format and also a sample video.
I want in the future to make more videos.
I await suggestions and criticisms
Regards to this community.
Hi,
I think this really depends on your requirements. If its only ever going to be a few tables and the data schema is simple, then a sub-sonic or a linq-to-sql will be fine - whichever you've more experience with.
I personally like nhibernate, using fluent-nhibernate to auto-map and generate my schema, as I know I can do lots of complicated stuff if i want to, but don't want to think about it prematurely. I haven't used this inside umbraco - not that it would be too hard.
Go for whatever you have experience with, or if you don't, whatever you can find most/easiest documentation for.
Chris
Chris
Here is an ORM that works with Microsoft Access
https://www.kellermansoftware.com/p-47-net-data-access-layer.aspx
is working on a reply...