Simple SQL Server Database connectivity in ASP .NET 4.0 in MVC 3

Question

0.00/5 (No votes)

See more:

Hello Team,
I wanted to learn MVC Architecture and database connectivity. I dont want to use EF or LINQ. So in accordance with plain ASP .NET connectivity code, can anyone please help me for that.

Consider Following point:
1) No Entity Framework and No LINQ.
2) Simple SQL Client objects, SQLConnection, SQLCommand, SQLDataadapter etc.
3) and Perform Insert, Update, Delete, Select ...operations as their ActionResult in the controller.
4)How to create connection string.

Microsoft Visual Studio 2010 (Professional)
MVC 3 (RAZOR/ASPX)
SQL 2008 Management Studio R2

can any one please provide me a newly created step by step tutorial ....so that i can have a clear understanding..!!!
please..!

thank u

Posted 10-Oct-13 0:32am

ajaysutar

Updated 14-Oct-13 23:48pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Eduard Keilholz · Answer 1 · 2013-10-10T01:10:00

The best way is to create a multi-tier solution.

One project containing poco's
One project data layer that references the poco's
One project (business or something) that references data and poco
One MVC Website website that references business and poco

Your website retrieves a request
The request want (for example) a list of products
It starts a new instance of a products business class in the business project. This class checks if everything is fine (enough permissions and stuff) and then instanciates a products data object.
This one queries the database and converts the query result in (a list of) poco object(s). This will be returned.
Your business will also return the (list of) poco(s).

This leaves you with the poco's right there, in your controller. Pass them to a view and you're happy.

Cheers,
Eduard