Given the following dbml.

k

BTW, I just realized that you could create new Stored Procedure using C# code.
As long as you have rights to create Stored Procedures (used login to the database connection must have rights).

Then you could write script to CREATE stored procedure and run from C# code.
I think it is better to use the right database tool because it would give better help finding error and correcting errors.

But if you have perfect code, you could use C# code to create Stored Procedures.

Ashok

BTW, I just realized that you could create new Stored Procedure using C# code.
As long as you have rights to create Stored Procedures (user login to the database connection must have rights).

Then you could write script to CREATE stored procedure and run from C# code.
I think it is better to use the right database tool because it would give better help finding error and correcting errors.

But if you have perfect code, you could use C# code to create Stored Procedures.

Ashok

This ADO.NET and linq is not much of a big difference?

Linq-To-Sql uses ADO.NET behind the scene.

ADO.NET Entity model is different. How data is accessed is same, but how you write code is different.

If you want best (very interesting), see ONE HOUR Video @

http://www.silverlight.net/learn/videos/all/net-ria-services-intro/

Above video is made for Silverlight, but I think you could use same approach in ASP.NET applications.

HTH
Ashok

Make sure you spend one hour wathcing the video at above link first.  You will not regret it.

See this also, which proves that .NET RIA Services can be used without Silverlight.

http://hatim.indexdev.net/2009/03/27/getting-started-with-net-ria-services/

HTH
Ashok