I have a silverlight project within my solution that has 2 xaml files.

There is also a service reference to an .svc in my website.

My service has one function:

  string con = ConfigurationManager.ConnectionStrings["conn"].ToString();
     
        SilverlightDataDataContext db = new SilverlightDataDataContext(con);
        var mTemplates = from MediaTemplate in db.MediaTemplates where MediaTemplate.webId == webId select MediaTemplate;
        
        return mTemplates.ToList();

this is called from the xaml.cs file.

When the dbml file has one table, all works fine and the data is bought back to the silverlight.

If we add another table, be it to the existing dbml or completely recreate another dbml it doesn't work.

I can debug thru the web service and it appears to work, but it never gets back to the silverlight, it throws a time out error.

If you delete the second table it works again.

What on earth is going on? has anyone experienced anything like this?

Thanks

Bex

Do the tables by any chance have a relationship between them?

Hi Bexm,

As RickNZ suggested, is there any problem with the second table? It seems strange that it doesn't work if you just add the second table. My suggestion is similar with RickNZ's, which is to check whether there's any relationship in second table first. Then you could add a new fresh table for test. If it still doesn't work, please show us the exact error message.

Thanks.