Hi Saumitra,
You can execute multiple query by separating with semicolon ";".
Update your code as below.
private static Voucher CreateEntity(Voucher voucher)
{
OleDbConnection Connection = new OleDbConnection(voucher.ConnectionString);
string query = "INSERT INTO table1(Field1, Field2,..) VALUES(Value1,Value2,..);INSERT INTO table2(Field1, Field2,..) VALUES(Value1,Value2,..);SELECT MAX(Field1) AS LastId FROM Table1;";
OleDbCommand cmd = new OleDbCommand(query, Connection);
OleDbTransaction transaction = null;
try
{
Connection.Open();
transaction = Connection.BeginTransaction();
cmd.Transaction = transaction;
object LastId = cmd.ExecuteScalar();
transaction.Commit();
Connection.Close();
}
catch (Exception ex)
{
if (transaction != null)
{
transaction.Rollback();
}
throw ex;
}
}
Hope thi will help you.