Programming Help

Web Development



What's Here?

  • Members: 118,478
  • Replies: 434,469
  • Topics: 67,154
  • Snippets: 2,407
  • Tutorials: 638
  • Total Online: 937
  • Members: 50
  • Guests: 887

Who's Online?

Welcome to Dream.In.Code
Getting Help is Easy!

Join 118,478 Programmers for FREE! Ask your question and get quick answers from experts. There are 937 online right now! We've got more than 500 tutorials and 2,000 snippets. Join and find out why Dream.In.Code is the #1 programming help community on the internet! Registration is fast and FREE... Join Now!



stored procedures

 
 Reply to this topicStart new topic

stored procedures, All about stored procedures in c# for sql2005
sandeep_sa
post 4 Jul, 2008 - 02:04 AM
Post #1


New D.I.C Head

*
Joined: 4 Jul, 2008
Posts: 1
why should we use stored procedures
User is offlineProfile CardPM

Go to the top of the page


branston
post 4 Jul, 2008 - 04:26 AM
Post #2


New D.I.C Head

*
Joined: 4 Jul, 2008
Posts: 2


My Contributions
They are faster and are less open to attacks from SQL injection. Plus they are easier to organise and maintain (I find).
User is offlineProfile CardPM

Go to the top of the page

baavgai
post 4 Jul, 2008 - 06:29 AM
Post #3


Dreaming Coder

Group Icon
Joined: 16 Oct, 2007
Posts: 1,781



Thanked 73 times

Dream Kudos: 425

Expert In: C, C++, Java, C#, ASP.NET, PHP, Perl, Python, Oracle, SQL Server, MySql, HTML, JavaScript, Lua

My Contributions
Stored procedures are good. They move the data logic into the database where it belongs. However, from the title, "stored procedures in c# for sql2005" are actually quite bad.

I was excited by the idea of embedding C# code in an MSSQL database, the same way Oracle embeds Java. To be fair, Oracle's implementation is a little kludgey and I was hoping MS would be better.

In practice, C# int the database ( sp_configure 'clr enabled' ) can introduce such instability into a system that early MS KB notes advised against using it in production. Stick with T-SQL.
User is offlineProfile CardPM

Go to the top of the page

jayman9
post 4 Jul, 2008 - 09:45 AM
Post #4


Student of Life

Group Icon
Joined: 26 Dec, 2005
Posts: 6,471



Thanked 28 times

Dream Kudos: 500

Expert In: C#, VB.NET, Java

My Contributions
Moved to Databases.
User is offlineProfile CardPM

Go to the top of the page

Fast ReplyReply to this topicStart new topic
Time is now: 10/11/08 05:55AM
Invision Power Board v2.1.7 © 2008  IPS, Inc.
Licensed to: MediaGroup1

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

Bye Bye Ads

Free DIC T-Shirt

T-Shirt Example

Related Sites

Monthly Drawing

Thumb Drive

Partners

Top Contributors

Top 10 Kudos This Month