问3种类型的询问SQL (没有映射器，类型为linq或nhibernate)

EN

OdbcConnection cn;
OdbcCommand cmd;
string MyString;

MyString="Select ...";
cn= new OdbcConnection("Driver={SQL Server};Server=...;UID=...;PWD=...;Database=...;");
cn.Open();
cmd=new OdbcCommand(MyString,cn);
OdbcDataReader reader = cmd.ExecuteReader();

while (reader.Read())
{
    ....
}

reader.Close();
cn.Close();

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["…"].ConnectionString);           
SqlDataReader rdr = null;

SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "SELECT ..."

cmd.CommandType = CommandType.Text;
conn.Open();
rdr = cmd.ExecuteReader();              

while (rdr.Read())
{
   .....
}
rdr.Close();
conn.Close();

Database context = DatabaseFactory.CreateDatabase("..."); 
IDataReader dataReader = context.ExecuteReader(CommandType.Text,"SELECT ...")

dataReader.Read();
var inputid = (int)dataReader["..."];