Discussion forums for open issues and questions concerning database tools, data access components and developer tools from Devart
https://forums.devart.com/
Code: Select all
void Connection_StateChange(object sender, System.Data.StateChangeEventArgs e)
{
if (e.CurrentState == System.Data.ConnectionState.Open && e.OriginalState == System.Data.ConnectionState.Closed)
ObjectContext.Context.Database.ExecuteSqlCommand("BEGIN sp_vpd('ABCD1234'); END;");
}
The context cannot be used while the model is being created. This exception may be thrown if the context is used inside the OnModelCreating method or if the same context instance is accessed by multiple threads concurrently. Note that instance members of DbContext and related classes are not guaranteed to be thread safe.
Code: Select all
class Program
{
static void Main(string[] args)
{
OracleMonitor monitor = new OracleMonitor() { IsActive = true };
using(var context = new MyDbContext.MyEntities()){
context.Database.Connection.StateChange += conn_StateChange;
var depts = context.DEPTs.ToList();
// ...
}
}
static void conn_StateChange(object sender, System.Data.StateChangeEventArgs e)
{
if (e.CurrentState == System.Data.ConnectionState.Open && e.OriginalState == System.Data.ConnectionState.Closed) {
var cmd = (sender as OracleConnection).CreateCommand();
cmd.CommandText = "BEGIN sp_vpd('ABCD1234'); END;";
cmd.ExecuteNonQuery();
}
}
}