Alternate of Sql Functions in .net core 2.2

Question

I am tying to convert my .net framework 4.6.1 project to .net core 2.2. I have got an error "The name Sql Functions does not exists in current context".I have been searching and haven't got any answer yet.

I have tried EF class functions but this didn't solve my problem

select new ReleaseBuildDashboardDto
                    {
                        // to fix
                        DateString = SqlFunctions.StringConvert((double)
                            SqlFunctions.DatePart("m", g.Key.Value)).Trim() +"/" +
                            SqlFunctions.DateName("dd", g.Key.Value) + "/" +
                            SqlFunctions.DateName("yyyy", g.Key.Value),
                        ScheduledCount = g.Count()
                    }).ToListAsync();

What is the code trying to **do**? I'd strongly suggest returning dates from the database **as dates**. — mjwills, Aug 07 '19 at 07:13
@mjwills is correct; however, installing the relevant NuGet package probably does what you want (or at least what you've asked for): https://www.nuget.org/packages/System.Data.SqlClient/ — Paul Michaels, Aug 07 '19 at 07:22

score 0 · Answer 1 · answered Aug 07 '19 at 07:19

0

Maybe, you need to set reference to the System.Data.Object.

OR

try adding System.Data.Entity.SqlServer namespace and see if that works better.

answered Aug 07 '19 at 07:19

Kiya

168
1
17

may you are looking for this ; https://stackoverflow.com/questions/21732569/sqlfunctions-stringconvert-doesnt-work-with-doubles – Kiya Aug 07 '19 at 08:29

Alternate of Sql Functions in .net core 2.2

1 Answers1