2
I’m having trouble with fields float
. Well, that post will deal with another matter, but I thought I could somehow infer in this problem. I stopped to think and analyze the subject. This is the customer’s bank and it’s very old. If someone tells me to change it, to fix it, forget it, it won’t be possible. Mr Maniero once said that everything is wrong with the bank. Well, I saw that the bank does not have PK and all fields are nullable, but in my Entity Model class, I selected the field IdLiberacao
as PK, that way and I see that it’s not Identity:
[Key]
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
[Column("ID_LIBERACAO")]
public int IdLiberacao { get; set; }
I’m only working with three tables, it may be that in the same client (I have no access) there may be PK, I do not know, only in the second I can ask, but the whole issue is to solve the problem with fields float
and double
.
For being a field nullable in the comic book, I thought that this could bring some kind of problems, problems that I don’t know, if somehow, could be interfering with the behavior of my system, which I opened this post. Everything is badly done in the bank, at least here with me, but as I said, I have no way to change. I can even fix mine here, creating the PK’s. This database (Sql Server 2012) runs with a system developed in Clarion in the client. I am waiting for some answer. The question is: In relation to the previous post, does this situation have to do? Can this leave the behavior of the Entity giving problems like what I’m facing? Everything said here, has to do with the script creation of the three tables passed to me. No script of PK or FK or Index, so I thought what I have here is a small copy of what exists in the customer, but now came doubts. It is hard to believe in a bank without PK. I really think they forgot to pass me the script. Thus, the solution of the problem in another post, It will be solved, so I hope.
Was a database DER made? It is very recommended.
– Renato Junior
@Rorschach, like I said, I don’t have access to anything in this bank. My App that I am creating, they passed me the script of the three tables that will be used and nothing else. I don’t work inside the company, I’m 300 miles away from them, so I don’t know much about the bank. I can’t tell you anything in this bank.I created one for myself, added the tables(3) and I see it. Here yes, I can do whatever I want, you know. I’ll create a PK, with Identity and see what happens.
– pnet