.Net application call a stored procedure directly or should a .Netapplication call a web service, or is WCF better

[Nexstar]

What is the fastest way to access the database for performance point
of view? Should a .Net application call a stored procedure directly or
should a .Net application call a web service, or use WCF, or is there
another way?

[John Saunders [MVP]]

Re: .Net application call a stored procedure directly or should a .Net application call a web service, or is WCF better

"Nexstar" <brettreed651@y ahoo.comwrote in message
news:fe101b4c-b536-429d-aafc-df2b151992ca@i1 2g2000prf.googl egroups.com...

What is the fastest way to access the database for performance point
of view? Should a .Net application call a stored procedure directly or
should a .Net application call a web service, or use WCF, or is there
another way?

"It depends"? There's not going to be a single answer for this.

Of course, it makes sense that less overhead is better. But what "makes
sense" is not always true.
--
--------------------------------------------------------------------------------
John Saunders | MVP - Windows Server System - Connected System Developer

[Eric]

Re: .Net application call a stored procedure directly or should a.Net application call a web service, or is WCF better

On Feb 19, 10:40 pm, Nexstar <brettreed...@y ahoo.comwrote:

What is the fastest way to access the database for performance point
of view? Should a .Net application call a stored procedure directly or
should a .Net application call a web service, or use WCF, or is there
another way?

I vote for a direct call being the fastest. Any of the other solutions
you mentioned would add more baggage.

Eric