System.InvalidOperationException:空值用作实体的标识符 [英] System.InvalidOperationException: A null value was used as an Identifier for Entity

问题描述

大家好.

我通过SQL Server数据库在Sharepoint Designer 2013中创建了一个外部列表. Sharepoint Designer的外部内容类型中发生此错误.

I created a external List in Sharepoint Designer 2013 from a SQL server database. This error was occured in the external content type in Sharepoint Designer.

数据库只有一个表，并且ID不为null.一些列可能具有空值，因为该数据库是从旧的MS Access数据库中导入的.

The database has just one table and the id is not null. Some collumns could has null values, because this database was imported from a old MS Access database. 

有人对如何解决这个问题有任何想法或建议吗?

Someone has any idea or suggestion how to solve this?

非常感谢您.

此致

João

推荐答案

您是如何创建外部列表的?

How did you create the external list?

能否提供有关创建外部列表的步骤的屏幕截图?

Can you provide the screenshot about the steps that you created the external list?

如果您要创建外部列表，则您的SQL表中不能包含任何空值，因此请在可能具有空值或在操作中排除该列的任何字段中放置一个占位符.

If you want to create the external list, your SQL table can not have any null values in it, so put a placeholder in any field that might have a null value or exclude the column from your operations.

这是关于类似情况的参考.

This is a reference about a similar case.

最好的问候，

周卡尔

这篇关于System.InvalidOperationException:空值用作实体的标识符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！