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 vote284 views1 answer
How to update model when database change in entity framework core
C#
3 votes309 views1 answer
Difference two list c#
C#
0 vote363 views1 answer
.net core System.InvalidOperationException: No service for type 'Microsoft.AspNetCore.Http.IHttpContextAccessor' has been registered
C#
-1 vote296 views2 answers
Indexof c#
C#
9 votes309 views1 answer
You have the following c# code. stringbuilder sb = new stringbuilder(really long string); the really long string variable is a string in which a very long string is stored.
C#
1 vote291 views1 answer
Newtonsoft create dynamic object
C#
0 vote315 views1 answer
C# datagridview cell click event
C#
3 votes302 views4 answers
How to make a picture center in html
C#
0 vote327 views1 answer
How to get relative path in c#
C#
0 vote302 views1 answer
C# alphabetize a list of string
C#