Why do you prefix stored proc names with sp?
You don't call variable "x" in your C# codexVariable
or var_x
.You don't call a table "Products" in your database
ProductsTable
or table_Products
.So why do you call your stored procedures
sp_GetProducts
?Are prefixes really necessary in stored proc names? Isn't it obvious enough that it's a stored procedure?
Just wondering.
(If you have to prefix your stored procs, don't use "sp" because then they appear to be system stored procs...)