Posts by Rafael • 661 points
22 posts
-
1
votes0
answers119
viewsQ: UPDATE command on a JSON
Good afternoon, everyone, I’m trying to update a column of my table, but this column stores a JSON Object, only that for this I need to make a where with a JSON also. This one is how the data is…
-
0
votes1
answer123
viewsQ: Perform a Get that takes a List<long> ids as parameters
all right? I am doing a project in C# and at the moment I am doing the methods to be consumed via API Rest, my boss asked to do an Httpget that receives as parameter a List ids. I know that in my…
-
4
votes4
answers178
viewsQ: Doubt about React (props or state)
Good afternoon I’m beginner with React, I started reading his documentation and I had a little question: would like to know the difference between prop and state? And when I know when to use a prop…
-
3
votes1
answer37
viewsA: SQL, Relation between SQL tables
You can do it this way: Creates the student table: CREATE TABLE Aluno ( idAluno INT PRIMARY KEY AUTO_INCREMENT, nome VARCHAR(255) NOT NULL, idade int not null ); Create the table sheet: CREATE TABLE…
-
1
votes1
answer79
viewsA: Doubt about how to register
Well this looks a lot like an item registration in an order, I will do it in a well summarized way, but it is not the only way to do ok? First in his controller of Equipment we will make him return…
-
1
votes1
answer59
viewsQ: Doubt about how to put two different things in the same view
Guys, I have a small system that registers equipment and software. In data modeling a device can have several software installed on it, so the first time I made a crud to register only the equipment…
-
1
votes1
answer173
viewsQ: Conversion failed when Converting the varchar value 'COL' to data type int
I’m trying to register a project in a certain area, but every time I try to register it returns an exception. Exception: An Exception of type 'System.Data.Entity.Infrastructure.Dbupdateexception'…
-
1
votes1
answer48
viewsQ: Doubts about validation for the implementation of the modal
Hello, I’m making a control system and ended up locking in one part, I have two classes, the equipamento and the area, where an area may have one or many equipment and an equipment belongs to a…
-
1
votes1
answer164
viewsQ: How to make a Join in C#
Guys I’m having a question, I can make a SQL command (Ex.: select * from T_TABELA) in my C# repository like I do in the database, but I’d like to know if you can do a command join in the same C# I…
-
4
votes3
answers103
viewsQ: Nullable property in C#
I was looking at some tutorials and suddenly I saw this property public Nullable<int> Id {get; set;}. What it means and when I would use it?
-
2
votes1
answer53
viewsQ: Difference between Executequery, Sqlquery and Executesqlcommand
What is the difference between Executequery, Sqlquery and Executesqlcommand? When I know which one to use?
-
2
votes1
answer44
viewsQ: Doubts about Sessions and Roles
I have a controller responsible for doing the Login part, configured on web.config to use the <authentication mode="Forms"> <forms loginUrl="~/Usuario/Login" timeout="30" protection="All"…
-
3
votes1
answer70
viewsQ: Doubt on the link of two tables to bring in view
I have a Brand table and a Model table, where at the time of listing all brands I can bring from the bank and send to my controller, only at the moment I do the research to list the Templates and…
-
2
votes2
answers99
viewsQ: Validation with Dataannotation
I want to do a validation with the size of a field of the type int using Dataannotation, I used [MaxLengthAttribute(10)], only at the moment that I will make the View Index to bring up the list of…
-
6
votes2
answers1072
viewsQ: What use is Notmapped?
I’d like to know what the [NotMapped] and when to use it?
-
2
votes1
answer94
viewsQ: What is Membership for?
I was analyzing Web.confg and a question arose, what is the usefulness of the tag membership? What is he?
-
3
votes3
answers297
viewsQ: What is Appsettings for?
I was looking at Web.confg and would like to know what the <appSettings>? What it interferes with our application?
-
-1
votes2
answers58
viewsQ: Doubt about the Context Class
In my system I have class Context to make the connection with the Bank, through the Entity Framework and I have a doubt, I should only use the public DbSet<NomedaClasse> Classe {get; set;} if…
-
1
votes1
answer416
viewsQ: Relational model for user login
I need to make a simple trademark registration system, but I would like the person who is registering a new brand to be logged in to the system, I have a difficulty where to fit the login table in…
-
2
votes2
answers74
viewsQ: Typing
I am creating a database and in it has a field that receives a date, I would like it to appear only the date. If I use the type datetime comes with the time too. And in SQL Server you have the type…
-
2
votes4
answers2042
viewsQ: Select with 3 tables in SQL SERVER
I need to make a select in the machine table, but when I run my command select maq.maqNip, equi.* from tblMaquina maq join tblEquipamento equi on equi.equId = maq.maqTipoEqui; the following result…
-
2
votes1
answer90
viewsQ: SQL command in C#
Well I’m doing a crud using mvc and Entity framework, only I don’t know how to pass parameters... here’s my code public void Cadastrar(TimeModel timeObj) { strQuery = "INSERT INTO TimeFut (nome,…