ef core中使用ExecuteScalar和ExecuteReader

发布时间：2024-05-20 15:20:00来源：本站阅读（752）

public async Task<DbDataReader> ExecuteReaderAsync(RawSqlString sql, params object[] parameters)
        {
            using (await Database.GetService<IConcurrencyDetector>().EnterCriticalSectionAsync(default))
            {
                RawSqlCommand rawSqlCommand = Database.GetService<IRawSqlCommandBuilder>().Build(sql.Format, parameters);
                return (await rawSqlCommand.RelationalCommand.ExecuteReaderAsync(Database.GetService<IRelationalConnection>(), rawSqlCommand.ParameterValues)).DbDataReader;
            }
        }
        //  FormattableString
        public Task<DbDataReader> ExecuteReaderAsync(FormattableString sql)
        {
            return ExecuteReaderAsync(sql.Format, sql.GetArguments());
        }
        public Task<object> ExecuteScalarAsync(FormattableString sql)
        {
            return ExecuteScalarAsync(sql.Format, sql.GetArguments());
        }
        public async Task<object> ExecuteScalarAsync(RawSqlString sql, params object[] parameters)
        {
            using (await Database.GetService<IConcurrencyDetector>().EnterCriticalSectionAsync(default))
            {
                RawSqlCommand rawSqlCommand = Database.GetService<IRawSqlCommandBuilder>().Build(sql.Format, parameters);
                return await rawSqlCommand.RelationalCommand.ExecuteScalarAsync(Database.GetService<IRelationalConnection>(), rawSqlCommand.ParameterValues);
            }
        }