By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,663 Members | 1,337 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,663 IT Pros & Developers. It's quick & easy.

Sending query to a database using WPF Browser Application

P: n/a
Hi everyone,
As far as I know, you cannot connect directly to a SQL Server database
from a web browser application because of the security restrictions.
Is there any other way to connect to a SQL Server database through a
WPF Browser Application? (All I need is something that will let me
connect and send queries to a database)
Please help,
Ofir
Sep 6 '08 #1
Share this Question
Share on Google+
5 Replies


P: n/a

"ofiras" <of****@gmail.comwrote in message
news:fa**********************************@x41g2000 hsb.googlegroups.com...
Hi everyone,
As far as I know, you cannot connect directly to a SQL Server database
from a web browser application because of the security restrictions.
Is there any other way to connect to a SQL Server database through a
WPF Browser Application? (All I need is something that will let me
connect and send queries to a database)
I assume that the database here is server-side. In this case, you can build
a web service layer on top of it, encapsulating all the queries you need,
either manually via WCF, or just use ADO.NET Entity Framework + ADO.NET Data
Services to automate it.
Sep 6 '08 #2

P: n/a
On 6 ספטמבר, 10:21, "Pavel Minaev" <int...@gmail.comwrote:
"ofiras" <ofi...@gmail.comwrote in message

news:fa**********************************@x41g2000 hsb.googlegroups.com...
Hi everyone,
As far as I know, you cannot connect directly to a SQL Server database
from a web browser application because of the security restrictions.
Is there any other way to connect to a SQL Server database through a
WPF Browser Application? (All I need is something that will let me
connect and send queries to a database)

I assume that the database here is server-side. In this case, you can build
a web service layer on top of it, encapsulating all the queries you need,
either manually via WCF, or just use ADO.NET Entity Framework + ADO.NET Data
Services to automate it.
Is sending "post" to a .php web page (like when I have a form that I
send data using "post" method) easier? That way I can make a .php file
that will get the posted data and send the query I want. I tried it
but it didn't work too because of the security restrictions...
Please help,
Ofir.
Sep 6 '08 #3

P: n/a
"ofiras" <of****@gmail.comwrote in message
news:30**********************************@k13g2000 hse.googlegroups.com...
On 6 ??????, 10:21, "Pavel Minaev" <int...@gmail.comwrote:
Hi everyone,
As far as I know, you cannot connect directly to a SQL Server database
from a web browser application because of the security restrictions.
Is there any other way to connect to a SQL Server database through a
WPF Browser Application? (All I need is something that will let me
connect and send queries to a database)

I assume that the database here is server-side. In this case, you can
build
a web service layer on top of it, encapsulating all the queries you need,
either manually via WCF, or just use ADO.NET Entity Framework + ADO.NET
Data
Services to automate it.
Is sending "post" to a .php web page (like when I have a form that I
send data using "post" method) easier?
I don't think so. Why bring PHP into equation
That way I can make a .php file that will get the posted data and send the
query I want.
I tried it but it didn't work too because of the security restrictions...
If you construct the query on the client, and just make the server accept
and execute any query that it receives, then you are opening a very wide
security hole. You need to encapsulate strictly the queries you need for
your client app on the server side.
Sep 6 '08 #4

P: n/a
On 6 ספטמבר, 15:54, "Pavel Minaev" <int...@gmail.comwrote:
"ofiras" <ofi...@gmail.comwrote in message

news:30**********************************@k13g2000 hse.googlegroups.com...
On 6 ??????, 10:21, "Pavel Minaev" <int...@gmail.comwrote:
Hi everyone,
As far as I know, you cannot connect directly to a SQL Server database
from a web browser application because of the security restrictions.
Is there any other way to connect to a SQL Server database through a
WPF Browser Application? (All I need is something that will let me
connect and send queries to a database)
I assume that the database here is server-side. In this case, you can
build
a web service layer on top of it, encapsulating all the queries you need,
either manually via WCF, or just use ADO.NET Entity Framework + ADO.NET
Data
Services to automate it.
Is sending "post" to a .php web page (like when I have a form that I
send data using "post" method) easier?

I don't think so. Why bring PHP into equation
That way I can make a .php file that will get the posted data and send the
query I want.
I tried it but it didn't work too because of the security restrictions....

If you construct the query on the client, and just make the server accept
and execute any query that it receives, then you are opening a very wide
security hole. You need to encapsulate strictly the queries you need for
your client app on the server side.
Ok... I see... so what is this ADO.NET Entity Framework an ADO.NET
Data Services? Is there a tutorial or article or something that
explains what is it and how to use it?
Please help,
Ofir.
Sep 7 '08 #5

P: n/a
On Sep 7, 6:21*pm, ofiras <ofi...@gmail.comwrote:
Ok... I see... so what is this ADO.NET Entity Framework an ADO.NET
Data Services? Is there a tutorial or article or something that
explains what is it and how to use it?
In the future, please use Google before asking such questions. Merely
searching for the titles of those technologies gives plenty of
relevant links on the top. Or just go to MSDN and search there.

http://msdn.microsoft.com/en-us/library/bb399572.aspx
http://msdn.microsoft.com/en-us/data/bb931106.aspx
Sep 18 '08 #6

This discussion thread is closed

Replies have been disabled for this discussion.