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 vote195 views3 answers
C# calculator
C#
3 votes251 views4 answers
Sir W. Arthur Lewis
C#
0 vote264 views1 answer
Asp.net get most recent file in directory
C#
0 vote263 views1 answer
Random in f#
C#
0 vote244 views1 answer
How to save datagridview data to database in c# windows application
C#
4 votes236 views3 answers
C# sum of list
C#
5 votes255 views2 answers
C# break from foreach method
C#
2 votes243 views1 answer
Linq query select top 1 c#
C#
7 votes237 views2 answers
How to make a character move in unity 3d
C#
0 vote257 views1 answer
Delay activity in uipath
C#