Advertisement
geniusvil

Mistake

Aug 27th, 2014
240
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.29 KB | None | 0 0
  1.  
  2. Unhandled Exception: System.Data.SqlClient.SqlException: Introducing FOREIGN KEY constraint 'FK_dbo.Homework_dbo.Courses_CourseID' on table 'Homework
  3. may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
  4. Could not create constraint or index. See previous errors.
  5. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
  6. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
  7. at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
  8. at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCo
  9. yHandler, TdsParserStateObject stateObj, Boolean& dataReady)
  10. at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
  11. at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeou
  12. , Boolean asyncWrite)
  13. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
  14. at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<NonQuery>b__0(DbCommand t, DbCommandInterceptionContext`1 c)
  15. at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 opera
  16. ion, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
  17. at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext
  18.  
  19. at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteNonQuery()
  20. at System.Data.Entity.Migrations.DbMigrator.ExecuteSql(DbTransaction transaction, MigrationStatement migrationStatement, DbInterceptionContext int
  21. rceptionContext)
  22. at System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsInternal(IEnumerable`1 migrationStatements, DbTransaction transaction, DbInterception
  23. ontext interceptionContext)
  24. at System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsInternal(IEnumerable`1 migrationStatements, DbConnection connection)
  25. at System.Data.Entity.Migrations.DbMigrator.<>c__DisplayClass30.<ExecuteStatements>b__2e()
  26. at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.<>c__DisplayClass1.<Execute>b__0()
  27. at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)
  28. at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute(Action operation)
  29. at System.Data.Entity.Migrations.DbMigrator.ExecuteStatements(IEnumerable`1 migrationStatements, DbTransaction existingTransaction)
  30. at System.Data.Entity.Migrations.DbMigrator.ExecuteStatements(IEnumerable`1 migrationStatements)
  31. at System.Data.Entity.Migrations.DbMigrator.ExecuteOperations(String migrationId, XDocument targetModel, IEnumerable`1 operations, IEnumerable`1 s
  32. stemOperations, Boolean downgrading, Boolean auto)
  33. at System.Data.Entity.Migrations.DbMigrator.AutoMigrate(String migrationId, VersionedModel sourceModel, VersionedModel targetModel, Boolean downgr
  34. ding)
  35. at System.Data.Entity.Migrations.DbMigrator.Upgrade(IEnumerable`1 pendingMigrations, String targetMigrationId, String lastMigrationId)
  36. at System.Data.Entity.Migrations.DbMigrator.UpdateInternal(String targetMigration)
  37. at System.Data.Entity.Migrations.DbMigrator.<>c__DisplayClassc.<Update>b__b()
  38. at System.Data.Entity.Migrations.DbMigrator.EnsureDatabaseExists(Action mustSucceedToKeepDatabase)
  39. at System.Data.Entity.Migrations.DbMigrator.Update(String targetMigration)
  40. at System.Data.Entity.MigrateDatabaseToLatestVersion`2.InitializeDatabase(TContext context)
  41. at System.Data.Entity.Internal.InternalContext.<>c__DisplayClassf`1.<CreateInitializationAction>b__e()
  42. at System.Data.Entity.Internal.InternalContext.PerformInitializationAction(Action action)
  43. at System.Data.Entity.Internal.InternalContext.PerformDatabaseInitialization()
  44. at System.Data.Entity.Internal.LazyInternalContext.<InitializeDatabase>b__4(InternalContext c)
  45. at System.Data.Entity.Internal.RetryAction`1.PerformAction(TInput input)
  46. at System.Data.Entity.Internal.LazyInternalContext.InitializeDatabaseAction(Action`1 action)
  47. at System.Data.Entity.Internal.LazyInternalContext.InitializeDatabase()
  48. at System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType)
  49. at System.Data.Entity.Internal.Linq.InternalSet`1.Initialize()
  50. at System.Data.Entity.Internal.Linq.InternalSet`1.get_InternalContext()
  51. at System.Data.Entity.Internal.Linq.InternalSet`1.ActOnSet(Action action, EntityState newState, Object entity, String methodName)
  52. at System.Data.Entity.Internal.Linq.InternalSet`1.Add(Object entity)
  53. at System.Data.Entity.DbSet`1.Add(TEntity entity)
  54. at University.Client.Program.FillSomeData() in c:\MyStaff\11.DataBase\HOMEWORK\09.Homework-CodeFirst\University.Client\Program.cs:line 57
  55. at University.Client.Program.Main(String[] args) in c:\MyStaff\11.DataBase\HOMEWORK\09.Homework-CodeFirst\University.Client\Program.cs:line 22
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement