Retrieving Identity or AutoGenerated Column in ADO.NET

I recently handled an issue where customer was facing difficulty in picking up the Auto Generated primary key column in DataAdapter.Update() call. Looking around on the internet I saw many posts on the forums regarding how to get this value. So thought of posting it here There are 2 ways to go about this Using…

1

Web Client Software Factory-The Web Patterns

This post is in continuance with the last post  I had on WCSF. In this post I will briefly elaborate on various patterns in web development  and the general terms used to help you understand WCSF in a comprehensive way.   The View Presenter Pattern Asp.Net is a great web development platform that enables you…

1

Web Client Software Factory-The Concept

  In this series, I will help you get started with WCSF developed by Patterns and Practices team at Microsoft. If you are a web developer then this Software Factory will be of great help for you in your upcoming web projects. Let me start of with the basics in order to speed you up…

1

File IO System in .NET

I am preparing for MCTS Exam 70-536: Microsoft .NET Framework 2.0 – Application Development Foundation and came across the File IO System. So taking this opportunity here to post few details on the I/O streams to help understand the workings, specially for someone who is just getting started. The following diagram below describes the I/O…

5

Demystifying SQL-Oracle Distributed Query Issues

While running the following query distributed query select * from openrowset (‘OraOLEDB.Oracle’,’oradb’;’scott’;’pwd1234$’, ‘select * from emp’) I got the following error message : Msg 15281, Level 16, State 1, Line 1SQL Server blocked access to STATEMENT ‘OpenRowset/OpenDatasource’ of component ‘Ad Hoc Distributed Queries’ because this component is turned off as part of the security configuration…

2

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…


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

SSL in Microsoft SQL Server JDBC 1.2 driver

One of the major difference between Microsoft JDBC Driver 1.1 and Driver 1.2 is its feature for SSL. If you want to connect to SQL Server 2005 using SSL then you can do this today with the driver. The process to get this done is documented in the help section . This post, is going…