Stored Procedure in Linq in asp.net

MyLinqDataClassesDataContext mylinq = new MyLinqDataClassesDataContext();

var pwd=mylinq.StoredProcedurename(txt_getpassword.Text);

        //GridView1.DataSource = pwd;

        //GridView1.DataBind();

        foreach (var pw in pwd)

        {

            Label1.Text = pw.password_db.ToString();

        }

update query in linq in asp.net

MyLinqDataClassesDataContext mylinq = new MyLinqDataClassesDataContext();

var user =( from u in mylinq.userCredentials

                   where u.uname_db.Contains(TextBox1.Text)

                    select u).SingleOrDefault();

        user.password_db = TextBox2.Text;

        mylinq.SubmitChanges();

Delete Query in Linq in asp.net

MyLinqDataClassesDataContext mylinq = new MyLinqDataClassesDataContext();

var deleteuser = from p in mylinq.userCredentials

                         where p.uname_db.Contains(TextBox3.Text)

                         select p;

    mylinq.userCredentials.DeleteAllOnSubmit(deleteuser);

    mylinq.SubmitChanges();

Insert Query in Linq in asp.net

protected void btn_insert_Click(object sender, EventArgs e)

    {

        var userInsert = new userCredential()

        {

            uname_db = TextBox1.Text,

            password_db = TextBox2.Text

        };

        mylinq.userCredentials.InsertOnSubmit(userInsert);

        mylinq.SubmitChanges(); 

    }

Use Linq In Global.asax in asp.net

<%@ Application Language="C#" %>

<%@ Import Namespace="System.Xml.Linq" %>

<%@ Import Namespace="System.Linq" %>

<script runat="server">

    void Session_End(object sender, EventArgs e)

    {

        MyLinqDataClassesDataContext mylinq = new MyLinqDataClassesDataContext(); 

        if (Session["uname"] != null)

        {

        var deleteuser = from p in mylinq.userCredentials

                         where p.uname_db.Contains(Session["uname"].ToString())

                         select p;           

            mylinq.userCredentials.DeleteAllOnSubmit(deleteuser);

            mylinq.SubmitChanges();

        }

    }

</script>

How do you find the Second highest Salary?

How do you find the Second highest Salary?
This is the most common question asked in Interviews.
EMPLOYEE table has fields EMP_ID and SALARY how do you find the second highest salary?
Answer:
We can write a sub-query to achieve the result
SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN (SELECT MAX(SALARY) FROM EMPLOYEE)