Jei norite sukurti indeksą ir pagreitinti užklausą, pridėkite atributą [Index] prie atributo ir automatiškai sugeneruokite kodą taip:
Mes atnaujiname duomenų bazės duomenų bazę ir klaida yra tokia:
System.Data.SqlClient.SqlException (0x80131904): lentelė 'dbo. Stulpelis "Telefonas" dalyje "Paskyra" negali būti naudojamas kaip pagrindinis indekso stulpelis.
System.Data.SqlClient.SqlConnection.OnError(SqlException išimtis, Bulio logikos pertraukaConnection, Action'1 wrapCloseInAction)
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException išimtis, Bulio logikos pertraukaConnection, veiksmas'1 wrapCloseInAction)
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Bulio logika skambintojasHasConnectionLock, Bulio logika asyncClose)
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Bulio logikos asinchroninis, Int32 skirtasis laikas, Bulio logikos asyncWrite)
In System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource'1 completion, String methodName, Bulio logikos sendToPipe, Int32 skirtasis laikas, Bulio logika & usedCache, Bulio logika asyncWrite, Bulio logikos inRetry)
In System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
In System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher. <NonQuery>b__0(DbCommand t, DbCommandInterceptionContext'1 c)
System.Data.Entity.Infrastructure.Interception.InternalDispatcher'1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget tikslas, Func'3 operacija, TInterceptionContext interceptionContext, Veiksmas'3 vykdomas, Veiksmas'3 įvykdytas)
System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand komanda, DbCommandInterceptionContext interceptionContext)
In System.Data.Entity.Internal.InterceptableDbCommand.ExecuteNonQuery()
System.Data.Entity.Migrations.DbMigrator.ExecuteSql(MigrationStatement migrationStatement, DbConnection ryšys, DbTransaction operacija, DbInterceptionContext interceptionContext)
System.Data.Entity.Migrations.Infrastructure.MigratorLoggingDecorator.ExecuteSql(MigrationStatement migrationStatement, DbConnection connection, DbTransaction transaction , DbInterceptionContext interceptionContext)
System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsInternal(IEnumerable'1 migrationStatements, DbConnection ryšys, DbTransaction operacija, DbInterceptionContext interceptionContext)
In System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsWithinTransaction(IEnumerable'1 migrationStatements, DbTransaction transaction, DbInterceptionContext interceptionContext)
In System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsWithinNewTransaction(IEnumerable'1 migrationStatements, DbConnection connection, DbInterceptionContext interceptionContext)
System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsInternal(IEnumerable'1 migrationStatements, DbConnection connection, DbInterceptionContext interceptionContext)
System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsInternal(IEnumerable'1 migrationStatements, DbConnection connection)
adresu System.Data.Entity.Migrations.DbMigrator.<>c__DisplayClass32. <ExecuteStatements>b__30()
In System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.<>c__DisplayClass1. <Execute>b__0()
System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func'1 operacija)
System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute(veiksmo operacija)
System.Data.Entity.Migrations.DbMigrator.ExecuteStatements(IEnumerable'1 migrationStatements, DbTransaction existingTransaction)
System.Data.Entity.Migrations.DbMigrator.ExecuteStatements(IEnumerable'1 migrationStatements)
System.Data.Entity.Migrations.Infrastructure.MigratorBase.ExecuteStatements(IEnumerable'1 migrationStatements)
System.Data.Entity.Migrations.DbMigrator.ExecuteOperations(String migrationId, VersionedModel targetModel, IEnumerable'1 operations, IEnumerable'1 systemOperations, Bulio logika pažeminimas, Bulio automatinis)
System.Data.Entity.Migrations.DbMigrator.ApplyMigration(DbMigration migration, DbMigration lastMigration)
System.Data.Entity.Migrations.Infrastructure.MigratorLoggingDecorator.ApplyMigration(DbMigration migration, DbMigration lastMigration)
System.Data.Entity.Migrations.DbMigrator.Upgrade(IEnumerable'1 pendingMigrations, String targetMigrationId, String lastMigrationId)
System.Data.Entity.Migrations.Infrastructure.MigratorLoggingDecorator.Upgrade(IEnumerable'1 pendingMigrations, String targetMigrationId, String lastMigrationId)
System.Data.Entity.Migrations.DbMigrator.UpdateInternal(String targetMigration)
In System.Data.Entity.Migrations.DbMigrator.<>c__DisplayClasse. <Update>b__d()
System.Data.Entity.Migrations.DbMigrator.EnsureDatabaseExists(Action mustSucceedToKeepDatabase)
System.Data.Entity.Migrations.Infrastructure.MigratorBase.EnsureDatabaseExists(Action mustSucceedToKeepDatabase)
System.Data.Entity.Migrations.DbMigrator.Update(String targetMigration)
System.Data.Entity.Migrations.Infrastructure.MigratorBase.Update(String targetMigration)
System.Data.Entity.Migrations.Design.ToolingFacade.UpdateRunner.RunCore()
In System.Data.Entity.Migrations.Design.ToolingFacade.BaseRunner.Run()
ClientConnectionId:2b5f614b-caab-4be6-bc1b-a813b7356739
Klaidos numeris: 1919, valstija: 1, klasė: 16
Lentelė 'dbo. Stulpelis "Telefonas" dalyje "Paskyra" negali būti naudojamas kaip pagrindinis indekso stulpelis.
Klaidos priežastis yra ta, kad visos ef eilutės ypatybės pagal numatytuosius nustatymus yra NVARCHAR(Max) tipo,
Sprendimas yra toks:
Vykdykite eilutės ilgį
Kaip parodyta paveikslėlyje, kūrimas sėkmingas!
|
Paskelbta 2017-11-23 18:47:15
|
|
|
|
