ASP.Net MVC - how can I easily serialize query results to a database?
        Posted  
        
            by Mortanis
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Mortanis
        
        
        
        Published on 2010-04-01T03:13:28Z
        Indexed on 
            2010/04/01
            3:23 UTC
        
        
        Read the original article
        Hit count: 276
        
I've been working on a little property search engine while I learn ASP.Net MVC. I've gotten the results from various property database tables and sorted them into a master generic property response. The search form is passed via Model Binding and works great.
Now, I'd like to add pagination. I'm returning the chunk of properties for the current page with .Skip() and .Take(), and that's working great. I have a SearchResults model that has the paged result set and various other data like nextPage and prevPage.
Except, I no longer have the original form of course to pass to /Results/2. Previously I'd have just hidden a copy of the form and done a POST each time, but it seems inelegant. I'd like to serialize the results to my MS SQL database and return a unique key for that results set - this also helps with a "Send this query to a friend!" link. Killing two birds with one stone.
Is there an easy way to take an IQueryable result set that I have, serialize it, stick it into the DB, return a unique key and then reverse the process with said key? I'm using Linq to SQL currently on a MS SQL Express install, though in production it'll be on MS SQL 2008.
© Stack Overflow or respective owner