C# vs. ASP for web services?

[Guest]

I want to use .NET for writing web services that will mainly call SQL Server
(2000) stored procedures in a database. What are the
advantages/disadvantages of using C# vs. ASP and vice versa?

Also, if any one is familiar with ColdFusion MX, what are the
advantages/disadvantages of using .NET (one of the two languages above) to
write the same web service vs. using CFMX?

Thanks,
Brett

 

[Joyjit Mukherjee]

Hi,

I wonder how could you use ASP within the .NET environment to write web
services. The former is unmanaged code, while C# produces managed code, is
optimized, produces MSIL that is compiled to native code by the JIT
compiler, and executes under CLR. Moreover, C# takes advantage of .NET
Framework to use ADO .NET to connect to SQL Server 2K, which improves
performance.

Regards
Joyjit

 

[Eric Sabine]

If you just want to expose stored procedures as web services, you can skip
..net all together.

http://msdn.microsoft.com/msdnmag/issues/03/04/WebQA/default.aspx

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/html/anch_SQLXML.asp

hth,
Eric

 

[Joyjit Mukherjee]

Hi,

Sorry for my earlier post. You need the comparison of ASP.NET & C#, i
suppose.
See ASP.NET is a platform for developing web applications for .NET. And C#
is a OO language designed for the .NET platform. So you can write web
services in C#, VB.NET & over a dozen other .NET aware languages.

Regards
Joyjit

 

[Cowboy \(Gregory A. Beamer\) [MVP]]

I want to use .NET for writing web services that will mainly call SQL Server
(2000) stored procedures in a database. What are the
advantages/disadvantages of using C# vs. ASP and vice versa?

I assume you mean classic ASP versus ASP.NET (.ASMX web services). Simple:
With the newer methodology (ASMX with either C# or VB.NET), you save tons of
time and they run faster. Benefits of ASP version: Familiarity? If you come
from ColdFusion, you will not find this much of a benefit.

If you can get .NET installed on the server, it is a no-brainer: ASMX
(ASP.NET) based web services are a lot easier to code and maintain. They
also run faster.

Also, if any one is familiar with ColdFusion MX, what are the
advantages/disadvantages of using .NET (one of the two languages above) to
write the same web service vs. using CFMX?

Primarily speed on an equivalent platform. In addition .NET will write your
WSDL for you if you use ASMX based services.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************