I have the need to carry out a few thousand inserts into an oracle database from a C# program. What would be the best way to carry this out? I need the ability to control transactions and run queries and stored procedures. I don't have a need for a full blown ORM and guess I really just want a simple, stable DAL to run queries. Can anyone suggest such a framework?
Look at following oracle data provider for .NET
http://www.oracle.com/technetwork/topics/dotnet/index-085163.html
or else, you can look at OLEDB for Oracle.