Raq query ef core

public static class Helper
{
    public static List<T> RawSqlQuery<T>(string query, Func<DbDataReader, T> map)
    {
        using (var context = new DbContext())
        {
            using (var command = context.Database.GetDbConnection().CreateCommand())
            {
                command.CommandText = query;
                command.CommandType = CommandType.Text;

                context.Database.OpenConnection();

                using (var result = command.ExecuteReader())
                {
                    var entities = new List<T>();

                    while (result.Read())
                    {
                        entities.Add(map(result));
                    }

                    return entities;
                }
            }
        }
    }

Source: stackoverflow.com

Similar codes

1 vote332 views1 answer
And in c#
C#
0 vote298 views1 answer
The anti-forgery cookie token and form field token do not match.
C#
0 vote322 views1 answer
Shut game unity
C#
6 votes333 views1 answer
C# split a string and return list
C#
0 vote309 views1 answer
Return stream from file c#
C#
0 vote313 views1 answer
Rock paper scissors c#
C#
0 vote314 views1 answer
Unity mix gradient colors
C#
8 votes344 views4 answers
How to add arrays in C#
C#
3 votes298 views2 answers
C# bytes to image
C#
10 votes323 views1 answer
Bootrap modal
C#