传递价值在SQL null值的列 [英] passing value to the null value column in Sql

问题描述

我有一个部分表，该表中我有列SectionId，CourseId，名称，容量....这里的CourseId是一个空值列及其FOREIGNKEY这里侧重的Cousrse表....这CourseId列是新增加的。

I have a Sections table and in that table I have columns SectionId,CourseId,Name,Capacity....here the CourseId is a null value column and its the Foreignkey here which focuses the Cousrse table....this CourseId column is a newly added one.

我试图将记录添加到这个表，我使用实体框架，在Entiry框架的显示除了这CourseId所有列名，当我送DATAS本节表中的所有DATAS当然除了ID存储罚款... courseId的值存储为空...

I am trying to add records to this table, am using entity framework, in the Entiry framework its showing all the column names except this CourseId, and when I send the datas to this Sections table all the datas except Course Id are stored fine...the value of courseId is stored as Null...

我怎么能传递CourseId此列......谁能帮助我在这里

how can I pass the CourseId to this column......can anyone help me here

推荐答案

如果EF没有显示你的专栏，你可能需要刷新你的模型。从那里开始。

If EF is not showing your column, you may need to refresh your model. Start there.

1. 打开您的.edmx文件


2. 右键单击设计图面


3. 选择更新模型从数据库


4. 按照说明进行操作。

这篇关于传递价值在SQL null值的列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！