Based on the inspiration on a thesis last year. this topic helps developers to optimize the use of database via C#.. With the combination of CRUD and Stored Procedure has security that can prevent sql injection.
http://en.wikipedia.org/wiki/Stored_procedure
http://searchoracle.techtarget.com/definition/stored-procedure
http://databases.about.com/od/sqlserver/a/storedprocedure.htm
http://www.sql-server-performance.com/2003/stored-procedures-basics/
http://www.databasejournal.com/features/mssql/article.php/3082201/Implementing-CRUD-Operations-Using-Stored-Procedures-Part-1.htm
http://blog.sqlauthority.com/2007/04/13/sql-server-stored-procedures-advantages-and-best-advantage/
http://stackoverflow.com/questions/274411/do-stored-procedures-really-boost-performance-in-ms-sql-net
http://searchsqlserver.techtarget.com/news/1052737/Why-use-stored-procedures
http://searchdatamanagement.techtarget.com/definition/CRUD-cycle
http://social.msdn.microsoft.com/forums/en-US/architecturegeneral/thread/c6864235-5645-4632-93be-15d4d9bd286d/
http://developtime.blogspot.com/2012/04/performing-crud-operations-with-stored.html
http://sqlblog.com/blogs/paul_nielsen/archive/2009/05/09/why-use-stored-procedures.aspx
http://www.proschconsulting.com/blog/sql-database-crud-stored-procedur-generator/
ReplyDeletehttp://sixrevisions.com/tools/top-five-best-database-management-tools/
ReplyDeletehttp://www.serverwatch.com/trends/article.php/3883441/Top-10-Enterprise-Database-Systems-to-Consider.htm
ReplyDeletehttp://www.mindstick.com/Articles/37dd5217-1856-418c-84af-a344fc353e0c/?Implementing Stored Procedure
ReplyDeletehttp://enterprisedb.com/products-services-training/products/postgresql-overview
ReplyDeletehttp://en.wikipedia.org/wiki/PostgreSQL
http://www.eioba.com/a/1ign/a-basic-introduction-to-postgres-stored-procedures
http://www.techrepublic.com/blog/opensource/why-postgresql-is-a-better-enterprise-database-than-mysql/1202
http://www.craigkerstiens.com/2012/04/30/why-postgres/
http://www.postgresonline.com/journal/archives/197-Why-choose-or-not-choose-PostgreSQL.html
http://en.wikipedia.org/wiki/IBM_DB2
ReplyDeletehttp://www.mssqlcity.com/articles/compare/oracle_vs_db2.htm
http://www.channeldb2.com/profiles/blogs/db2-express-c-vs-ms-sql