C# 3.0 Features Basics For LINQ PART II

Continuing from part 1, here I will go one more step further and explain the language constructs basics in C# 3.0 which will help us in writing a LINQ query. Lambda Expression Explained In C# 2.0 you can write anonymous delegate methods that helps in reducing the amount of code written. To explain this, first…

1

C# 3.0 Features Basics For LINQ – PART 1

The ‘var’ Keyword Type inferred at compile time Can only be defined within method scope Mostly used when you need a variable for anonymous types which can only be resolved at compile time e.g. LINQ queries Auto Implemented properties This feature eases the creation of properties for a field inside the C# class  e.g. 1:…

1

SSIS Service fails with error "Access denied" at startup

Recently I got an issue where we were unable to start the SQL Server Integration Services(SSIS) service and was failing with the error of “Access Denied”. If you do a default installation then the SSIS service runs under NT AUTHORITY\Network Service. Symptoms Occassionaly you will also see the folowing error inside System Events DCOM got…

0

Indications that we are leaking connections

We get a lot of queries from developers around the following error while they are using ADO.NET "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached." Most of the times this is an…

1