Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. FIX: Unexpected data entry or data corruption might occur when a Visual Studio 2010 SP1 ADO.NET application changes data in the StoreGeneratedPattern attribute

FIX: Unexpected data entry or data corruption might occur when a Visual Studio 2010 SP1 ADO.NET application changes data in the StoreGeneratedPattern attribute

Symptoms

Issue 1

Consider the following scenario:
  • You add an ADO.NET entity data model that is generated from a database in a Microsoft Visual Studio 2010 Service Pack 1 (SP1) project.
  • You use Entity Designer to change the StoreGeneratedPattern attribute for an entity key property to Identity or Computed.
  • You try to change data through the application.

In this scenario, an unexpected data entry or data corruption might occur in the corresponding database table column. 

Note When this issue occurs, the conceptual schema definition language (CSDL) section of the .edmx file contains the new value for the attribute and the store schema definition language (SSDL) section contains the old value.

Issue 2

Consider the following scenario:
  • You have an ADO.NET project in Visual Studio 2010 SP1.
  • A StoreGeneratedPattern attribute in the SSDL section of an .edmx file for the project differs from the StoreGeneratedPattern attribute in the CSDL section.
  • You manually edit the attribute in the SSDL section to match the attribute in the CSDL section.
  • You perform the Update Model from Database operation.
  • You try to change data through the application.
In this scenario, an unexpected data entry or data corruption might occur in the affected table column of the database.

Note When the Update Model from Database operation is performed, the value of the StoreGeneratedPattern attribute in the SSDL is overwritten.

↑ Back to the top

Cause

These issues occur because the StoreGeneratedPattern attribute in the store schema definition language (SSDL) section is not updated.

When the StoreGeneratedPattern attribute in the conceptual schema definition language (CSDL) section of the .edmx file is set, the attribute is not updated in the store schema definition language (SSDL) section. Therefore, the issues that are mentioned in the "Symptoms" section occur.

↑ Back to the top

Resolution

After you install this hotfix, Entity Designer updates the StoreGeneratedPattern attribute for an entity key property in the CSDL and SSDL sections of the .edmx file correctly.

Note By design, the StoreGeneratedPattern attribute is not copied from the CSDL section to the SSDL section in the following situations:
  • The property of SSDL represents the storage for a key column of a Table-per-Type inheritance hierarchy that is of a non-root entity type.
  • The property of SSDL represents a key column on the dependent end of an association.

Hotfix information

A supported hotfix is now available from Microsoft. However, it is intended to correct only the problem that this article describes. Apply it only to systems that are experiencing this specific problem.

To resolve this problem, contact Microsoft Customer Support Services to obtain the hotfix. For a complete list of Microsoft Customer Support Services telephone numbers and information about support costs, visit the following Microsoft website:
http://support.microsoft.com/contactus/?ws=support
Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

Prerequisites

To apply this hotfix, you must have Visual Studio 2010 SP1 installed.

Restart requirement

You do not have to restart the computer after you apply this hotfix. 

We recommend that you close all instances of Visual Studio before you install this hotfix.

File information

The global version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

File nameFile versionFile sizeDateTimePlatform
Microsoft.data.entity.design.dll10.0.40219.3351,832,82419-Jul-201108:25x86


↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top

Keywords: kbqfe, kbhotfixserver, kbfix, kbexpertiseadvanced, kbhotfixdev, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2561001
Revision : 2
Created on : 9/21/2018
Published on : 9/21/2018
Exists online : False
Views : 127