This will only work with SQL Server 2008 and above as it requires a new feature of SQL Server only present in 2008 and 2008 R2: Table Value Parameters.

Previously when we wanted to provide SQL with a set of data, e.g. a table, we had to pass in XML and parse that within the SQL. SQL’s parsing of XML isn’t great when dealing with large quantities of data. Additionally we want the data in table form anyway, so why bother with the XML? Ideally we just want to be able to pass in a table to SQL, just like we can get tables out.

In this post I’m going to go through the steps in both SQL and C# to allow you to do this. My examples use C# 3.5 and above (through use of Linq) but it could be easily converted to .NET 2.0.

Step One – Create the Data Table Type in SQL Use SQL Server Management Studio to navigate to the correct database. First thing we need to do is define a Table Type. This is a requirement of passing Table value parameters to a Stored Procedure. In this post I’m going to use an example...

Read More »

Recently we’ve been inserting some new functionality into Tr@veller Lite.  Alongside that we’ve also been looking at giving it a distinctively different look and feel to the existing Tr@veller product. 

As yesterday I only covered one command, I’ll cover two today instead.  So far I’ve covered two commands, the Search  and Property commands, today I will be focusing on the Price command. The price command a more detailed breakdown of a properties price than the Search command provides, as well as detailing its extras. These extras can include both optional and compulsory extras.

Another post about the AcuWeb API, since I missed posting one yesterday there will be two today. The first command I’m going to focus on today is the Property Command, more details about the request/response can be found within the AcuWeb API, but I hope to give a general overview as to how this command can be used. For more details on AcuWeb API and the search message see my previous post.

We’ve been working hard behind the scenes on AcuWeb and getting it ready to roll out as soon as we can, but a lot of the work so far has been laying the groundwork to support the degree of flexibility to websites and the booking engine that we want to provide. At this stage however, everything’s getting tied together and that initial work on backend is really paying off. This week I plan on giving a quick overview of some of the messages and how they can be accessed to give a better idea on how easy AcuWeb is to use.

From this blog I’ll be posting about the progress we make on the backend of the Acumen Website replacement project.  This system is designed to be a centralised interface that will both drive the replacement Acumen websites and also allow clients to access it directly to drive their own websites, where required.