connect to DB using MVC

Question

I have an asp.net mvc application and i need to connecto to the DB i have saw a tutorial video that connect to DB using wizard by adding DB connection and determine the DB and add a model but i need to know if i can use connection string and query the DB or calling procedures in DB ???

I need any tutorials or step by step article that describe how to connect to DB without wizard and call procedures and query tables.

Thanks in advance and i am a begineer in MVC

Answer 1

Yes you can (google ado.net for tutorials on ado.net), but it's not the MVC way. The MVC way is to use some sort of ORM (Object-relational mapping) such as NHibernate, Subsonic or Linq for SQL.

Answer 2

You can put your connection string in the config, just like you're used to.

You can call procedures the same way you would from any .Net application too. @svinto's advice about using an ORM is another way of doing things and is well worth looking at too. Many of the good examples for ASP.Net MVC use the ORM techniques.

If you don't want to go down that route, you might benefit from creating a seperate class library project that you reference from your MVC application. Your Class Library project can act as your data access layer (DAL) where you handle db calls, etc...

Your Controllers can then call your DAL and processing methods to populate entities for the Views.

Answer 3

Ahmy, I think the best advice to give would be before you start off developing using the MVC framework is to have a look into the principles behind the MVC pattern and domain driven design.

Specifically , have a look at repository patterns etc.

You can still add connection strings to your web.config in a block and access them as you would have done in a webforms project, after all Asp.net MVC is based on webforms. Its just likely that you wouldn't really want to do this if you're utilising MVC the way it was intended, its all about seperation of concerns.

www.asp.net has some great intro. examples worth watching.

Answer 4

how to connect to DB without wizard and call procedures and query tables.

To call a procedure (here it will return no result, just perform some action):

using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection .Open();
    using(SqlCommand command = connection.CreateCommand(nameofthestoredprocedure))
    {
      command.CommandType = CommandType.StoredProcedure;
      command.Parameters.AddWithValue("@someparameter", somevalue);
      maCommande.ExecuteNonQuery();
    }
}

Answer 5

I hesitate to respond to this, but EVERY video you have seen is likely using an OR/M to generate the Model and the DAL. The generated DAL will likely encapsulate your calls to the stored procedures that you're asking about.

The thing is -- and here's why you're not getting the answer you're looking for -- each OR/M is going to have a different method of retrieving data from and inserting data into the database. How you retrieve data from the DB using an OR/M is going to be different if you're using Entity Framework, Linq to SQL, SubSonic, NHibernate, or any other OR/M.

So, the question is to you. Are you using a OR/M? If so, which one? If not, then you will use the standard ADO.NET calls to retrieve and store data. This is also reflected in my comment to your original question.

Answer 6

Try downloading NerdDinner, or even better ... ContactManager iteration 1 (the tutorial directly answers your Q). Those should give you a good idea for how to handle database access. I wouldn't suggest looking at something like Oxite or MS StoreFront though, as these are a bit more complex.

To specifically answer your question: the connection string, like in ASP.NET, can go in your web.config or hard-coded in your application.