enter image description here

There is a table with users (where their credentials), is with info about users. It is necessary that the fields Email and UserName be common for them, i.e. mirror. I am trying to connect the Id of the first and the Id of the second, the linking rule is a cascade. After that, I get this error ((How can I link differently?

  • 2
    Your column types are different. - sp7

1 answer 1

Your Id data type is different ( navchar and int ), must be the same

  • Thank you very much, earned. I have one more question, if it will not be difficult: I put the same types and connected them, but after linking in the second table, the instances from the first did not appear. Just empty places. How to get a reference? Probably need to run some refresh, or something like that? - R. Matveev
  • They will not be duplicated, moreover, you do not need to duplicate columns (If this is not a necessary requirement of the system). To get say, email from the second table, when prompted, you need to use the JOIN and the data from the second table will be added to the first in the answer. - Powar
  • No, of course, do not duplicate, I need exactly the reflection, i.e. something like a reference to the first table. I, unfortunately, cannot use standard SQL queries, since Everything must be done through the Entity Framework. I do not know whether it is possible to make a mirror reference or not, but I remember exactly what I saw on MS Access, so I ask. - R. Matveev
  • I am sure that it has a join () method or something similar. Try searching for information on how to use join in this framework, I unfortunately can not help you with it. - Powar