CODEWITHSUNDEEP
linq.net-core
Andy Williams
Andy Williams

Reputation: 907

SQL Conversion to Linq conversion for .NET Core

Here is my SQL query. I'm trying to produce the same results in my .NET Core web app using a linq query.

SELECT * 
FROM dbo.BUD
WHERE LEFT(PeriodD, 4) = YEAR(GETDATE())

Here is what I've tried with no success in my linq query

List<SelectListItem> budNames = _ctx.Budgets.AsNoTracking()     
            .Where(n => (n.Period, 4) == GETDATE())  
            .Select(n => new SelectListItem
                             {
                                 // values
                             }).ToList();

Upvotes: 0

Views: 26

Answers (1)

Emaro
Emaro

Reputation: 1497

Mainly this line causes you problems:

.Where(n=> (n.Period,4) == GetDate())

To get the first 4 characters of a string, use the Substring method:

n.Period.Substring(0, 4) // beginn 0 away from the first char, take 4 of them

To get a sting of the current year (DateTime):

var currentYear = DateTime.Now.ToString("yyyy");

Applied to your example:

var currentYear = DateTime.Now.ToString("yyyy");
List<SelectListItem> budNames = _ctx.Budgets.AsNoTracking()     
    .Where(n => n.Period.Substring(0, 4) == currentYear)  
    .Select(n => new SelectListItem
    {
        // values
    }).ToList();

Or, you could use the StartsWith method:

var currentYear = DateTime.Now.ToString("yyyy");
List<SelectListItem> budNames = _ctx.Budgets.AsNoTracking()     
    .Where(n => n.Period.StartsWith(currentYear))  
    .Select(n => new SelectListItem
    {
        // values
    }).ToList();

Upvotes: 2

Related Questions