harrypalmerr

You may use RecordsAffected property of SQLDataReader for counting the number of emails sent per user, but as it is not set until all rows are read and you close the SqlDataReader, you must assign seperate datareader object to select all records per user.

Memory allocation in C# generates some security related problems such as unauthorised access to the data being passed by reference. This is because garbage collector performs the task of deallocating the memory assigned on heap for such variable periodically. In the meantime, some unauthorised access can occur by third party …

When the stored procedure size is very large in pages, you could distribute the functionality easily with some of the processing coded in the application. On the other hand, many developers write their entire database calls in application code. Obviously, it eliminates the database server completely without any use of …