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

0 vote200 views1 answer
C# method summary new line
C#
0 vote209 views1 answer
Change color of object unity
C#Unity
-2 votes1.2K views1 answer
How to reference a static variable from another script in unity
C#Unity
0 vote158 views1 answer
C# get excel column number from letter
C#
0 vote154 views1 answer
C# print expression tree
C#
1 vote184 views1 answer
There is already a virtual axis named Horizontal registered. unity
C#Unity
1 vote233 views1 answer
Unity3d quaternion add 90 degrees
C#Unity
20 votes136 views4 answers
JSONStringify c#
C#
1 vote219 views1 answer
Unity3d change player position
C#Unity
2 votes192 views1 answer
Fade text unity
C#Unity