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

java - Toggle JDialog visibility on button press or lose focus -

-
java gurus, looking toggle jdialog's visibility when jbutton pressed or when jdialog loses focus i.e. when area of screen outside jdialog becomes active. lose focus working fine, it's handed windowfocuslistener can't functionality jbutton i.e. 1st click => jdialog visible, 2nd click => jdialog invisible, 3rd click => jdialog visible. i don't want go down route of making jdialog modal or counting clicks on button. any ideas of achieving above functionality in simple, clean way? import java.awt.color; import java.awt.dimension; import java.awt.flowlayout; import java.awt.point; import java.awt.event.actionevent; import java.awt.event.actionlistener; import java.awt.event.windowevent; import java.awt.event.windowfocuslistener; import javax.swing.*; public class testframeexample { public static void main(string s[]) { final jdialog dialog = new jdialog(); final jbutton button = new jbutton(); jframe frame = new jframe(...
Read more