Messages that are not successfully processed are termed as dead letter messages in the azure service bus. The dead letter queue holds all the dead letter messages that for some reason are not processed successfully. DLQ is subqueue of the main queue. There can be many reasons for the dead letter messages such as : […]
How To Access Dead Letters From Azure Service Bus Read More »
With the help of ADO.NET in C# we can build a connection with any SQL database and perform data transactions. To perform the transaction the first step would be to get connected to a database. The following syntax will help to initialize a instance : using (SqlConnection connection = new SqlConnection(“Your connection strings”)) {} Now
How to insert data in Sql database in C# with ADO.NET and return the identity column Read More »
In order to select a single row in Sql we normally use the following syntax : Select * from table name where column name = value;For Example we have a table People and we want to fetch the row where PersonId is 1 we will use the following statement:select * from People where PersonId=1 Now
Selecting multiple rows in sql Read More »
Following is the syntax for insert statements in SQL : INSERT INTO TableName(Column1,Column2……)VALUES(Value1,Value2…..) For Example we want to insert data in a table named People with the following columns : Following will be the insert query for inserting a record inside the table : Insert into People(PersonID,LastName,FirstName,Address,City) Values (1,’TestLastName’,’TestFirstName’,’TestAddress’,’TestCity’) This insert statement will insert a
Insert data in a table in SQL Read More »
To remove duplicates from a list in C# we can use the Distinct function: List<string> ListwithoutDuplicates = ListwithDuplicates.Distinct().ToList(); The list ListwithoutDuplicates will be free of all duplicate values present in the original list.
Removing duplicates from a list in C # Read More »
In C# the following exception ‘An item with the same key has already been added’ occurs when duplicate keys are initialized inside a Dictionary. The key is a unique value and same keys cannot exist in a dictionary. The error message already contains enough information to fix this issue. For Example the below code will
C# – An item with the same key has already been added Read More »
Following is the syntax for declaring a dictionary in C# : Dictionary<int,string> NewDictionary = new Dictionary<int,string>(); Now elements can be added in this list using function : NewDictionary.Add(1,“Name1”); NewDictionary.Add(2,“Name2”); Here 1 and 2 represents unique keys for vaules ‘Name1’ and ‘Name2’. The key is a unique value and same keys cannot exist in a dictionary.
Initialize Dictionary in C# Read More »
Following is the syntax for declaring a list in C# : List NewList = new List(); Now elements can be added in this list using function : NewList.Add(“Name1”); NewList.Add(“Name2”);
Initialize List in C# Read More »