devxlogo

.NET

Get Stored Procedure Content and Details

The following query can be used to get details such as when the Stored Procedure was last updated???as well as its content. SELECT CREATED, LAST_ALTERED, SPECIFIC_NAME, ROUTINE_SCHEMA, ROUTINE_NAME, ROUTINE_DEFINITIONFROM lms_db.INFORMATION_SCHEMA.ROUTINES

Quick Way to Create Class Diagrams for a Project

Class diagrams help you to understand code a lot more quickly through visual representation. Visual Studio, by default, provides you with a one-step process to generate self-updating Class diagrams. Right-click

Serialize an Object to a JSON String

Newtomsonft.json has helper methods that help to serialize objects to JSON. See below for a code snippet that uses the library and helps convert an object to JSON format. public