I decided to write a simple kick start tutorial for WCF-SQL Adapter for beginners. In this tutorial where I just perform single operation insert. A simple BizTalk solution which read a value from file location and insert this value into table. First of all I create a very simple category table. Which hold two fields. As USE [Experiments] GO /****** … [Read more...] about Insert with WCF-SQL-Adapter BizTalk 2010
Archives for March 2012
XSLT is by default used by BizTalk maps (XSLT engine) to transform source schema to destination schema so there is nothing new (If you just open the .cs file of a map you can see it clearly there) Intention of this post is to highlight different usages of custom XSLT. 1) WHEN to use XSLT ? I would prefer to use XSLT in following scenarios, Whenever you have implement a complex … [Read more...] about XSLT In BizTalk Maps
Currently I was searching describe like function, which used in Oracle PLSQL to get the detail of table. I found equvilent function in TSQL "sp_help". you can used it as sp_help <table_name> i.e sp_help studentdet … [Read more...] about describe table tsql
Xpath consider to be slower, because when we get value using xpath, the whole message will be loaded into memory, so Xpath is memory hungry solution Distinguished filed return value faster then xpath. Distinguished filed has limitation. It failed to returning value when message contains multiple node contains the value. In this case Xpath works wonder. Final point is … [Read more...] about Xpath vs Distinguished fields.
For starting Date int month = DateTime.Now.Month; int year = DateTime.Now.Year; // if month is october or later, the FY started 10-1 of this year // else it started 10-1 of last year return month > 9 ? new DateTime( year, 10, 1 ) : new DateTime( year - 1, 10, 1 ); For Ending Date // get the current month and year int month = DateTime.Now.Month; int year = … [Read more...] about How to get Current Fiscal year starting and Ending Date