Posts by João Rafael Colombo • 121 points
15 posts
-
0
votes1
answer38
viewsQ: Packages do not restore Nugetpackage
After upgrading VS2017 to version 15.5.1 this project no longer restores packages I tried to remove the packages and install again but it didn’t work, reinstalled the VS didn’t work out tbm,…
-
0
votes2
answers79
viewsA: join two tables with date condition
when you do Join, do not direct on the table filter before, then it is easier; for example select*from produto a join (select cod_barras, min(valor) valor from produtos_preco where…
-
0
votes3
answers56
viewsA: Visual Studio Variable View does not work
I had the same problem and only solved reinstalling the VS2017, but I used the "Immediate Window" for a while to break the branch that does the same thing...…
-
2
votes2
answers398
viewsA: What is the best way to authenticate in the database?
For the case of user authentication I use 3 solutions depending on the case and the client; All users have their own user in sql: step in Connection string user, so it is possible to put another…
-
0
votes1
answer136
viewsQ: net. 4.6.1 reference error for . netStandart 2.0
I’m having a problem referencing a Standart2.0 project to my api . net Framework 461; occurs the following have the class: public class MeuReturn : IHttpActionResult { private readonly string…
-
2
votes2
answers695
viewsA: How to replicate master update for branches on Team Foundation Server?
I got! Just merge the master into the branch, and there is the option to send only the changes. : D
-
3
votes2
answers695
viewsQ: How to replicate master update for branches on Team Foundation Server?
I am working on a project that has 3 branches. After some time the team saw the need to change the error treatment, which is common among the 3 branches. Is there any way to change the master and…
-
1
votes2
answers678
viewsA: DDD C# - In which layer should I implement the Data export part
Buenas, the "correct" (depending on the case), would be put in the Application, because theoretically, you have to pass in Domain to export data consistent and the layer that has the business rules…
-
1
votes1
answer132
viewsA: How to make a deserialize in a Json with C-Sharp
Normally to serialize and deserialize things I use the Newtonsoft json, in the comparisons is faster than the c# and is very simple to use. It has in Nuget, that makes it easy enough to get the…
-
1
votes0
answers64
viewsQ: How to organize UI needs in the DDD
Where I put the code that does not concern the business rule, but is a necessity for the presentation to the user, such as filling out combobox, dataTables, texboxAutoComplit...? details: Currently…
-
0
votes0
answers45
viewsQ: Validate strings with many zeros
I have to perform a validation on a Trigger on sql server the rule is: if cnpj is != 0 and does not exist in another record continue; however cnpj can come with 0 or 000 or 0000000 or 00, which…
sql-serverasked João Rafael Colombo 121 -
1
votes2
answers1562
viewsA: Import JSON to Database
On sql server you can import, I don’t know what your "automatically" looks like (when to put it in a folder? when to receive an email? when to call a function?). But this link explains several ways…
-
2
votes2
answers544
viewsA: ASP.NET Core Attribute routing
I think I’ve located your problem... try to put an httpAtribut to your method, because even the two expected to receive different things the route system cannot understand for which is: works:…
-
1
votes2
answers1177
viewsA: Consult current month birthday in SQL
If it is SQL SERVER the command would look like this: SELECT * from top_007 where MONTH(dt_nasc) = MONTH(GETDATE())
sqlanswered João Rafael Colombo 121 -
0
votes2
answers270
viewsA: How do I compare values between two tables and send email if it has new value?
If you want to not register double I suggest you create a Trigger for Insert to validate if the record already exists and block the Insert. But if you only want to send the mail at the time of the…