I was working on some code that used Entity Framework and an ASP.NET WebAPI as the interface for accessing the data. With my experience so far, when I publish my WebAPI and then access it, the result is a JSON formatted file that I can open or save via a message popup similar to that […]
Read More →Category: Data Store
Connection Timeout (Timeout Expired) on Azure Web App Site / Azure SQL
I not only support Azure Web Apps, formerly Azure Websites, but I use it too. I had a site that was getting the exception shown in Figure 1. The error was “Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in […]
Read More →Upgrade from Oracle 10g to Oracle 11g with ODP.net and NHibernate ORA-12514
Firstly, let me say that there is nothing special about this upgrade. The instructions which I wrote here will still work with an 11g database. The issue I had was more with, what is the difference between a SID and a SERVICE_NAME which is used to identify the data instance to connection to. The SID […]
Read More →NHibernate and Entity Framework
Prior to getting my job here at Microsoft, I was, and in many aspects still am passionate about NHibernate. I discovered a particular liking to ORM’s in general. I liked it so much that I wrote a book called “Working with NHibernate 3.0” which is available on Amazon or from the Wrox.com website. What I […]
Read More →