ADO.NET Data Services: CLR-based data models and navigation links

Pregnant Man » ADO.NET Data Services: CLR-based data models and navigation links

Sun, 20 Jul 2008 05:24:21 GMT

PingBack from http://wordnew.acne-reveiw.info/?p=11018

re: ADO.NET Data Services: CLR-based data models and navigation links

Koen — Tue, 30 Sep 2008 13:19:21 GMT

That's nice.

But..

Where would you make possible database calls to fill s_libraries and s_books?

You could do this in the constructor, but that would lead to the fact that all data would be retrieved on every request. Not good.

Ideally, you'd to this in the get for Books, for instance:

public IQueryable<Book> Books

{

get

{

using(DataSource dataSource = new DataSource)

{

return dataSource.Books.AsQueryable();

}

But that leads to an exception:

The ObjectContext instance has been disposed and can no longer be used for operations that require a connection.

Any thoughts appreciated.

koen

re: ADO.NET Data Services: CLR-based data models and navigation links

Raag — Fri, 31 Oct 2008 09:55:17 GMT

hi,

I have created some of the SP and function in .net....i can depoly this to SQL CLr using deply menu in VS2005 or i can use create assembly method to add the dll into SQL CLr....

but i want to send this to client....is there any MSI i can build so the client can run the same as exe...

Regards

Raag

re: ADO.NET Data Services: CLR-based data models and navigation links

Andy Brummer — Mon, 26 Jan 2009 00:28:42 GMT

Thanks for the info. Your post cleared up the data model used to shoehorn non-entity objects into data services. All their examples had it, but none of the samples explicitly stated that every object has to be part of these root collections.