Click here to Skip to main content
16,017,275 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
GeneralRe: What's the difference between dotnet publish -c Release vs -c Debug? Pin
DeltaOrionis2-Aug-22 14:49
DeltaOrionis2-Aug-22 14:49 
QuestionVb.Net and .Net Core 6 Books Pin
crmfghtr14-Jul-22 13:27
crmfghtr14-Jul-22 13:27 
GeneralRe: Vb.Net and .Net Core 6 Books Pin
Richard MacCutchan14-Jul-22 21:13
mveRichard MacCutchan14-Jul-22 21:13 
AnswerRe: Vb.Net and .Net Core 6 Books Pin
Dave Kreskowiak15-Jul-22 8:11
mveDave Kreskowiak15-Jul-22 8:11 
AnswerRe: Vb.Net and .Net Core 6 Books Pin
Consuelo R. Bills3-Aug-22 23:57
Consuelo R. Bills3-Aug-22 23:57 
QuestionHow to use BETWEEN in ASP.NET CORE EF? Pin
Khaled Mohamed Eissa7-Jul-22 3:07
Khaled Mohamed Eissa7-Jul-22 3:07 
AnswerRe: How to use BETWEEN in ASP.NET CORE EF? Pin
Pete O'Hanlon7-Jul-22 3:29
mvePete O'Hanlon7-Jul-22 3:29 
AnswerRe: How to use BETWEEN in ASP.NET CORE EF? Pin
jsc428-Jul-22 1:06
professionaljsc428-Jul-22 1:06 
I'd start by looking at what your SQL is trying to do and simplify it. From what I can see, your WHERE clause can be reduced to
SQL
vYear = 2022
AND EmpCode = 5229
AND NOT VacType IN (10, 15, 16, 17, 18, 19, 20, 21, 23, 24)
AND Result <> 1
AND ('12/07/2022' BETWEEN vStart AND vEnd
    OR CONVERT(DATETIME, '2022-07-13 00:00:00', 102) BETWEEN vStart AND vEnd
    )

I do not understand what the date ranges are for and why there are two different ways of representing dates unless your data has two sets of texts neither as real dates, in which case the comparisons are meaningless.
QuestionAsp.net display numbers from loop on page Pin
KingRoyaltea7-Jun-22 2:24
KingRoyaltea7-Jun-22 2:24 
Rant[REPOST] Asp.net display numbers from loop on page Pin
Richard Deeming7-Jun-22 3:16
mveRichard Deeming7-Jun-22 3:16 
QuestionAsp.net display numbers from loop on page Pin
KingRoyaltea6-Jun-22 4:12
KingRoyaltea6-Jun-22 4:12 
AnswerRe: Asp.net display numbers from loop on page Pin
Richard MacCutchan6-Jun-22 4:21
mveRichard MacCutchan6-Jun-22 4:21 
AnswerRe: Asp.net display numbers from loop on page Pin
Dave Kreskowiak7-Jun-22 7:47
mveDave Kreskowiak7-Jun-22 7:47 
Question.NET SDK that provides side by side comparison and navigation in document pages Pin
Member 1564342420-May-22 2:57
Member 1564342420-May-22 2:57 
AnswerRe: .NET SDK that provides side by side comparison and navigation in document pages Pin
Dave Kreskowiak21-May-22 6:04
mveDave Kreskowiak21-May-22 6:04 
QuestionHow to call some Web API inside another Web API within same Project Pin
Wahaj Khan27-Apr-22 10:35
Wahaj Khan27-Apr-22 10:35 
AnswerRe: How to call some Web API inside another Web API within same Project Pin
Mycroft Holmes27-Apr-22 12:36
professionalMycroft Holmes27-Apr-22 12:36 
GeneralRe: How to call some Web API inside another Web API within same Project Pin
Wahaj Khan27-Apr-22 13:33
Wahaj Khan27-Apr-22 13:33 
GeneralRe: How to call some Web API inside another Web API within same Project Pin
Pete O'Hanlon29-Apr-22 0:34
mvePete O'Hanlon29-Apr-22 0:34 
AnswerRe: How to call some Web API inside another Web API within same Project Pin
Richard Deeming27-Apr-22 21:16
mveRichard Deeming27-Apr-22 21:16 
AnswerRe: How to call some Web API inside another Web API within same Project Pin
jschell8-May-22 7:47
jschell8-May-22 7:47 
QuestionConsole App that refer an external dll Pin
Skeletro 3M15-Apr-22 0:12
Skeletro 3M15-Apr-22 0:12 
AnswerRe: Console App that refer an external dll Pin
Bohdan Stupak26-Jul-22 23:55
professionalBohdan Stupak26-Jul-22 23:55 
QuestionBackgroundWorker [closed] Pin
hshan_7-Apr-22 8:30
hshan_7-Apr-22 8:30 
AnswerRe: BackgroundWorker Pin
Richard Deeming7-Apr-22 21:30
mveRichard Deeming7-Apr-22 21:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.