How to write mock unit test case for ExecuteNonQuery & ExecuteScalar & GetDataSet method

I am writing a unit test case for my application.In my application, I am using SQLite datebase.I want to mock following methods.Like,ExecuteNonQuery, ExecuteScalar, GetDataSet.I am writing my methods below.

Please, any one help me to write mock unit test case for following method.

ExecuteNonQuery

using (SQLiteConnection objCon = objISQLite.OpenConnection(DBNAME))
{
     objCon.Open();
     using (SQLiteCommand objCmd = new SQLiteCommand(strSQL, objCon))
     {
           intRetValue = objCmd.ExecuteNonQuery();
           objCmd.Dispose();
     }
     objCon.Close();
     objCon.Dispose();
}

ExecuteScalar

using (SQLiteConnection objCon = OpenConnection(DBNAME))
{
      objCon.Open();
      using (SQLiteCommand objCmd = new SQLiteCommand(strSQL, objCon))
      {
            objRetValue = objCmd.ExecuteScalar();
            objCmd.Dispose();
      }
      objCon.Close();
      objCon.Dispose();
}

GetDataSet

using (DataSet dsData = new DataSet())
{
      using (SQLiteConnection objCon = OpenConnection(DBNAME))
      {
           objCon.Open();
           using (SQLiteDataAdapter objAdp = new SQLiteDataAdapter(strSQL,objCon))
                 {
                       dsData.Reset();
                       objAdp.Fill(dsData);
                       objAdp.Dispose();
                 }
                 objCon.Close();
                 objCon.Dispose();
      }
      return (#Dataset);
}