xml from sql trhough to Javascript

Question

First, I am completely new to Visual Studio and am overwhelmed by volume of options available.  I am probably jumping into the deep end, but I have been trying to work out how I can read data from a SQL database via a LINQ query through an AJAX enabled WCF service, convert to XML and return to Javascript.

I think that my problem is within the WCF service.  So far as I can tell the other aspects of the routine seem to work.

The database table is about as simple as it is possible to get, having only 3 columns, a numeric Id I don't need to search and two text fields.

Finally, rightly or wrongly I have created a Full Text index on the table.

Would someone be kind enough to help a complete beginner and point him in the right direction?  Any help would be very gratefully received.

Many thanks

Patrick

Answer 1

Hi, You can use JSON result for the same.