Reference data from views in breeze -


We have a table (presence type) in our database that has multiple choice multiple fields. These multiple options are defined in a single table. Therefore, instead of creating separate option tables for each option, we have a table (Option_Data) to identify each option type (record). Example: The appearance type table has the following fields

  • ID
  • Description
  • Category (payroll / cache)
  • Type (Hours / Day)
  • Mode (Working Hours / Overtime / Extra Horse)
  • Operation (Add / Decrease)
< P> These are the options of the field (data shown above in the bracket), which comes from Option_data table. We have different ideas from this Option_data table example: vwOption_Attendance_Mode, vwOption_Attendance_Operation etc.

Now, how can we add this scene to the air so that the reference data will be automatically returned.

We are using EF 6, SQL Server, SPN Net WebAP, when the table relation is defined in SQL Server, Breeze works perfectly and manages relational data. In this case we can not define relationships between SQL Server and SQL Server.

How can we code it, can air manage relational / reference data for us? If you need further clarification, please let me know.

Edit the @JT Trades: Suppose that there are fields in a table (i.e.: appearance type), which receive views / reference data of its area from the scenes. How can we relate to them in the air (table with scenes), as we can not do in SQL Server, my reference point is when the air related to the tables works excellent I get the same with tables and scenes Want to

Winds about the relationship between tables and ideas from its metadata (including relations between institutions) from EF In case you have to tell EF, even if there is no such connection between SQL Server. Provides some clues, and gives some relevant information about the relationship in the designer.


Comments

Post a Comment