我有一个问题插入一行使用实体框架与MySQL连接器/。NET 6.4.4。当我尝试在添加一行后保存更改时,我得到了一个系统。
at MySql.Data.Entity.SqlGenerator.GenerateReturningSql(DbModificationCommandTree tree, DbExpression returning)
at MySql.Data.Entity.UpdateGenerator.GenerateSQL(DbCommandTree tree)
at MySql.Data.MySqlClient.MySqlProviderServices.CreateDbCommandDefinition(DbProviderManifest providerManifest, DbCommandTree commandTree)
at System.Data.Common.DbProviderServices.CreateCommandDefinition(DbCommandTree commandTree)
at System.Data.Common.DbProviderServices.CreateCommand(DbCommandTree commandTree)
at System.Data.Mapping.Update.Internal.UpdateTranslator.CreateCommand(DbModificationCommandTree commandTree)
at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.CreateCommand(UpdateTranslator translator, Dictionary`2 identifierValues)
at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues)
at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)
at System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache)
at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options)
at System.Data.Entity.Internal.InternalContext.SaveChanges()
at System.Data.Entity.Internal.LazyInternalContext.SaveChanges()
at System.Data.Entity.DbContext.SaveChanges()
at UserData.Repository.DBRepositoryDataContext.SaveChanges() in C:SoftwareProjectsJavaDegooServerUserDataRepositoryDBRepositoryDataContext.cs:line 42
at UserData.Repository.Repository.<SaveChanges>b__1() in C:SoftwareProjectsJavaDegooServerUserDataRepositoryRepository.cs:line 137
at Microsoft.AppFabricCAT.Samples.Azure.TransientFaultHandling.RetryPolicy`1.ExecuteAction(Action action) in C:SoftwareProjectsJavaDegooServerLibrariesTransientFaultHandlingFrameworkRetryPolicy.cs:line 352
我使用EF 4.1与"代码优先"。换句话说:我使用DbSet和DbContext。
这就是我想添加的实体在EF的变化跟踪器中的样子:
System.Data.Entity.Infrastructure.DbEntityEntry<Utilities.IStandardEntity>
_internalEntityEntry System.Data.Entity.Internal.InternalEntityEntry
CurrentValues System.Data.Entity.Infrastructure.DbPropertyValues
Entity UserData.PerformanceCounterEntities.PerformanceCounterEntity
CallingClassName "com.degoo.tests.integration.PerformanceCounterUploaderTest" string
Category {System.Data.Entity.DynamicProxies.TextEntity_27BF3732ED645CE792F48B4AA75BFD05C10C0AE9C5B35779176C02A53A587F1A} UserData.PerformanceCounterEntities.TextEntity {System.Data.Entity.DynamicProxies.TextEntity_27BF3732ED645CE792F48B4AA75BFD05C10C0AE9C5B35779176C02A53A587F1A}
CategoryTextID 1 long
CreationTime {2011-11-09 09:32:12} System.DateTime
Description {System.Data.Entity.DynamicProxies.TextEntity_27BF3732ED645CE792F48B4AA75BFD05C10C0AE9C5B35779176C02A53A587F1A} UserData.PerformanceCounterEntities.TextEntity {System.Data.Entity.DynamicProxies.TextEntity_27BF3732ED645CE792F48B4AA75BFD05C10C0AE9C5B35779176C02A53A587F1A}
DescriptionTextID 3 long
ID 0 long
ModificationTime {2011-11-09 09:32:12} System.DateTime
Name {System.Data.Entity.DynamicProxies.TextEntity_27BF3732ED645CE792F48B4AA75BFD05C10C0AE9C5B35779176C02A53A587F1A} UserData.PerformanceCounterEntities.TextEntity {System.Data.Entity.DynamicProxies.TextEntity_27BF3732ED645CE792F48B4AA75BFD05C10C0AE9C5B35779176C02A53A587F1A}
NameTextID 2 long
NodeID 16485 long
NumberOfSamples 1 long
RowVersion 0 long
Value 1.0 double
你知道是什么原因造成的吗?这看起来像是MySQL的ef驱动程序中的一个错误(至少他们应该更新然后提供更好的错误消息)。
我有一个类似的问题,使用相同的连接器驱动程序。在我的例子中,其中一个对象使用了属性而不是属性。
public class User : ProjectBasicEntity
{
public string SomeColumn;
}
不是public class User : ProjectBasicEntity
{
public string SomeColumn { get; set;}
}
我想有人真的需要改进这些驱动程序的错误处理…