Is it possible to access Datasource without using WCF in SilverLight 2 app

Question

0.00/5 (No votes)

See more:

Hi,

i have planning to learn Microsoft SilverLight.During that time i got an question that without using WCF service cannot we access database or is it possible with ADO.NET.
Please reply with an example.And one more thing that suggest me any good material to learn silverlight quickly.

Posted 10-Nov-11 18:49pm

ks ravi

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Uday P.Singh · Answer 1 · 2011-11-10T18:56:00

Solution 1

No,we cannot call ADO.NET code directly from a Silverlight application because Silverlight does not consist of ADO.net. But Silverlight does have WCF, hence we can create a WCF service which does database operations and Silverlight application will make calls to the same.

Read this article:

7 Simple Steps to Connect SQL Server using WCF from SilverLight[^]

hope it helps :)

Posted 10-Nov-11 18:56pm

Uday P.Singh

Updated 10-Nov-11 19:49pm

v2

Comments

ks ravi 11-Nov-11 1:55am

thanks for your reply.Please suggest any good material to learn SilverLight quickly.

Uday P.Singh 11-Nov-11 2:26am

what do you mean by quickly? To learn anything from scratch will definitely take time initially be patience. Google is your friend try to find articles, e-books etc. You can accept the answer if it helped you.

Mark Salsbery 11-Nov-11 11:10am

Also you don't HAVE to use WCF. You can use any communication provided by Silverlight. WCF definitely saves you some work though. RIA services can save you even more (http://msdn.microsoft.com/en-us/library/ee707344%28v=VS.91%29.aspx). The Silverlight Business Application project template is a good place to start...

Uday P.Singh 11-Nov-11 13:53pm

Yes but certainly can't use ADO.net directly to interact with data source.

Mark Salsbery 14-Nov-11 10:42am

WCF and database access have nothing at all to do with each other, nor did I imply they did.

sasolanki007 · Answer 2 · 2011-11-14T01:43:00

Solution 2

No you can't access database in silverlight directly.

You can do it by WCF Services or WCF RIA Services.

Check out Silverlight Samples[^]

Regards,
Sagar Solanki

Posted 14-Nov-11 1:43am

sasolanki007

Pandya Anil · Answer 3 · 2011-11-14T01:54:00

You can not use any ADO.NET classes (infact they are not included in sl) inside silverlight (sl), because the silverlight is in user's browser, and your ADO.NET can be in your server...

silverlight application is a Rich Intenet Application (RIA), means it has rich set of user interaction tools inside the browser, whatever happens can only happen in browser... or it call make call to services i.e. ASP.NET webservice, WCF services, RIA services.. etc...

its a good place to learn silverlight/wpf...

go through it. :)

http://www.wpftutorial.net/[^].

if satisfied mark as answer.. for more clarifications comment below :)