Which ORM is used on asp.net

Hi,

I have been doing some digging into ORMs and was wondering what ORM was decided upon for building this new site???

Cheers,

Mike.

Re: Which ORM is used on asp.net

In my opinion it does not matter, since what is really important is that you understand why we use orm's, what problems does it solve, etc.

Which specific tool you use for the job, is completely up to you.

Personally, I would recommend Entity Framework if you are still at the level of having to decide which one is better.

Myself moved on to nHibernate, not because anything wrong with EF, just because I wanted to learn something new at the time (never got a reason to go back though).

(PS: When I started out with ORM's I first created my own. Simply static classes that would convert a dataset to a domain object. :-D )

Re: Which ORM is used on asp.net

The reason Im asking is that this site is extremely fast but the day I started using EF my sites became very slow. All my MVC/EF sites are slow. I have about 20 sites running Classic ASP with MS Access databases that are still running fast and fine. They are about 12 to 13 years old and the funny thing is, they just keep working! They wont be going anywhere until the clients put some $$$ together eitherlol.

Re: Which ORM is used on asp.net

We don't use a ORM, it's a custom data access layer.

Re: Which ORM is used on asp.net

Wouldnt that kind of imply that the Entity Framework is not the best option for me going forward???

Re: Which ORM is used on asp.net

No - it would not imply that.

All it implies is that the developers of this particular application felt that a custom data access layer was the best option for them at the time.

Re: Which ORM is used on asp.net

@ bojangles

bojangles

Wouldnt that kind of imply that the Entity Framework is not the best option for me going forward???

absolutely not!!! how did you come to such a conclusion?

there are several .NET ORM options ... my own preference currently is EF 4.2 ... EF 4.1 introduced Code First ...

just because somebody built their own DAL in no way diminishes the advantage of using an ORM.

See http://msdn.microsoft.com/en-us/data/ef

AFAIK, forums.asp.net is a WebForms application whereas stackoverflow.com is an ASP.NET MVC application ... would you not use ASP.NET MVC because forums.asp.net used something else?

TIMTOWTDI =. there is more than one way to do it

* FWIW: http://wekeroad.com/2009/04/22/i-spose-ill-just-say-it-you-should-learn-mvc YMMV

Re: Which ORM is used on asp.net

@ bojangles

Mike (Mikesdotnetting) makes this valid point:

Mikesdotnetting

All it implies is that the developers of this particular application felt that a custom data access layer was the best option for them at the time.

if they were to do it again, their choice might be something totally different.

before Jim Newkirk and Brad Wilson gave us xUnit.net, i would likely have chosen NUnit (which BTW, Jim Newkirk wrote NUnit 2.0).

change happens so fast in the programming universe that even Star Trek's android Data might encounter difficulty keeping up to date.

Re: Which ORM is used on asp.net

Thanks everyone,

Im writing all my new web apps in MVC, I have one huge site I built with Webforms and still manage a lot of Classic ASP sites. Back in the classic ASP days, I had a model I used for about 10 years that I built a all my sites around, it worked and still does, now I would like to do the same with MVC.

I just kind of get the feeling that using the EF is cheating as its so easy and that makes me feel there could be a better way to put my modal together.

Gerry, I love the Data reference, Im a Trekker from way back, but the learning curve into Webforms and now MVC has been a mission and I would like to stick with something for a while and not have to learn too much more for a few years. Now we have the whole mobile revolution to deal with Ive had to learn more and more languages.

Unfortunately my business is building web applications and doesnt allow me the time to build my own ORMs, I would love to give it a go, its not rocket science, its just a little bit trickierlol.

Cheers,

Mike.

Re: Which ORM is used on asp.net

bojangles
I just kind of get the feeling that using the EF is cheating as its so easy

I feel the same way about Visual Studio compared to Notepad, but hey - I manage to get over that.

;o)

Re: Which ORM is used on asp.net

@ bojangles

Mike, you do not need to build your own ORM ... you can use EF, NHibernate, SubSonic (Rob Conery), ...

Like Mike of Mikesdotnetting wrote, using an ORM, or for that matter, any tool, is not cheating ... imho, it's simply working smart ... I waited far too long to move to Visual Studio ... i'm still kicking myself for all the time that i wasted not going to vs eariler ... now, i move no later than rtm/rtw (product release) and often in alpha if the product is strong (example: ASP.NET MVC 4).

Re: Which ORM is used on asp.net

@ bojangles

bojangles

Now we have the whole mobile revolution

Mike, i forgot to mention that ASP.NET MVC 4 will have strong support for mobile applications, example:

http://www.asp.net/whitepapers/mvc4-release-notes#_Toc303253809 "Mobile Project Template"

If youre starting a new project and want to create a site specifically for mobile and tablet browsers, you can use the new Mobile Application project template. This is based on jQuery Mobile, an open-source library for building touch-optimized UI:

also, even the standard template:

"In addition to cosmetic improvements, theres improved functionality in the new template.

The template employs a technique called adaptive rendering to look good in both desktop browsers and mobile browsers without any customization."

Re: Which ORM is used on asp.net

Funny, I built my first mobile specific site early last year in MVC3 and jQueryMobile, I think beta, didnt wait for version 1 and while asking some questions on this site, Rick pointed me in the direction of his tutorial on MVC4, very cool! So I didnt wait for the release either, now have two MVC4 sites in production and they work great.

The other languages I mentioned are Java and objective C, now Im just waiting for HTML5 to have the kind of control over the phone as a native app has and I will forget those languages! J

Thanks everyone, you have given me total confidence in MVC and EF here, I was pretty confident anyway!

Cheers,

Mike.

Re: Which ORM is used on asp.net

Hi,

bojangles
Im just waiting for HTML5

You don't need t wait: http://channel9.msdn.com/Events/TechDays/Techdays-2012-the-Netherlands/2159. Can't see if the video is already up as Channel9 gets blocked at my current client but it was a very interesting session.

Grz, Kris.

Re: Which ORM is used on asp.net

bojangles
This may be a rant but you have me thinking about the mobile world right now and this is probably not the right thread to be writing this and defiantly not the right forum

Yes, you are correct. I'm now closing this thread, since you've received the original answer you were seeking, and some good insight.