Introduction In the previous notes, we analyzed the source files, relying entirely on the syntax tree and traversing its nodes. In many cases, traversing a single syntax tree is not enough to perform deep analysis. Here the concept ”semantic model’‘ comes in handy. A semantic model opens up new possibilities […]
First() vs FirstOrDefault() in C# | How to Use Methods that Return Default Values
Which method should you use to get the first collection’s element that meets a certain condition – ‘First‘ or ‘FirstOrDefault‘? What should you choose to get the last element – ‘Last‘ or ‘LastOrDefault‘? At first glance, the choice may not be obvious. Hopefully, this article will answer these questions and […]
Rename Column Only If Exists in PostgreSQL
In this article, I am going to explain how to rename the column only if a column exists within the table in PostgreSQL. Here, I’ll also explain how to create a table as well as a way to check whether the specified column exists or not in the information_schema, and […]
How to Bind WebGrid in ASP.NET MVC
In this article, I will explain, how to populate/Bind web grid in ASP.NET MVC. Here I’ll show you how to create a table in the database, how to record into SQL Server database table as well as how to retrieve the data from the SQL Server database using entity framework […]
C# Code Analysis Using Roslyn Syntax Trivia
Where to start if we want to analyze all the comments in the code? Which syntax tree nodes do we need to traverse to do this? How can we figure out that the analyzed method contains preprocessor directives for conditional compilation? Such elements of the syntax tree as syntax trivia […]
Dоwnlоаd аnd Instаll SQL Server Mаnаgement Studiо 2019
In this аrtiсle, I’ll exрlаin hоw tо dоwnlоаd аnd instаll SQL server mаnаgement studiо steр by steр. SSMS is а sоftwаre аррliсаtiоn оffered by Miсrоsоft thаt is аn integrаted envirоnment fоr mаnаging аny SQL infrаstruсture, frоm SQL Server tо Аzure SQL Dаtаbаse. The lаtest versiоn оf SSMS is SQL Server […]
C# | Read Delimited Text File
In this article, I’ll show you how to read a delimited text file in c#. To read the text file I’ll use TextReader class to read a sequential series of characters as well as texts from a text file, this class is found in the System.IO namespace or library. Here, […]
Pass DataTable to Stored Procedure as Parameter in C#
In this article, I am going to explain how to pass DataTable to the stored procedure as a parameter. Here I will also explain how to create user-defined table types, stored procedures as well as reading data from notepads. I have seen, many developers get requirements for getting records from […]
ASP.NET | Multiselect Dropdown List With Checkboxes
In this article, I am going to explain how to implement multi-select drop-down list along with a checkbox in asp.net using jQuery. I will also explain about way to display the selected item/checked values of drop-down list. In this tutorial, I will use jQuery plugin for the multi-select dropdown list. […]
Read large text file batch wise using c#
In this article, I’ll show you how to read a large text file in c#. I will also explain how to create batches for reading a large text file using c#. To read the text file I’ll use CustomFileReader class, where i will implement IEnumerable interface to read batch wise sequential […]