Narrow down all that to a simple SELECT and then return either an ADO.Net record set or an EF entity.


>Hi everybody,
>
>I am wondering what is the best way of re-writing the following logic in VFP into C#:
>
>

>select 0
>      create cursor csrMatch (pass_no B(0), invoice_no B(0), date_time T, inv_bal Y, availbonus Y, cashoutbal Y)
>

>
>After that cursor is created, I get 10 rows from the SQL server. Then for each of these 10 rows the stored procedure is run and if one of the returned column is not 0 (the result of the procedure is a single row), the row is inserted into this cursor (row based on the first and second cursors).
>
>And finally we format that csrMatch into XML string and return back.
>
>So, my first question is how to simulate creating a cursor and inserting rows into it in C# and my second question (assuming I need to use datatable for the first) is how to convert datatable into SqlReader (if one can be converted into another) as I have methods what produce XML based on passed SqlReader.
>
>Thanks in advance.