SQL Server Project using Visual Studio 2012

I just started using SQL Server Project template in Visual Studio 2012 and my first impression? This is great! There are several ways we traditionally create databases and manage the schema over time. Sometimes you just go to SQL Server Management Studio and simply create database objects such as tables, views, indices, and stored procedures … Read more

Disconnected ODP.Net and System.Data.OracleClient Connections

Wow, talk about Mondays! I’ve been developing an ASP.NET Web service that connects to an Oracle backend.  Up to today, we’ve only tested on an isolated network and guess what–the configuration of this environment didn’t exactly mirror the QA or the production environment. When we were testing on this isolated network, the application never had Oracle … Read more