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

20 votes174 views2 answers
Change scale of an object unity
C#Unity
0 vote171 views1 answer
Jaro–winkler distance c#
C#
6 votes141 views1 answer
How to generate entities from an existing database in entityframework core
C#
0 vote167 views1 answer
Get name of project c# .net
C#
8 votes129 views1 answer
Unity how to convert mouse screen position to world position
C#
0 vote146 views2 answers
Autoit console write
C#
-3 votes128 views2 answers
C# how to append in array
C#
0 vote130 views2 answers
C# how to convert string to float
C#
1 vote139 views1 answer
Animations for pause menu
C#
277 votes216 views6 answers
Unity download
C#Unity