Dynamic LINQ To Entities Queries Using WCF/WPF demo code

I have been working on an article for Codeproject for a while now, and I have just finished it. You can read more about this article at the codeproject link :Dynamic LINQ To Entities Queries Using WCF/WPF demo code

Those of you that have used LINQ to SQL may know that you can use variables and Func<T,TResult> against a LINQ DataContex, but may not realise that you can not serialise a Func<T,TResult> and that the “var” keyword is only method level scope.

This article talks about one possible approach of how to create dynamic queries against the LINQ to Entities framework, that are able to be sent across a WCF service domain boundary. The article uses a WPC Client that creates a dynamic query based on some reflection, which is then sent to a WCF service. The actual WCF service is hosted within a Windows service, and the WCF service will call the LINQ to Entities framework that in turn is setup to look at the SQL Server Northwind sample database.

I have gone through a fair ammount of extra WCF stuff/Windows service hosting in the article, so you may find some other information too.

Anyway hope its useful to someone.



  1. Hello,

    I had a brief read of your article on the CodeProject.com. It looks great and would like to read your source code as well. But somehow I can not use codeproject.com (I can’t post data to it for a year, which means I can neither login nor creating new accounts. I am trying to resolve the issue now)
    So I wonder if you could send your article as an attachment to the above e-mail address.

    I ask because I am working on a totally automated WPF relational database editor generator, based on my X-Script Generator, which reads an extended relational database schema and output the editor without further human intervention. It has much more “intelligence” build in compared to generic SQL database manager, since it contains specific database information. It was a successful attempt as far as I can see now. It in someways is a lot consistent code generation framework than those on the market, but it’s at its infancy now. It’s depend only on Linq to SQL at present, the approach in your article could widen it application scope…

    Thanks in advance.
    Shuqian Ying
    At CryptoGateway.Com


  2. Shuqian Ying

    Could you maybe, try and join codeproject.com with new email address, as its quite a big chunk to forward to you, with all the article text/images/source code, and I have email restrictions.

    So it may be better for you to get access to codeproject using a different email.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s