Asp.net MVC3 Database connectivity without using Enity Framework,Linq To Sql

In that case, use straight ADO.NET code. Here is some sample code that we sometimes use to read and write data in a SQL database:

public static System.Data.DataTable ReadData(string connectionString, string sqlQuery, Dictionary<string,> parameters = null)
{
    DataTable myTable = new DataTable();
    using (SqlConnection cnn = new SqlConnection(connectionString))
    {
        cnn.Open();

        using (SqlCommand myCommand = new SqlCommand())
        {
            SqlParameter param;
            myCommand.CommandText = sqlQuery;

            //Loops through each parameter in the dictionary
            //and adds it to the parameters list
            if (parameters != null)
            {
                foreach (var entry in parameters)
                {
                    param = new SqlParameter();
                    param.ParameterName = entry.Key;
                    param.Value = entry.Value;
                    myCommand.Parameters.Add(param);
                }
            }

            myCommand.Connection = cnn;

            using (SqlDataReader reader = myCommand.ExecuteReader())
            {
                myTable.Load(reader);
            }
        }
    }
    return myTable;
}

public static int WriteData(string connectionString, string sqlQuery, Dictionary<string,> parameters = null)
{
    using (SqlConnection cnn = new SqlConnection(connectionString))
    {
        cnn.Open();

        using (SqlCommand myCommand = new SqlCommand())
        {
            SqlParameter param;
            myCommand.CommandText = sqlQuery;

            //Loops through each parameter in the dictionary
            //and adds it to the parameters list
            if (parameters != null)
            {
                foreach (var entry in parameters)
                {
                    param = new SqlParameter();
                    param.ParameterName = entry.Key;
                    param.Value = entry.Value;
                    myCommand.Parameters.Add(param);
                }
            }

            myCommand.Connection = cnn;

            return myCommand.ExecuteNonQuery();
        }
    }

}

To use this, just pass in the connection string, the SQL query, and a Dictionary list of parameters. Adding a parameter to the Dictionary would look like this:

parameters.Add("@UserID", "14");