Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • heoque 7 posts 22 karma points
    Apr 23, 2009 @ 01:37
    heoque
    0

    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 !

  • Paul Blair 466 posts 731 karma points
    Apr 23, 2009 @ 02:39
    Paul Blair
    0

    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)

  • Denis 42 posts 20 karma points
    Apr 23, 2009 @ 02:56
    Denis
    0

    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.

  • Ismail Mayat 4511 posts 10091 karma points MVP 2x admin c-trib
    Apr 23, 2009 @ 10:25
    Ismail Mayat
    0

    I have done alot with subsonic to create umbraco dashboards. Its lightweight and very easy to use and best of all opensource.

    Regards

    Ismail

  • Kevin 1 post 20 karma points
    Apr 23, 2009 @ 11:23
    Kevin
    0

    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

  • Jesper Hauge 298 posts 487 karma points c-trib
    Apr 23, 2009 @ 11:50
    Jesper Hauge
    0

    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

  • Ismail Mayat 4511 posts 10091 karma points MVP 2x admin c-trib
    Apr 23, 2009 @ 11:58
    Ismail Mayat
    0

    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

  • Paul Sterling 718 posts 1534 karma points MVP 9x admin c-trib
    Apr 23, 2009 @ 20:11
    Paul Sterling
    0

    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

  • hugo 1 post 20 karma points
    May 22, 2009 @ 00:07
    hugo
    0

    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.

  • Chris McVittie 103 posts 75 karma points
    May 22, 2009 @ 15:26
    Chris McVittie
    0

    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


  • asavasamuel 2 posts 22 karma points
    Mar 09, 2013 @ 10:24
    asavasamuel
    0

    Chris

    Here is an ORM that works with Microsoft Access
    https://www.kellermansoftware.com/p-47-net-data-access-layer.aspx

Please Sign in or register to post replies

Write your reply to:

Draft