One Of The Methodologies To Write Clean, Maintainable & Extensible Software

One of the most important goals when writing a software is to make your code: Clean Maintainable: easy to be maintained, debugged and fixed when needed Extensible: easy to be extended and added to when new requirements are introduced So, the question now is how to achieve this in the most appropriate way without tending to increase code complexity and make it very hard to read and understand. Some may think that this is a quite easy task to...

Read More

SQL Stored Procedures With Table-Valued Parameters(TVP) & Calling From C#

Have you ever wished that you can call a stored procedure passing a collection of data for batch processing to avoid multiple round trips? If yes, then I encourage you to read the rest of this post. Table-Valued Parameters is a type which you can create in SQL. This type is defined in order to allow SQL to understand the structure of the collection you wish to pass to a stored procedure. It is a "strong-typed" approach. So, lets jump into the details and see the magic in action. Note: The source code for this demo can be found on this link Creating...

Read More

Dynamic Filtering Using Linq Query Self-Wrote Library

What you will find in this post: The source code for the library How to use the library Main concept implemented through the library Comparison operators currently supported by the library What you will NOT find in this post: Explanation of the source code of the library Limitations on the library: Needs system user input module to accept conditions in a certain form (discussed below in the main concept implemented) Works only with data collections which implement the "IQueryable" interface To jump to the point, imagine that you are...

Read More

How To Get List Of SQL SPs/Views/Functions/Triggers Containing Certain Word/Pattern

Sometimes you find yourself in a situation where you need to know where a certain word (which may be a name for a column or just a string message) exists in your SQL database code items like stored procedures or views or functions or triggers. In such situation, you will need a search feature which can aid you to find the word you are looking for. I know that you are not supposed to face such case because there should be a proper sort of documentation for the database design. But, believe me in some cases this type of documentation is not found...

Read More

How To Call C# Methods In SQL!!!!

Have you ever needed to use regular expressions in a SQL SELECT statement? Me myself, I have. One day I needed to write a SQL script to fix a data issue on the production environment DB. Fixing this issue required to write a complex script which will carry out complex logic including comparing some columns data values with other using some patterns. It was a nightmare for me and some of my team members to write such script especially that SQL doesn't heavily support such operations. So, I dreamed that I can use regular expressions in my SQL...

Read More

Parent VS. Child Classes - Think Like A Compiler

Some developers get confused when they find that the method they are willing to call takes a class as an input parameter which is the parent/child of the class they already have in hand. They don't know what to do or even when they know, they don't know why it failed/succeeded. I believe that the best way to understand similar topics is to try to think like the compiler. We all know that C# is a strong typed language. This means that the compiler will not allow any code unless it is sure that this code will not cause type mismatch or such things...

Read More