How to connect to Oracle from a .NET Application

Use this: ODP.NET, Managed Driver – Official         http://www.nuget.org/packages/Oracle.ManagedDataAccess/ This short post is just because most of the information you will find on this topic is out-of-date. Oracle finally wrote a 100% managed code ADO.NET provider and it’s available on NuGet.  So you can just right-click on your references and grab the NuGet package.  Not install,…

4

How to load an Assembly in a SSIS script task that isn’t in the GAC

The documented and recommended way to reference a custom assembly from an SSIS Script Task or Script Component is to install it in the Global Assembly Cache (GAC).  However this is not always possible or simple to do. Here’s a simple workaround for loading an assembly from an arbitrary location.  The idea is to register…

26

Compatible Encryption/Decryption for Windows Store Apps and Full .NET Framework

I recently needed to encrypt some data in a Windows Store App and decrypt it on the server in a full .NET Framework application.  The Encryption APIs available in the two environments are different, so I came up with the following class that implements a compatible pair of encryption and decryption functions to enable encrypting…

1

New Sample Published: ObjectDataReader

I just published a new sample in the MSDN sample gallery:  ObjectDataReader.  This is an update of an older sample (EntityDataReader) that is an IDataReader adapter for object collections.  This is useful primarily for bulk loading SQL Server from a collection of .NET objects. ObjectDataReader is intended to be simple and fast.  It uses dynamically-compiled expressions to…


Copying SQL Server Backups to Windows Azure Storage using AzCopy

There are at least three easy ways to get your SQL Server backups to Azure storage, which, being offsite, bottomless, and reasonably-priced is a good thing. First you can use SQL Server 2012’s native backup to URL function. Also you can use the Microsoft® SQL Server® Backup to Microsoft Windows® Azure®Tool, available here: http://www.microsoft.com/en-us/download/details.aspx?id=40740 But…

1