Solved

Set DataReader From Cache

Posted on 2010-11-09
2
371 Views
Last Modified: 2012-05-10
I'm working with a third party tool that needs to be provided with an instance of IDataReader for a specific call.  THis has been working fine, but now I have a situation where the data I need to pass to the method is not coming from a database, but is effectively cached in the application.  So I have a List of Dictionary<string, Object> items that needs to be put into a DataReader.

Is there any way to do this?  Can I somehow point a Connection.DataSource to a C# object, maybe a DataTable?

jkavx
0
Comment
Question by:jkavx
2 Comments
 
LVL 13

Accepted Solution

by:
AngryBinary earned 500 total points
ID: 34098438
Can you load the data in your Dictionary to a DataTable? The DataTable object has a "CreateDataReader()" method that returns an IDataReader for the rows in that table.

Otherwise, you can implement the IDataReader interface in a new class that feeds data from a Dictionary object.
0
 

Author Closing Comment

by:jkavx
ID: 34098490
CreateDataReader() is what I was looking for.  Thx.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now