As a database designer, I often create on database tables the primary key as identity autoincrement and sometimes I needed to find missing or deleted IDs thet interrupt the sequence of autoincrement number on the primary key. To do this you can create a sequence from 1 (or 0 based on setted RESEED) to MAX […]
Recently I needed to find in all files version history of a TFS 2010 project with Visual Studio 2010. Searching on Google I found Visual Studio 2010 and 2012 extensions, developed by Mattias Sköld, that allow you to achieve the goal. Let’s see how to find inside all version of files with Visual Studio 2010 […]
When you work with Team Foundation Server 2010 and Visual Studio 2008 you cannot merge file changes when you try to unshelve a shelveset. In fact if you try to unshelve a shelveset which contains file already chenged on the local workspace, you will have the following error: TF203015: The item $/mypath/myfile.cs has an incompatible pending change because the file myfile.cs is checked out on […]
For different needs, often I had needs to send a list of values to a Stored Procedure. To achieve this goal it is possible to use a workaround with the TSQL function nodes(XQuery) on the types of XML data. We’ll see two examples to better understand the proposed solution. Example 1: How to send […]
The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state.
In the SOA-oriented programming, one of the major mistakes that you make when use WCF services is create an instance of the Transparent Proxy statements within the using statement, as follows: The error you get is the following: Type: System.ServiceModel.CommunicationObjectFaultedException. Message: The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the […]