Monthly Archives: August 2008

LINQ: LINQ to SQL Overview

Posted on August 31, 2008 by sujant

LINQ to SQL is a O/RM solution (Object Relational Mapping) where as LINQ is not. LINQ to SQL can greatly simplify the code you would write to perform operations against a SQL Server Database table. Gone are the days where … Continue reading →

Posted in Uncategorized | Leave a comment

BizTalk: BizTalk 2009 (BizTalk Server 2006 R3) to be released in Q1 2009

Posted on August 27, 2008 by sujant

Microsoft is planning to release BizTalk 2009 (dropped the name 2006 R3 as it is feature complete) sometime in the first quarter of 2009. This release will support Visual Studio 2008 SP1, Windows Server 2008 SP1 and SQL Server 2008. … Continue reading →

Posted in BizTalk | Leave a comment

LINQ: LINQ Overview

Posted on August 21, 2008 by sujant

You can apply LINQ to different types such as Objects, Data (Datasets, SQL, Entities), XML, Web Services (Amazon etc).     Goal of LINQ is to maintain the same code regardless of the data source with different back-end processes.   … Continue reading →

Posted in .NET | Leave a comment

BizTalk: Using WCF Adapter to poll Oracle Database table

Posted on August 17, 2008 by sujant

In this scenario, I would like to poll a Oracle database table checking for a certain column (default value is null), get back a bunch of rows that match my select condition, update the column with some value and send … Continue reading →

Posted in BizTalk | Leave a comment

BizTalk: Configuring WCF-Custom Adapter for Oracle databases

Posted on August 9, 2008 by sujant

Software Prerequisites Download this document for step by step instructions with screen shots. Make sure you have the following components installed on the system where you will install the BizTalk Adapter Pack: Microsoft .NET Framework 3.0. Microsoft BizTalk Server 2006 … Continue reading →

Posted in BizTalk | Leave a comment

BizTalk: TopXML Oracle Database Adapters Overview

Posted on August 7, 2008 by sujant

  BizTalk Adapters Processing Generation of BizTalk schemas based on SQL statements, Stored Procedures (in, out, return parameters), multiple tables Periodic polling of data source Oracle alerts (send and receive) can send asynchronous notifications based on some events. Uses DBMS_ALERTS … Continue reading →

Posted in BizTalk | Leave a comment

SharePoint: Recovering after SP1 upgrade failure

Posted on August 4, 2008 by sujant

Recently at one of my previous clients, MOSS environment was messed up after they performed the SP1 upgrade. Lessons learned was follow the instructions very closely when performing the SP1 upgrade as it could pretty much bring down your MOSS … Continue reading →

Posted in SharePoint | Leave a comment

SharePoint: Application Templates for WSS 3.0

Posted on August 1, 2008 by sujant

Often times clients ask can I use SharePoint sites to mange timecards, conference room reservations, bug tracking, project management etc. Microsoft provides Application Templates (both custom templates *.stp and site definitions *.wsp) that can be easily installed and configured. Instead … Continue reading →

Posted in Uncategorized | Leave a comment