none
Pulling data from Memory instead of SQL RRS feed

  • Question

  • Hi,
    I have written a program that write data from an class instance into a remote SQL database. I also have a place in my app where the user can get detailed reports from the data that was inserted by this application. The customer now want the capability for the app to get the report even when the database is not available.  One way to provide this functionality is to write the data to a local database, how do i do this with LinQ without a local database? Can i put some properties around the class that contains the data to make it known to the LINQ engine? I have used LINQ to do simple things but i am still very new to LINQ. Can anyone help with this?
    thanks,
    ilikecoding
    Monday, August 31, 2009 9:44 PM

Answers

  • Sounds like LINQ to DataSet could be a good candidate for this.
    I will have to load the dataset once, but then you can store it in memory (or on disk) until you are ready to update the database.
    You do not need a localdatabase and you can query the DataSet via LINQ.

    .NET Framework Developer's Guide - LINQ to DataSet
    http://msdn.microsoft.com/en-us/library/bb386977.aspx

    HTH
    //Michael
    This posting is provided "AS IS" with no warranties.
    Tuesday, September 1, 2009 7:40 AM