oracle

Hello Everyone, I need to create a job(.Net Framework console project) which needs to run monthly once to insert data from sql server table to oracle source table(which needs to insert every month records into the oracle table) Can someone please let me know any reference to do this kind of...

Hi everyone, Is it possible to do scaffolding after install our program and run it? Is using powershell right way to go to do this? Or what else can I do? I need any advice of you. Thank you.

Hi, I need to do scaffolding in code. To do this I wrote this method; public string RunScript(string scriptText) { string dir = @"C:\Users\demetsen\source\repos\ScaffoldingInCode\ScaffoldingInCode"; Directory.SetCurrentDirectory(dir); Runspace...

Hello everyone, I am just a beginner in this vast c# world. Hence I want to know why most of the code over the internet had using keyword while creating a new OracleCommand object. Is there is any significant importance? Apart from that I also want to know how to open and dispose of database...

I am trying to map a simple Oracle UDT in my c# application. When I try to extract data from DataReader, it throws the following exception: Custom type mapping for 'dataSource='DB' schemaName='C##USER' typeName='MATICNIBROJ_T'' is not specified or is invalid My Oracle UDT is: create or...

I am trying to delete millions of records from Oracle 11G using ODP.NET or DevArt. If I send in 100 delete statements I want them to all execute at the same time. But instead they run in order 1 by 1. I tried using the conventional way open connection execute statement close connection each...

As my program steps through a dictionary and inserts records, my memory usage creeps up until I get a failure in my code. I am opening my connection to Oracle at the beginning and then just reuse the same connection during the entire process. So, calling the following code with a large insert...

I'm attempting to develop an application in the new world of Visual Studio 2015 DNX projects. I'm unable to figure out how to get Entity Framework 6.1.3 to connect to Oracle 12c with the Oracle.ManagedDataAccess NuGet Package. I get the following error; "Unable to determine the provider name for...