AddInterceptors(new M圜ommandInterceptor()) Return base.ReaderExecuting(command, eventData, result) Public override InterceptionResult ReaderExecuting(DbCommand command, CommandEventData eventData, InterceptionResult result) For example for LINQ queries a public class M圜ommandInterceptor : DbCommandInterceptor There are some "insertion points" we could call where you could inject something to modify the SetCommandTimeout for a single query.
Ef set command timeout 0 code#
I've debugged a little the code of EF Core (it is quite easy with VS 2019, by letting it load the symbols from the nuget server or by forcing it to decompile to source code). ( this DatabaseFacade database, string query, Func map,Ĭommand.As I've said in my comment, it isn't something I think is necessary or really really useful.
Return FromSqlQuery(context.Database, query, map, parameters, List parameters = null, CommandType commandType = CommandType.Text, ( this DbContext context, string query, Func map, PropertyInfos.SetValue(entity, value, null) Using ( var result = command.ExecuteReader())įor ( int i = 0 i dbDataReaderFields.Any(d =>Įntity.GetType().GetProperty(aField.Name) If ( != ConnectionState.Open)Ĭommand.Transaction = currentTransaction.GetDbTransaction() Ĭommand.CommandTimeout = ( int)commandTimeOutInSeconds Ĭ(parameters.ToArray()) Using ( var command = database.GetDbConnection().CreateCommand()) (aProp.PropertyType) ? aProp.PropertyType List entityFields = ( from PropertyInfo aProp ( this DatabaseFacade database, string query,Ĭonst BindingFlags flags = BindingFlags.Public |īindingFlags.Instance | BindingFlags.NonPublic Return FromSqlQuery(context.Database, query, parameters, Int? commandTimeOutInSeconds = null) where T : new() ( this DbContext context, string query, List parameters = null, Finally, calling ExecuteNonQuery() to execute the raw SQL query.īool same = mapp.Name = Name & mapp.Type = Type Then, assign all the required parameters to the command object like the SQL, Command Type, SQL parameters, use existing DB transition, and optional command timeout to the command. From the DbContext's database object, create the Db command. The extraction methods are quite similar to the previous one. Var currentTransaction = database.CurrentTransaction Ĭmd.Transaction = currentTransaction.GetDbTransaction() Public static int ExecuteNonQuery( this DatabaseFacade database, Parameters, commandType, commandTimeOutInSeconds) Int value = ExecuteNonQuery(context.Database, command, Public static int ExecuteNonQuery( this DbContext context, string command, Finally, calling ExecuteScalar() to execute the raw SQL query. Then assigning all the required parameters to the command object like the SQL, Command Type, SQL parameters, using existing DB transition, and optional command timeout to the newly created command. From the Ef DbContext's database object, we are accessing the underlying DB connection object and creating the Db command from it. In the extraction methods, we are using ADO.NET features.
If ( != ConnectionState.Open)Ĭmd.CommandTimeout = ( int)commandTimeOutInSeconds Ĭmd.Parameters.AddRange(parameters.ToArray()) Using ( var cmd = database.GetDbConnection().CreateCommand()) Public static object ExecuteScalar( this DatabaseFacade database, Object value = ExecuteScalar(context.Database, sql, parameters, Public static object ExecuteScalar( this DbContext context, string sql,ĬommandType commandType = CommandType.Text, Return (source as IInfrastructure).Instance Public static DbTransaction GetDbTransaction( this IDbContextTransaction source) A generic wrapper for builtin FromSqlRawĮxecutes the query, and returns the first column of the first row in the result set returned by the query.Mapp returned data rows to a given type T.Executes Raw SQL queries that do return data.Executes Raw SQL queries that do not return any data.Optional command type and command timeout.Returns the first column of the first row in the result set returned by the query.In the helper class EfSqlHelper.cs of Database.Core project, we will find the listed extension methods. Here are some extension methods for DbContext and DatabaseFacade objects to run raw SQLs. ToList() Custom DbContext Extension Methods List usersInDb = Db.Users.FromSqlInterpolated
0 kommentar(er)
