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

wpf - C# NAudio - Changing audio playback position still plays a small buffer of old position -

-
i trying make basic mp3 player in c# , wpf, along naudio. added slider tracks current position in song allows drag different position , upon thumb.dragcompleted set song's position dragged it. this works fine , all, except when make jump new position, still plays old position 1/5th or of second before changing. noticeable e.g. while singer in middle of singing "aaa", pause, drag point sings "ooo", play again, hear "aa-ooo". results in sounding pretty horrible. so suppose audio playback has small 'buffer' remaining insists on playing before moving on. there way clear buffer? or setting position wrong? i using waveout waveoutdevice , audiofilereader audiofilereader . slider called sldrplaybackprogress . tried change position in song in 2 different ways already: first method: audiofilereader.currenttime = new timespan(0, (int)(math.floor(sldrplaybackprogress.value / 60)), (int)(math.floor(sldrplaybackprogress.value % 60))); sec...
Read more

Log not being recorded for quickfix c++ Session -

-
i running fix initiator , succesfully connecting acceptor. problem is, no log being recorded. .cfg application written below. [default] connectiontype=initiator reconnectinterval=2 resetonlogon=y filestorepath=store filelogpath=logging starttime=00:00:00 endtime=00:00:00 usedatadictionary=y # standard config elements [session] # inherit connectiontype, reconnectinterval , sendercompid default beginstring=fix.4.4 sendercompid=init targetcompid=accept socketconnecthost=xxx socketconnectport=xxx heartbtint=30 datadictionary=fix44md.xml [session] beginstring=fix.4.4 sendercompid=init targetcompid=accept1 socketconnecthost=xxx socketconnectport=xxx heartbtint=30 datadictionary=fix44oms.xml the excerpt code initiates connection written below: std::string file = argv[ 1 ]; fix::sessionsettings settings( file ); application application; fix::filestorefactory storefactory( settings ); fix::screenlogfactory logfactory( settings ); fix::socketinitiator initi...
Read more