Click here to Skip to main content
15,887,676 members
Home / Discussions / C#
   

C#

 
GeneralRe: Removing the cross from a form Pin
Stefan Troschuetz22-Sep-04 3:40
Stefan Troschuetz22-Sep-04 3:40 
GeneralRe: Removing the cross from a form Pin
exhaulted22-Sep-04 4:06
exhaulted22-Sep-04 4:06 
GeneralRe: Removing the cross from a form Pin
Stefan Troschuetz22-Sep-04 4:35
Stefan Troschuetz22-Sep-04 4:35 
GeneralRe: Removing the cross from a form Pin
exhaulted22-Sep-04 4:48
exhaulted22-Sep-04 4:48 
GeneralRe: Removing the cross from a form Pin
Stefan Troschuetz22-Sep-04 4:59
Stefan Troschuetz22-Sep-04 4:59 
AnswerRe: Removing the cross from a form Pin
walterhuang29-May-06 20:42
walterhuang29-May-06 20:42 
QuestionBest Practice - Webservice, Stored Procedure, both? Pin
KoalaCowboy21-Sep-04 3:32
KoalaCowboy21-Sep-04 3:32 
AnswerRe: Best Practice - Webservice, Stored Procedure, both? Pin
Heath Stewart21-Sep-04 6:52
protectorHeath Stewart21-Sep-04 6:52 
An XML Web Service is in no relation to stored procedures. They do entirely different things and can be used together or apart.

A stored procedure is simply a procedure implemented in a Relational Database Management System (RDBMS). It gives you flexibility of separating logic from data (the stored procs and data could even exist on separate RDBMSs) and implementing complex procedures that would otherwise be problematic in code (coding SQL commands in your code makes your compilations less robust).

XML Web Services describe a standard whereby a common format (SOAP, an XML "grammar", or schema) is sent over HTTP or HTTPS. An XML Web Service that queries data could use stored procs to read/write data, or something not even related to data.

The question you have to ask yourself is about architecture first. Do you need to go across disparate networks (like a WAN)? Do you need to support many different types of clients (written in, perhaps, many different languages and on different platforms)? If yes to either, then Web Services might be your answer. That still doesn't rule out stored procedures, though.

Regarding stored procedures, do you want to support complex queries? Do you want to maintain robust code? If yes to either of those, then using stored procs is probably your best bet (and I honestly can't think of too many reasons for not using stored procs if even one of your queries is just more than a simple, single SQL command).

With regard to security, it is different questions you must ask yourself. If you do use XML Web Services and need to protect data across the wire, then you should use HTTPS instead of HTTP (HTTPS is HTTP over SSL, an encryption algorithm). You could also use WS-Security standards that you can read about on http://msdn.microsoft.com/webservices/building/wse/[^], as well as download the Web Service Enhancements from Microsoft which impements these common standards (please note that while Microsoft is a major player in defining these standards, there is a consortium of vendors like IBM and others. The WSE is just Microsoft's implementation of WS standards, just like .NET is Microsoft's implementation of the Common Language Infrastructure, or CLI).

If you're using stored procedures, you should use role-based authentication and authorization in the RDBMS. SQL Server supports this, as well as others. Don't just accept the default authorization and permissions.

There's so much more when dealing with security and robust code. If you need information on either subject, I recommend reading some of the many great and FREE online books (you can also order print editions) at http://msdn.microsoft.com/patterns[^].

This posting is provided "AS IS" with no warranties, and confers no rights.

Software Design Engineer
Developer Division Sustained Engineering
Microsoft

[My Articles]
GeneralRe: Best Practice - Webservice, Stored Procedure, both? Pin
KoalaCowboy21-Sep-04 8:29
KoalaCowboy21-Sep-04 8:29 
GeneralRe: Best Practice - Webservice, Stored Procedure, both? Pin
Heath Stewart21-Sep-04 10:52
protectorHeath Stewart21-Sep-04 10:52 
GeneralRe: Best Practice - Webservice, Stored Procedure, both? Pin
KoalaCowboy21-Sep-04 10:56
KoalaCowboy21-Sep-04 10:56 
GeneralInsert a frequency time delay into a ThreadPool Pin
Fahad sarwar21-Sep-04 2:50
Fahad sarwar21-Sep-04 2:50 
Generalcatching control.name change Pin
ShakerWD20-Sep-04 23:55
ShakerWD20-Sep-04 23:55 
GeneralRe: catching control.name change Pin
sreejith ss nair21-Sep-04 0:20
sreejith ss nair21-Sep-04 0:20 
GeneralRe: catching control.name change Pin
ShakerWD21-Sep-04 1:26
ShakerWD21-Sep-04 1:26 
GeneralRe: catching control.name change Pin
ShakerWD21-Sep-04 9:11
ShakerWD21-Sep-04 9:11 
GeneralRe: catching control.name change Pin
Dave Kreskowiak21-Sep-04 9:44
mveDave Kreskowiak21-Sep-04 9:44 
GeneralRe: catching control.name change Pin
ShakerWD21-Sep-04 9:55
ShakerWD21-Sep-04 9:55 
Generalchanging RowState of DataRow Pin
TehMedic20-Sep-04 23:31
TehMedic20-Sep-04 23:31 
GeneralRe: changing RowState of DataRow Pin
Sendilkumar.M21-Sep-04 0:24
Sendilkumar.M21-Sep-04 0:24 
GeneralRe: changing RowState of DataRow Pin
sreejith ss nair21-Sep-04 0:27
sreejith ss nair21-Sep-04 0:27 
QuestionHELP ME!!! How to design a new control? Pin
bekun20-Sep-04 23:31
sussbekun20-Sep-04 23:31 
AnswerRe: HELP ME!!! How to design a new control? Pin
Kodanda Pani20-Sep-04 23:49
Kodanda Pani20-Sep-04 23:49 
GeneralRe: HELP ME!!! How to design a new control? Pin
bekunkun21-Sep-04 0:17
bekunkun21-Sep-04 0:17 
GeneralRe: HELP ME!!! How to design a new control? Pin
sreejith ss nair21-Sep-04 0:22
sreejith ss nair21-Sep-04 0:22 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.