CODEWITHSUNDEEP
.netsql-servervisual-studio-2008sql-server-2008
edgarmtze
edgarmtze

Reputation: 25048

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...

Upvotes: 1

Views: 248

Answers (4)

Mark
Mark

Reputation: 31

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!

Upvotes: 0

CoderSteve
CoderSteve

Reputation: 648

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.

Upvotes: 0

Jeremy
Jeremy

Reputation: 3951

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

Upvotes: 1

taylonr
taylonr

Reputation: 10790

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.

Upvotes: 0

Related Questions