[RESOLVED] Database Programming - What Methodology

[Kenkob]

I am a keen amatuer wishing to learn database programming for desktop application only at this time. Until today, I had considered using Linq to SQL,
but having perused some comments within the forum it appears that Linq to SQL is dead.

Is the way ahead Entity Framework, or should I stay where I've started with ADO.Net? but, which version.

[techgnome]

Personally, I think you're better off learning it all. Start with ADO.NET, then work with LINQ (to which there is more than just Linq to SQL), then learning EF....which is the new kid on the block.

-tg

[Kenkob]

A lot to learn, and very confusing at times.
Thanks for for response.

[mendhak]

You definitely want to start at the lowest level available to you in your context, which is plain old ADO.NET. When you then move on to other technologies, you'll have a much better understanding of what's happening behind the scenes.

L2S and EF are... somewhat nice but make sure you always use the right tech for the right job, no point in picking a tech because you like it. All I'm trying to say is that devs can get overzealous with their use of L2S and EF and it's not always the best path to go down.

[Kenkob]

Thanks you very much, I have only recently moved from using RAD Wizards and am now getting more into ADO.NET. I think I will follow your advise and venture anew when the situation requires it.