Posts by Luciano Oiticica Lemgruber • 172 points
9 posts
-
1
votes2
answers90
viewsA: Problem with database query by date using Line and Entity in C#
Lucas come on let’s see if I can help you. consultas = ctx.Consultas.Where(a => a.Inicio.Day == entrada.Day && a.Inicio.Month == entrada.Month && a.Inicio.Year ==…
-
-2
votes3
answers98
viewsA: How to check if the record exists in the database and update if it exists
select if((select count(*) from Pessoas where id = 2) > 0, (UPDATE Pessoas SET Name ="João" where id = 0), INSERT INTO Pessoas VALUES (0,"João")) as value from Pessoas
-
0
votes4
answers1423
viewsA: How to build custom queries using Entity Framework?
Hello Ricardo good night. Come on you must want it within the same correct query ? for this you must use a ternary operator await _context.Produtos .Where(x => pesquisa.Nome != null ? x.Nome ==…
-
3
votes2
answers695
viewsA: Command to perform the Down of a migration
Just use the Remove-Migration He’ll get the latest Add-Migration before performing the Update-Database If you have used the Update-Database It will be necessary to redo the changes create a new…
-
1
votes1
answer478
viewsA: Passing variables from AJAX to ASP
You can do your ajax like this. let name; let email: name = document.getElementById('name'); email= document.getElementById('email'); //voê pode setar o email ao inves do getElementById com o $ com…
-
1
votes1
answer484
viewsA: Http Request, with Certificate X509
For this example I’ve put import your certified.pfx file to the root of your project. Do not forget to set in the properties of the certificate.pfx (right click and select properties) in the option…
-
1
votes3
answers470
viewsA: Left Join with LINQ
If the lists are the same you can use Except. Example: var result = ListA.Except(ListB); or var result = ListA.Where(x => !ListB.Exists(y => y.Codigo == x.Codigo)); In some performance test…
-
-2
votes1
answer68
viewsA: html attribute that when clicking on the text the checkbox option is selected
https://www.w3schools.com/tags/tag_label.asp Example: https://jsfiddle.net/sampaNight/1ftsv3w0/3/ <label> <input type="checkbox" value="true" name="campo" id="campo"> Selecione…
htmlanswered Luciano Oiticica Lemgruber 172 -
2
votes1
answer311
viewsA: Individual User Account between MVC and Webapi projects
I recently had to accomplish that. You can use Bearer Token Authentication for that reason. Basically you should generate a JWT Token that you should store in your MVC5. I accept the token when I am…