Trouble getting this basic sample set up
Trouble getting this basic sample set up
My tables are like so:
User
---------
Id (type string, primary key)
Professional
--------------------
Id (int, primary key)
UserId (string, foreign key references User.Id)
Field 1 (string)
Field 2 (string)
Field 3 (date time)
I am designing an HTML page to perform CRUD operations on the Professional table.
My question specifically is, what changes should I make to the editor options and the datatable options in order to:
1) Not display the Id
and the UserId
fields of the Professional table in the user interface;
2) But the values of these fields must be passed back and forth between the client and my ASP.NET MVC web application;
3) How do I tell editor or the datatable about the primary key and foreign key relationships so it maintains referential integrity?