Exclude TFS DLLs During Publication

In one of my projects, I use an ASP.Net MVC site to communicate with Team Foundation Server (TFS) to display metrics/graphs/reports. The site is hosted on the same server that hosts TFS and during publication, it publishes the file Microsoft.TeamFoundation.WorkItemTracking.Client.DataStoreLoader.dll in the bin folder each time, which causes an ASP.Net error because the dll is already on the server.

It is possible in an ASP.Net MVC project to exclude files and directories by creating a .wpp.targets file. This allows you to define the exclusions as well as the source/reason for the exclusion.

[Read More]
dll  tfs  publication  MVC  XML  WPP 

SqlDataSource and ORA-01036 Illegal variable name/number

If you ever use the Oracle ODP.Net component with SqlDataSource and get the ORA-01036 Illegal variable name/number error, it is mainly due to the fact that your number of parameters does not match the number in your Insert, Update, or Delete query. I had this problem using a ComposedKey with the ASPxDataGridView from DevExpress. You need to remove the ComposedKey field before executing the query.

Here is the conversation on ASP.Net that helped me resolve this issue.

[Read More]