Learning .net`s basics with SQL Server

How to begin studying .net and SQL Server communication, any good tutorial that had helped you to learn both, (I am refering how to communicate them)??

I have installed SQL Server management 2008, and now I would like to use .net to start communicating both .net and SQL Server.

What steps must be followed to achieve this...

• You start Visual Studio 2008, and make a routine, a class or...开发者_开发技巧 to connect to SQL Server...
• Do you have a simple example?

As a beginner you may benefit from learning Entity Framework. You may prefer to go the route of classic SQL server ADO.Net SqlConnections.

Entity Framework provides a really simple way for you to connect, retrieve and manipulate the data in your database.

Tutorial here: http://msdn.microsoft.com/en-us/library/bb399182.aspx

If you really want to understand what's going on, check out Ado.Net

This tutorial seems to do a decent job of starting with the basics of Ado.Net and moving on to how to actually use it.

After you get that done, you might take a look at an ORM such as Entity Framework or NHibernate. But I think you should understand the basics before jumping straight to an ORM.

To start with the basics, you should look at using a datareader. That's a pretty fundamental way to communicate with a database server. See this example (scroll down to the examples section) to get started.

For updates, see the SqlCommand.ExecuteNonQuery example in the docs.

If you haven't gone through the official ASP.NET step-by-step overview already, Step 4 deals with databases and so you may want to take a quick look. It's pretty introductory but should get you started.

If you're a A/V learner like me, though, I definitely recommend lynda.com. It's a really good video tutorial service that includes both ASP.NET and SQL Server courses. Some of the segments are free but, for just $25/month, it's a pretty good deal, especially if you intend to dive in and devote some time to this.

Best of luck!