c# - Best way to read IDataReader for WebApi -

-

i have webapi action returns dynamic result based on sql query. using following function convert idatareader works fine, creates dictionary object each row. wondering if there better way that.

private ienumerable readresult(idatareader reader) {     var names = new string[reader.fieldcount];     var values = new object[reader.fieldcount];      (var = 0; < reader.fieldcount; i++)     {         names[i] = reader.getname(i);     }      while (reader.read())     {         reader.getvalues(values);          var record = names.todictionary(i => i, s => values[array.indexof(names, s)]);          yield return record;     } }

you can try approach (don't know how play webapi, still worth try):

var record = new expandoobject() idictionary<string, object>; foreach(var name in names)     record[name] = values[array.indexof(names, name)];  yield return record;

Comments

Post a Comment

Popular posts from this blog

mysql - FireDac error 314 - but DLLs are in program directory -

-
i getting when trying access mysql database : [firedac][phys][mysql]-314. cannot load vendor library [libmysql.dll or libmysqlld.dll] this did not happen (unchanged) code, however, have upgraded windows 10 , had reinstall delphi xe8, system configuration matter. in order try solve problem, copied both of files c:\windows\sysytem32. when did not seem work, copied them \win32\debug, generated .exe resides. i imagine doing rather stupid, can't see what. the proper solution place driver file (eg., libmysql.dll ) in application's folder, or place installation location in fddrivers.ini file: [mysql] vendor=<folder>\libmysql.dll (recent versions of documentation seem use vendorlib instead of vendor in ini file.) see rad studio documentation topics configuring drivers (firedac) , connect mysql server (firedac) more information.
Read more

c++ - Getting C2512 "no default constructor" for `ClassA` error on the first parentheses of constructor for `ClassB`? -

-
my situation follows. let there header file classdeclarations.h , have following classes declared: class classa; class classb; class classa { public: classa(int x); classa(double y); int returninteger(void) { return m_x; } double returndouble(void) { return m_y; } private: int m_x; double m_y; } class classb { public: classb(int x); int returninteger(void) { return m_x; } private: int m_x; classa m_instancea_1; } let there *.cpp file called classdefns.cpp , define methods of classes declared in classdeclarations.h : #include classdeclarations.h classa::classa(int x) : m_x(x) { } classa::classa(double y) : m_y(y) { } classb::classb(int x) : m_x(x) { // line build error occurs m_instancea_1 = classa(0); } note have commented line compiler says there error: error c2512: 'classa' : no appropriate default constructor avai...
Read more

java - How can I send the data from a imput type="file" to the controller? -

-
i have in ftl: <input type="file" id="doc6" name="documente"> in .js: var lx = $("#longx").val(); var ly = $("#laty").val(); var jud = $("#judetpunctlucru").val(); var doc6type = $("#doc6type").val(); var doc6 = $('doc6').val(); validatecoords: function (lx, ly, jud, doc6type, doc6) { var data = { lx: lx, ly: ly, jud: jud, doc6type: doc6type, doc6: doc6 }; var url = contextpath + '/validarecoord'; return getjsondata(url, data); } and in controller: @requestmapping(value = "/validarecoord", method = requestmethod.get, produces = mediatype.application_json_value) @responsebody public map<string, object> getvalidcoord(@requestparam("lx") string lx, @requestparam("ly...
Read more