[eclipsed4utoo]

Personally, I think the RIA services tutorials aren't very good at explaining what is going on. I just use a normal WCF service to read from a database. I can do a quick tutorial.

[eclipsed4utoo]

I submitted a tutorial.

http://www.dreaminco...e-database-wcf/

The link may not work until the tutorial is approved.

[eclipsed4utoo]

megan111, on 12 May 2010 - 05:57 AM, said:

sorry, it is not clear where the event handler main page loaded goes?

sorry. It goes into the "MainPage.xaml.cs" file.

namespace SilverlightWCFTutorial
{
    public partial class MainPage : UserControl
    {
        public MainPage()
        {
            InitializeComponent();

            this.Loaded += new RoutedEventHandler(MainPage_Loaded);
        }

        void MainPage_Loaded(object sender, RoutedEventArgs e)
        {
            // The DatabaseServiceClient class was automatically created for us.
            // The autogeneration takes the name of the service, then appends "Client" to it,
            //   giving us the "DatabaseServiceClient" class.
            DatabaseServiceClient client = new DatabaseServiceClient();

            // Since requests in Silverlight are asynchronous, we have a Completed method
            //   that will be fired when the request has been completed.
            client.GetNamesCompleted += delegate(object s, GetNamesCompletedEventArgs es)
            {
                // when the request has been completed, we want to bind the data to the grid.
                // the Result property of the EventArgs contains the returned data.
                // ObservableCollection is a common collection that is used when databinding to
                //    a DataGrid.
                ObservableCollection<string> myList = es.Result;

                dataGridPerson.DataContext = myList;
            };

            client.GetNamesAsync();
        }
    }
}

megan_111, on 12 May 2010 - 06:12 AM, said:

I have followed all your steps and have the same filenames, but I get an error for 'DatabaseServiceClient'

Error

Error	1	The type or namespace name 'DatabaseServiceClient' could not be found (are you missing a using directive or an assembly reference?)

Is there anything I could be missing?

Did you name everything the same as I did? The "Client" class is autogenerated using the name of the service. So if you named the service "SomeOtherName.svc", then your "client" class name would be "SomeOtherNameClient".

[eclipsed4utoo]

you can make calls to as many databases as you want from a service. you do not have to have a separate service for each database.

[eclipsed4utoo]

megan_111, on 13 May 2010 - 06:20 AM, said:

I tried to do that earlier with the one service and two client objects (one to call each method for the database) but I got errors until I created a separate service/client.

At the moment I am trying to figure out how to pass a parameter through to the service. Thanks for all your help so far

I haven't tested it, but I assumed it would work fine. Maybe it doesn't. I will try it out.

To pass a parameter, you need to change the service method to accept a parameter, then your client class will show that you need to pass the parameter.