WCF Typed DadaTable with additional columns

Aug 19 2010 2:40 AM

Hello.

I have a problem with seialization strongly typed DataTable with additional columns (this columns comes from join operation in sql statemnts).

Eg. my strongly typed DataTable has columns: FirstName, SecondName, AdresId. So i want to display in my application (gridview) also infromation about address so the query is:

"select c.*, a.PostalCode,a.City  from customers as c inner join address as a

on a.adresId = c.adresId";

The problem is that before serialization my DataTable has additional columns (PostalCod,City  ), after serialization DataTable has only standard Columns without PostalCode and City.

Please help, how to send trought wcf such hybrid datatable?


Answers (1)