"c# oracle transaction commit example" Code Answer's
You're definitely familiar with the best coding language C# that developers use to develop their projects and they get all their queries like "c# oracle transaction commit example" answered properly. Developers are finding an appropriate answer about c# oracle transaction commit example related to the C# coding language. By visiting this online portal developers get answers concerning C# codes question like c# oracle transaction commit example. Enter your desired code related query in the search bar and get every piece of information about C# code related question on c# oracle transaction commit example.
c# oracle transaction commit example
public int RunOracleTransaction(Student s, Marks[] m, Course[] c) {
//TODO: validate s, m, c
using (OracleConnection connection = new OracleConnection(connectionString)) {
connection.Open();
using (OracleCommand command = connection.CreateCommand()) {
using (OracleTransaction transaction = connection.BeginTransaction(IsolationLevel.ReadCommitted)) {
command.Transaction = transaction;
try {
// Insert the student
//TODO: put actual query here
command.CommandText =
@"insert into Students(name)
values (:prm_Name)
returning id into :prm_id"; // <- we want inserted student's id
//TODO: check actual RDBMS types
command.Parameters.Add(":prm_Name", OracleType.VarChar).Value = s.Name;
command.Parameters.Add(":prm_Id", OracleType.VarChar).Direction = ParameterDirection.Output;
command.ExecuteNonQuery();
string studentId = Convert.ToString(comm.Parameters[":prm_Id"].Value);
// Insert his/her marks
command.Parameters.Clear(); // <- forget all prior parameters
//TODO: put actual query here
command.CommandText =
@"insert into StudentsMarks(student_Id, mark)
values (:prm_Student_Id, :prm_Mark)";
//TODO: check actual RDBMS types
command.Parameters.Add(":prm_Student_Id", OracleType.VarChar).Value = studentId;
command.Parameters.Add(":prm_Mark", OracleType.Int32);
// insert each mark (in a loop)
foreach (var mark in m) {
command.Parameters[":prm_Mark"].Value = m.Mark;
command.ExecuteNonQuery();
}
// Finally, commit all the inserts
transaction.Commit();
}
catch (DataException e) {
transaction.Rollback();
Console.WriteLine(e.ToString());
Console.WriteLine("Neither record was written to database.");
}
}
}
}
//TODO: your method returns integer value, please return it
}
Source: stackoverflow.com
.net core executenonqueryasync Oracle transaction
public void RunOracleTransaction(string connectionString)
{
using (OracleConnection connection = new OracleConnection(connectionString))
{
connection.Open();
OracleCommand command = connection.CreateCommand();
OracleTransaction transaction;
// Start a local transaction
transaction = connection.BeginTransaction(IsolationLevel.ReadCommitted);
// Assign transaction object for a pending local transaction
command.Transaction = transaction;
try
{
command.CommandText =
"INSERT INTO Dept (DeptNo, Dname, Loc) values (50, 'TECHNOLOGY', 'DENVER')";
command.ExecuteNonQuery();
command.CommandText =
"INSERT INTO Dept (DeptNo, Dname, Loc) values (60, 'ENGINEERING', 'KANSAS CITY')";
command.ExecuteNonQuery();
transaction.Commit();
Console.WriteLine("Both records are written to database.");
}
catch (Exception e)
{
transaction.Rollback();
Console.WriteLine(e.ToString());
Console.WriteLine("Neither record was written to database.");
}
}
}
Source: docs.microsoft.com
All those coders who are working on the C# based application and are stuck on c# oracle transaction commit example can get a collection of related answers to their query. Programmers need to enter their query on c# oracle transaction commit example related to C# code and they'll get their ambiguities clear immediately. On our webpage, there are tutorials about c# oracle transaction commit example for the programmers working on C# code while coding their module. Coders are also allowed to rectify already present answers of c# oracle transaction commit example while working on the C# language code. Developers can add up suggestions if they deem fit any other answer relating to "c# oracle transaction commit example". Visit this developer's friendly online web community, CodeProZone, and get your queries like c# oracle transaction commit example resolved professionally and stay updated to the latest C# updates.