The following data type properties of column do not match those of Data type, length, precision.
Initially I want to apply the foreign key for Student table .But the error occurred. Because of variation in data type. I got the following error “The following data type properties of the column do not match those of Data type, length, precision”
Solution:
I used int data type for department table. But in foreign I used smallint data type. So I changed both of them into int data type. Finally I successfully saved the table.
Post your comments / questions
Recent Article
- How to create autocomplete textbox search using asp .net MVC c# application.
- How to add @media query in asp.net mvc razor view page I am getting syntax clashes?
- How to make youtube video responsive for website?
- SOLVED-Bootstrap 3 Glyphicons are not working
- Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
- Unable to update the EntitySet 'table' because it has DefiningQuery and no DeleteFunction element exists in the ModificationFunctionMapping
- How to save the web page’s content and save into a string variable in c#?
- The model item passed into the dictionary is of type System.Linq.OrderedEnumerable but this dictionary requires a model item of type System.Collections.Generic.IList
Related Article