asp.net - Handle Oracle Database Connection in Dapper -

i trying connect oracle database , trying execute query.

so below model class

using system; using system.collections.generic; using system.linq; using system.web; using system.componentmodel.dataannotations.schema; using system.componentmodel.dataannotations;  namespace testapi.models { public class testapimodel {     [key]     public int prio_category_id { get; set; }     public int lang_id { get; set; }     public system.datetime rec_date { get; set; }     public int rec_user { get; set; }     public nullable<int> rfch_id { get; set; }     public string descr { get; set; }     public string col_descr { get; set; }     public string row_descr { get; set; }     public string abbr { get; set; } } } 

dbcontext class

using system; using system.collections.generic; using system.linq; using system.web; using system.data.entity;  namespace testapi.models { public class testapicontext: dbcontext {         public dbset<testapimodel> details { get; set; } } } 

now trying create controller dapper, issue in of forums trying connect sql database. trying access oracle db , return result in json format .so if give

using oracle.manageddataaccess.client; using system; using system.collections.generic; using system.linq; using system.net; using system.net.http; using system.web.http; using newtonsoft.json; using system.web.http.description; using testapi.models; using dapper;  namespace testapi.controllers  {   public class testapimodelscontroller : apicontroller    {      // get: api/testapimodels     public iqueryable<testapimodel> getdetails(int id)     {       oracleconnection dbconn = new oracleconnection("data source=ax;password=cm;persist security info=true;user id=ab");       dbconn.open();       var strquery = @"select prio_category_id prio,lang_id lang, rec_date rec, rec_user recuser, descr,col_descr col,row_descr drow,abbr stcd_prio_category_descr rec_user =  " +id;       retrun dbconn.query<testapimodel>();       dbconn.close();   }  } } 

it throws error saying dbconn.query not in context , tried testapicontext.init throws error. can please suggest me how deal oracle connection dapper. new asp.net , creating services. kind of stuck, appreciated.

you not passing sql. also, explicit close not needed. can wrap code in using under hood sqlconnection.dispose() calls sqlconnection.close().

perhaps typo, "retrun" should "return". connectionstring should read app.config vs. hard coded , i'd consider making 'id' parameter.

using (var dbconn = new oracleconnection("data source=ax;password=cm;persist security info=true;user id=ab");) {       dbconn.open();       var strquery = @"select prio_category_id prio,lang_id lang, rec_date rec, rec_user recuser, descr,col_descr col,row_descr drow,abbr stcd_prio_category_descr rec_user = " +id;       return dbconn.query<testapimodel>(strquery); }