I've been reading loads but can't figure out how to apply it to my scenario. I would like to be able to have a SQL File/server, SQLite or SQL Server and have that on the server for Silverlight to connect to and perform certain queries as more than user will be using the program.
I already have a Project built with Expression Blend, but I don't know how to set up the Web Service for either locating the SQLite file or pointing to the server. Can anyone provide a simply step by step to how I would be able to gain access to the server side with Silverlight?
Quite simply, you cannot connect directly to a database through Silverlight; you can only connect back to the web server that served up the Silverlight application and then that server can connect to your database and return the results.
In order to do this, you would use either WCF or RIA in order to connect back to the server and then ultimately to your database.