Automated checking of database connection and query in same database [closed]

by

These various steps can be achieved by simply wrapping the database call in some error handling. The overall structure would be something like this:

try
{
  // Perform your SELECT statement
}
catch (SqlException e)
{
  // Log the error, send an email, etc.
}

As for what goes where the comments are, that’s up to your setup I guess. The SELECT can be through an ORM, LINQ2SQL, ADO.NET, etc. The error logging would be however you normally log errors, and the sending of the email would be however you normally send emails (hopefully abstracted behind a service call and not manually hitting your SMTP server from within the catch statement).

More Related Contents:

  1. convert sql query into lambda expression [closed]
  2. Store value in Yes/No field in Access using C#
  3. how to get date difference between two dates using DateDiff Excluding the weekends [duplicate]
  4. C# Data Connections Best Practice?
  5. Is there a good LINQ way to do a cartesian product?
  6. Parsing SQL code in C# [closed]
  7. SQL Express connection string: mdf file location relative to application location
  8. LINQ to SQL – Left Outer Join with multiple join conditions
  9. Why does the Contains() operator degrade Entity Framework’s performance so dramatically?
  10. How to save image in database using C# [closed]
  11. Query extremely slow in code but fast in SSMS
  12. DateTime format to SQL format using C#
  13. Filter sql based on C# List instead of a filter table
  14. Code to validate SQL Scripts
  15. SQLException : String or binary data would be truncated
  16. C# Version Of SQL LIKE
  17. C# SqlCommand – cannot use parameters for column names, how to resolve?
  18. Application can’t scaffold items
  19. Retrieve an object from entityframework without ONE field
  20. ALTER TABLE DROP COLUMN failed because one or more objects access this column
  21. Why is a SQL float different from a C# float
  22. Anonymous type result from sql query execution entity framework
  23. Oracle Parameters with IN statement?
  24. problem using Oracle parameters in SELECT IN
  25. How to pass a null variable to a SQL Stored Procedure from C#.net code
  26. How to insert data into SQL Server
  27. how to recognize similar words with difference in spelling
  28. String field with single quotation mark is causing an error when inserting record in table
  29. Linq To Sql compare Time only
  30. Update-Database command is not working in ASP.Net Core / Entity Framework Core because object in database already exists

Leave a Comment