i need to connect database connection in MVC

You can connect to the database using the Entityframework also and specifying the connection strings in the Web.config.

<connectionStrings>
    <!-- Database ConnectionString -->
    <add name="Context Name" connectionString="data source=(LOCAL);initial catalog=DATABASE NAME;integrated security=False;MultipleActiveResultSets=True;user id=**;Password=**;" providerName="System.Data.SqlClient" />
    <!-- Database EntityFramework ConnectionString -->
</connectionStrings>

The Username and Password should only be given if DB is accessed through SQL authentication.

Thanks
Hope this helps

Yes, You can do it. Simple define connection string in web.config file and then Access using

ConfigurationManger

.

<connectionstrings>
<add name="DevelopmentConnectionString">
connectionString="Data Source=sandeepss-PC;Initial Catalog=Development;User ID=sa;
Password=*******" providerName="System.Data.SqlClient" />


Now string pass in your

SqlConnection

after that all is same as you do in asp.NET with ADO.NET object.

If your are working with Linq in MVC application then it can be helpful.

http://www.codeproject.com/Articles/720471/A-Simple-MVC-Application-using-LINQ-to-SQL

try this..http://docs.oracle.com/javase/tutorial/jdbc/basics/sqldatasources.html[^][^]