Advanced Data Query and Databinding
I have the following situation. I have two data sources of different types that I need to join.
The first data source is a direct database query, I'd like to use Linq for. Each row has a DocId column.
The other data source is an array of Document objects that is returned from a web service call. Each Document has an array of properties. Each property is a key-value pair.
I want to join the first datasource's DocId column on each Document object's property with a key of DocId. I then want to bind a datagrid to the resulting data source.
One, can I even do this? Can I combine LinqToObjects with LinqToSQL like this? Must I convert my Document objects from having an array of key-value propeties to having named properties, especially since I need to bind the resulting data to a datagrid?
<Property name="DocId" value="1001" />