Error number 207 state 1 class 16

I am using Asp .netcore 2.0 on Visual Studio 15.7.4 and Its in app Identity system.
According to this post in order to add new profile data all I need to do is to add it inside ApplicationUsers.cs and the add migration and update database. Migration works fine before adding the new property but fails after it with the error below.
Adding Property:

namespace WebApplication6.Models
{
    // Add profile data for application users by adding properties to the ApplicationUser class
    public class ApplicationUser : IdentityUser
    {
        public Int64 Contact { get; set; }
    }

}

There is a Invalid column name 'Contact' inside the error, do I have to add it anywhere else?
The Error:

PM> add-migration "Contact"
Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager[0]
      User profile is available. Using 'C:UsersURAppDataLocalASP.NETDataProtection-Keys' as key repository and Windows DPAPI to encrypt keys at rest.
Microsoft.EntityFrameworkCore.Infrastructure[10403]
      Entity Framework Core 2.0.3-rtm-10026 initialized 'ApplicationDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (175ms) [Parameters=[@__normalizedName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [r].[Id], [r].[ConcurrencyStamp], [r].[Name], [r].[NormalizedName]
      FROM [AspNetRoles] AS [r]
      WHERE [r].[NormalizedName] = @__normalizedName_0
fail: Microsoft.EntityFrameworkCore.Database.Command[20102]
      Failed executing DbCommand (202ms) [Parameters=[@__normalizedEmail_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [u].[Id], [u].[AccessFailedCount], [u].[ConcurrencyStamp], [u].[Contact], [u].[Email], [u].[EmailConfirmed], [u].[LockoutEnabled], [u].[LockoutEnd], [u].[NormalizedEmail], [u].[NormalizedUserName], [u].[PasswordHash], [u].[PhoneNumber], [u].[PhoneNumberConfirmed], [u].[SecurityStamp], [u].[TwoFactorEnabled], [u].[UserName]
      FROM [AspNetUsers] AS [u]
      WHERE [u].[NormalizedEmail] = @__normalizedEmail_0
System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'Contact'.
   at System.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__108_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.<ExecuteAsync>d__17.MoveNext()
ClientConnectionId:483a79cf-66d7-429e-86ff-1685217e9265
Error Number:207,State:1,Class:16
fail: Microsoft.EntityFrameworkCore.Query[10100]
      An exception occurred in the database while iterating the results of a query for context type 'WebApplication6.Data.ApplicationDbContext'.
      System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'Contact'.
         at System.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__108_0(Task`1 result)
         at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
         at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
         at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
      --- End of stack trace from previous location where exception was thrown ---
         at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
         at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
         at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
         at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.<ExecuteAsync>d__17.MoveNext()
      --- End of stack trace from previous location where exception was thrown ---
         at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
         at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
         at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
         at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.<BufferlessMoveNext>d__10.MoveNext()
      --- End of stack trace from previous location where exception was thrown ---
         at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
         at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
         at Microsoft.EntityFrameworkCore.Storage.Internal.SqlServerExecutionStrategy.<ExecuteAsync>d__7`2.MoveNext()
      --- End of stack trace from previous location where exception was thrown ---
         at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
         at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
         at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
         at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.<MoveNext>d__9.MoveNext()
      --- End of stack trace from previous location where exception was thrown ---
         at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
         at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
         at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
         at System.Linq.AsyncEnumerable.<FirstOrDefault_>d__165`1.MoveNext()
      --- End of stack trace from previous location where exception was thrown ---
         at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
         at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
         at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
         at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.TaskResultAsyncEnumerable`1.Enumerator.<MoveNext>d__3.MoveNext()
      --- End of stack trace from previous location where exception was thrown ---
         at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
         at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
         at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
         at System.Linq.AsyncEnumerable.SelectEnumerableAsyncIterator`2.<MoveNextCore>d__7.MoveNext()
      --- End of stack trace from previous location where exception was thrown ---
         at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
         at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
         at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
         at System.Linq.AsyncEnumerable.AsyncIterator`1.<MoveNext>d__10.MoveNext()
      --- End of stack trace from previous location where exception was thrown ---
         at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
         at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
         at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
         at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.ExceptionInterceptor`1.EnumeratorExceptionInterceptor.<MoveNext>d__5.MoveNext()
      ClientConnectionId:483a79cf-66d7-429e-86ff-1685217e9265
      Error Number:207,State:1,Class:16
System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'Contact'.
   at System.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__108_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.<ExecuteAsync>d__17.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.<BufferlessMoveNext>d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.EntityFrameworkCore.Storage.Internal.SqlServerExecutionStrategy.<ExecuteAsync>d__7`2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.<MoveNext>d__9.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
   at System.Linq.AsyncEnumerable.<FirstOrDefault_>d__165`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.TaskResultAsyncEnumerable`1.Enumerator.<MoveNext>d__3.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
   at System.Linq.AsyncEnumerable.SelectEnumerableAsyncIterator`2.<MoveNextCore>d__7.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
   at System.Linq.AsyncEnumerable.AsyncIterator`1.<MoveNext>d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.ExceptionInterceptor`1.EnumeratorExceptionInterceptor.<MoveNext>d__5.MoveNext()
ClientConnectionId:483a79cf-66d7-429e-86ff-1685217e9265
Error Number:207,State:1,Class:16
Application startup exception: System.AggregateException: One or more errors occurred. (Invalid column name 'Contact'.) ---> System.Data.SqlClient.SqlException: Invalid column name 'Contact'.
   at System.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__108_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.<ExecuteAsync>d__17.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.<BufferlessMoveNext>d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.EntityFrameworkCore.Storage.Internal.SqlServerExecutionStrategy.<ExecuteAsync>d__7`2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.<MoveNext>d__9.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
   at System.Linq.AsyncEnumerable.<FirstOrDefault_>d__165`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.TaskResultAsyncEnumerable`1.Enumerator.<MoveNext>d__3.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
   at System.Linq.AsyncEnumerable.SelectEnumerableAsyncIterator`2.<MoveNextCore>d__7.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
   at System.Linq.AsyncEnumerable.AsyncIterator`1.<MoveNext>d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.ExceptionInterceptor`1.EnumeratorExceptionInterceptor.<MoveNext>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.<ExecuteSingletonAsyncQuery>d__23`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at WebApplication6.Startup.<CreateUserRoles>d__1.MoveNext() in C:UsersURsourcereposWebApplication6WebApplication6Startup.cs:line 38
   --- End of inner exception stack trace ---
   at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
   at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
   at System.Threading.Tasks.Task.Wait()
   at WebApplication6.Startup.Configure(IApplicationBuilder app, IHostingEnvironment env, IServiceProvider services) in C:UsersURsourcereposWebApplication6WebApplication6Startup.cs:line 114
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Microsoft.AspNetCore.Hosting.ConventionBasedStartup.Configure(IApplicationBuilder app)
   at Microsoft.AspNetCore.Hosting.Internal.AutoRequestServicesStartupFilter.<>c__DisplayClass0_0.<Configure>b__0(IApplicationBuilder builder)
   at Microsoft.AspNetCore.Hosting.Internal.WebHost.BuildApplication()
---> (Inner Exception #0) System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'Contact'.
   at System.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__108_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.<ExecuteAsync>d__17.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.<BufferlessMoveNext>d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.EntityFrameworkCore.Storage.Internal.SqlServerExecutionStrategy.<ExecuteAsync>d__7`2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.<MoveNext>d__9.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
   at System.Linq.AsyncEnumerable.<FirstOrDefault_>d__165`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.TaskResultAsyncEnumerable`1.Enumerator.<MoveNext>d__3.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
   at System.Linq.AsyncEnumerable.SelectEnumerableAsyncIterator`2.<MoveNextCore>d__7.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
   at System.Linq.AsyncEnumerable.AsyncIterator`1.<MoveNext>d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.ExceptionInterceptor`1.EnumeratorExceptionInterceptor.<MoveNext>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.<ExecuteSingletonAsyncQuery>d__23`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at WebApplication6.Startup.<CreateUserRoles>d__1.MoveNext() in C:UsersURsourcereposWebApplication6WebApplication6Startup.cs:line 38
ClientConnectionId:483a79cf-66d7-429e-86ff-1685217e9265
Error Number:207,State:1,Class:16<---

My .csproj file just in case:

<Project Sdk="Microsoft.NET.Sdk.Web">

  <PropertyGroup>
    <TargetFramework>netcoreapp2.0</TargetFramework>
    <UserSecretsId>aspnet-WebApplication6-32ACCB41-2BB0-426F-BD8D-B363DADD5CB0</UserSecretsId>
  </PropertyGroup>


  <ItemGroup>
    <PackageReference Include="Microsoft.AspNetCore.All" Version="2.0.8" />
    <PackageReference Include="Microsoft.EntityFrameworkCore.Tools" Version="2.0.3" PrivateAssets="All" />
    <PackageReference Include="Microsoft.VisualStudio.Web.CodeGeneration.Design" Version="2.0.4" PrivateAssets="All" />
  </ItemGroup>

  <ItemGroup>
    <DotNetCliToolReference Include="Microsoft.EntityFrameworkCore.Tools.DotNet" Version="2.0.3" />
    <DotNetCliToolReference Include="Microsoft.Extensions.SecretManager.Tools" Version="2.0.2" />
    <DotNetCliToolReference Include="Microsoft.VisualStudio.Web.CodeGeneration.Tools" Version="2.0.4" />
  </ItemGroup>

</Project>

Hello,

I’m getting the following errors when SQL-NS instance fires my rule:

Description: The running of the rule failed. Please check the rule.
EventParameters:
  Application Name: Messages
  Quantum ID: 30040
  Rule Firing ID: 21218
  Rule Name: MessageEventRule
  Notification Throttle: 1000
  Event Class ID: 1
  Subscription Class ID: 1
  Rule ID: 2
  Rule Action: EXEC stp_Insert_Message_Alerts
  Stored Procedure Name: [dbo].[NSFire2]

SqlServerError:
  Error Number: 0
  Source: .Net SqlClient Data Provider
  Number: 207
  State: 1
  Class: 16
  Server: NOCMON-DEV
  Message: Invalid column name 'Date'.
  Procedure: 
  Line Number: 16

  Error Number: 1
  Source: .Net SqlClient Data Provider
  Number: 207
  State: 1
  Class: 16
  Server: NOCMON-DEV
  Message: Invalid column name 'Date'.
  Procedure: 
  Line Number: 16

Description: Invalid column name 'Date'.
Invalid column name 'Date'.
InstanceName: NOCMon
ApplicationName: Messages
Component: Generator
Thread: 4


For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

My ADF looks like this:

<?xml version="1.0" encoding="utf-8" ?>
<Application xmlns:xsd="http://www.w3.org/2001/XMLSchema" 
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
  xmlns="http://www.microsoft.com/MicrosoftNotificationServices/ApplicationDefinitionFileSchema">

  <!-- Version -->

  <!-- Database Definition -->

  <!-- Event Classes -->
  <EventClasses>
    <EventClass>
      <EventClassName>NOCMonMessageEvents</EventClassName>
      <Schema>
        <Field>
          <FieldName>SourceID</FieldName>
          <FieldType>int</FieldType>
        </Field>
		<Field>
		  <FieldName>ErrorCategoryID</FieldName>
		  <FieldType>int</FieldType>
		</Field>
        <Field>
          <FieldName>Date</FieldName>
          <FieldType>datetime</FieldType>
        </Field>
        <Field>
          <FieldName>Station</FieldName>
          <FieldType>nvarchar(50)</FieldType>
        </Field>
        <Field>
          <FieldName>Message</FieldName>
          <FieldType>nvarchar(max)</FieldType>
        </Field>
        <Field>
          <FieldName>StatusID</FieldName>
          <FieldType>int</FieldType>
        </Field>
		<Field>
		  <FieldName>nUser</FieldName>
		  <FieldType>nvarchar(50)</FieldType>
		</Field>
		<Field>
		  <FieldName>nSubject</FieldName>
		  <FieldType>nvarchar(max)</FieldType>
		</Field>
      </Schema>
      <IndexSqlSchema>
        <SqlStatement>
			CREATE INDEX myIndex
			ON NOCMonMessageEvents ( SourceID );
		</SqlStatement>
      </IndexSqlSchema>
		<Chronicles>
			<Chronicle>
				<ChronicleName>NOCMonMessageEventsChronicle</ChronicleName>
				<SqlSchema>
					<SqlStatement>
						IF EXISTS(SELECT name FROM dbo.sysobjects WHERE name = 'NOCMonMessageEventsChronicle')
						DROP TABLE dbo.NOCMonMessageEventsChronicle
						CREATE TABLE NOCMonMessageEventsChronicle
						( [SourceID] int,
						[ErrorCategoryID] int,
						[Date] DateTime,
						[Station] nvarchar(50),
						[Message] nvarchar(max),
						[StatusID] int,
						[nUser] nvarchar(50),
						[nSubject] nvarchar(max))
					</SqlStatement>
				</SqlSchema>
			</Chronicle>
		</Chronicles>
		<ChronicleRule>
			<RuleName>NOCMonMessageEventsChronicleRule</RuleName>
			<Action>
				INSERT INTO NOCMonMessageEventsChronicle (SourceID, ErrorCategoryID, Date, Station, Message, StatusID, [nUser], nSubject)
				SELECT	E.SourceID, E.ErrorCategoryID, E.Date, E.Station, E.Message, E.StatusID, E.[nUser], E.nSubject
				FROM	NOCMonMessageEvents E
			</Action>
			<ActionTimeout>PT10M</ActionTimeout>
		</ChronicleRule>
    </EventClass>
  </EventClasses>

  <!-- Subscription Classes -->
  <SubscriptionClasses>
    <SubscriptionClass>
      <SubscriptionClassName>NOCMonMessageEventSubscription</SubscriptionClassName>
      <Schema>
        <Field>
          <FieldName>DeviceName</FieldName>
          <FieldType>nvarchar(255)</FieldType>
        </Field>
        <Field>
          <FieldName>SubscriberLocale</FieldName>
          <FieldType>nvarchar(10)</FieldType>
        </Field>
		  <Field>
			  <FieldName>SourceID</FieldName>
			  <FieldType>int</FieldType>
		  </Field>
		  <Field>
			  <FieldName>ErrorCategoryID</FieldName>
			  <FieldType>int</FieldType>
		  </Field>
		  <Field>
			  <FieldName>Station</FieldName>
			  <FieldType>nvarchar(50)</FieldType>
		  </Field>
		<Field>
		  <FieldName>Description</FieldName>
		  <FieldType>nvarchar(max)</FieldType>
		</Field>
		  <Field>
			  <FieldName>Threshold</FieldName>
			  <FieldType>int</FieldType>
		  </Field>
		  <Field>
			  <FieldName>TimeOfDayRangeBegin</FieldName>
			  <FieldType>nvarchar(50)</FieldType>
		  </Field>
		  <Field>
			  <FieldName>TimeOfDayRangeEnd</FieldName>
			  <FieldType>nvarchar(50)</FieldType>
		  </Field>
		  <Field>
			  <FieldName>TimeBuffer</FieldName>
			  <FieldType>nvarchar(50)</FieldType>
		  </Field>
		  <Field>
			  <FieldName>AlarmGrouping</FieldName>
			  <FieldType>bit</FieldType>
		  </Field>
		  <Field>
			  <FieldName>GroupingTime</FieldName>
			  <FieldType>nvarchar(50)</FieldType>
		  </Field>
		  <Field>
			  <FieldName>ElementContainer</FieldName>
			  <FieldType>nvarchar(MAX)</FieldType>
		  </Field>
		  <Field>
			  <FieldName>AcknowledgeNotification</FieldName>
			  <FieldType>bit</FieldType>
		  </Field>
		  <Field>
			  <FieldName>SecondaryNotification</FieldName>
			  <FieldType>nvarchar(MAX)</FieldType>
		  </Field>
		  <Field>
			  <FieldName>TertiaryNotification</FieldName>
			  <FieldType>nvarchar(MAX)</FieldType>
		  </Field>
      </Schema>
      <EventRules>
        <EventRule>
          <RuleName>MessageEventRule</RuleName>
          <EventClassName>NOCMonMessageEvents</EventClassName>
			<ConditionAction>
			  <SqlLogin>NSRulesEvaluator</SqlLogin>
			  <SqlUser>NSRulesEvaluator</SqlUser>
			  <InputName>NOCMonMessageEvents</InputName>
				<SqlExpression>
					EXEC stp_Insert_Message_Alerts
				</SqlExpression>
			</ConditionAction>
        </EventRule>
      </EventRules>
    </SubscriptionClass>
	  <SubscriptionClass>
		  <SubscriptionClassName>ScheduledSubscriptions</SubscriptionClassName>
		  <Schema>
			  <Field>
				  <FieldName>DeviceName</FieldName>
				  <FieldType>nvarchar(255)</FieldType>
			  </Field>
			  <Field>
				  <FieldName>SubscriberLocale</FieldName>
				  <FieldType>nvarchar(10)</FieldType>
			  </Field>
			  <Field>
				  <FieldName>SourceID</FieldName>
				  <FieldType>int</FieldType>
			  </Field>
			  <Field>
				  <FieldName>ErrorCategoryID</FieldName>
				  <FieldType>int</FieldType>
			  </Field>
			  <Field>
				  <FieldName>Station</FieldName>
				  <FieldType>nvarchar(50)</FieldType>
			  </Field>
			  <Field>
				  <FieldName>Description</FieldName>
				  <FieldType>nvarchar(max)</FieldType>
			  </Field>
			  <Field>
				  <FieldName>Threshold</FieldName>
				  <FieldType>int</FieldType>
			  </Field>
			  <Field>
				  <FieldName>TimeOfDayRangeBegin</FieldName>
				  <FieldType>nvarchar(50)</FieldType>
			  </Field>
			  <Field>
				  <FieldName>TimeOfDayRangeEnd</FieldName>
				  <FieldType>nvarchar(50)</FieldType>
			  </Field>
			  <Field>
				  <FieldName>TimeBuffer</FieldName>
				  <FieldType>nvarchar(50)</FieldType>
			  </Field>
			  <Field>
				  <FieldName>AlarmGrouping</FieldName>
				  <FieldType>bit</FieldType>
			  </Field>
			  <Field>
				  <FieldName>GroupingTime</FieldName>
				  <FieldType>nvarchar(50)</FieldType>
			  </Field>
			  <Field>
				  <FieldName>ElementContainer</FieldName>
				  <FieldType>nvarchar(MAX)</FieldType>
			  </Field>
			  <Field>
				  <FieldName>AcknowledgeNotification</FieldName>
				  <FieldType>bit</FieldType>
			  </Field>
			  <Field>
				  <FieldName>SecondaryNotification</FieldName>
				  <FieldType>nvarchar(MAX)</FieldType>
			  </Field>
			  <Field>
				  <FieldName>TertiaryNotification</FieldName>
				  <FieldType>nvarchar(MAX)</FieldType>
			  </Field>
		  </Schema>
		  <ScheduledRules>
			  <ScheduledRule>
				  <RuleName>ScheduledSubscriptionsRule</RuleName>
				  <ConditionAction>
					  <SqlLogin>NSRulesEvaluator</SqlLogin>
					  <SqlUser>NSRulesEvaluator</SqlUser>
					  <InputName>NOCMonMessageEventsChronicle</InputName>
					  <SqlExpression>
						  INSERT INTO ScheduledNotifications(
						  SubscriberId,
						  DeviceName,
						  SubscriberLocale,
						  Description,
						  SourceID,
						  ErrorCategoryID,
						  Date,
						  Station,
						  Message,
						  StatusID,
						  [nUser],
						  nSubject)
						  SELECT r.[Subscription.SubscriberId],
						  r.[Subscription.DeviceName],
						  r.[Subscription.SubscriberLocale],
						  r.[Subscription.Description],
						  r.[Input.SourceID],
						  r.[Input.ErrorCategoryID],
						  r.[Input.Date],
						  r.[Input.Station],
						  r.[Input.Message],
						  r.[Input.StatusID],
						  r.[Input.nUser],
						  r.[Input.nSubject]
						  FROM ScheduledSubscriptionsRule r;
					  </SqlExpression>
				  </ConditionAction>
			  </ScheduledRule>
		  </ScheduledRules>

	  </SubscriptionClass>
  </SubscriptionClasses>

  <!-- Notification Classes -->
  <NotificationClasses>
    <NotificationClass>
      <NotificationClassName>
        MessageAlerts
      </NotificationClassName>
      <Schema>
        <Fields>
          <Field>
            <FieldName>SourceID</FieldName>
            <FieldType>int</FieldType>
          </Field>
		  <Field>
			<FieldName>Source</FieldName>
			<FieldType>varchar(max)</FieldType>
		  </Field>
		<Field>
			<FieldName>ErrorCategoryID</FieldName>
			<FieldType>int</FieldType>
		</Field>
			<Field>
				<FieldName>ErrorText</FieldName>
				<FieldType>varchar(max)</FieldType>
			</Field>
          <Field>
            <FieldName>Date</FieldName>
            <FieldType>datetime</FieldType>
          </Field>
          <Field>
            <FieldName>Station</FieldName>
            <FieldType>nvarchar(50)</FieldType>
          </Field>
          <Field>
            <FieldName>Message</FieldName>
            <FieldType>nvarchar(max)</FieldType>
          </Field>
          <Field>
            <FieldName>StatusID</FieldName>
			  <FieldType>int</FieldType>
          </Field>
			<Field>
				<FieldName>Status</FieldName>
				<FieldType>varchar(max)</FieldType>
			</Field>
		  <Field>
			<FieldName>nUser</FieldName>
			<FieldType>nvarchar(50)</FieldType>
		  </Field>
			<Field>
				<FieldName>nSubject</FieldName>
				<FieldType>nvarchar(max)</FieldType>
			</Field>
		  <Field>
			<FieldName>Description</FieldName>
			<FieldType>nvarchar(max)</FieldType>
		  </Field>
        </Fields>
      </Schema>
      <ContentFormatter>
        <ClassName>XsltFormatter</ClassName>
        <Arguments>
          <Argument>
            <Name>XsltBaseDirectoryPath</Name>
            <Value>%_AppPath_%</Value>
          </Argument>
          <Argument>
            <Name>XsltFileName</Name>
            <Value>MessageTransform.xslt</Value>
          </Argument>
        </Arguments>
      </ContentFormatter>
      <Protocols>
        <Protocol>
          <ProtocolName>SMTP</ProtocolName>
          <Fields>
            <Field>
              <FieldName>Subject</FieldName>
              <SqlExpression>'NOCMon Notification: '+CONVERT (NVARCHAR(30), GETDATE())</SqlExpression>
            </Field>
            <Field>
              <FieldName>BodyFormat</FieldName>
              <SqlExpression>'html'</SqlExpression>
            </Field>
            <Field>
              <FieldName>From</FieldName>
              <SqlExpression>'noc@captelmail.com'</SqlExpression>
            </Field>
            <Field>
              <FieldName>Priority</FieldName>
              <SqlExpression>'Normal'</SqlExpression>
            </Field>
            <Field>
              <FieldName>To</FieldName>
              <SqlExpression>DeviceAddress</SqlExpression>
            </Field>
          </Fields>
        </Protocol>
      </Protocols>
    </NotificationClass>
	  <NotificationClass>
		  <NotificationClassName>ScheduledNotifications</NotificationClassName>
		  <Schema>
			  <Fields>
				  <Field>
					  <FieldName>SourceID</FieldName>
					  <FieldType>int</FieldType>
				  </Field>
				  <Field>
					  <FieldName>ErrorCategoryID</FieldName>
					  <FieldType>int</FieldType>
				  </Field>
				  <Field>
					  <FieldName>Date</FieldName>
					  <FieldType>datetime</FieldType>
				  </Field>
				  <Field>
					  <FieldName>Station</FieldName>
					  <FieldType>nvarchar(50)</FieldType>
				  </Field>
				  <Field>
					  <FieldName>Message</FieldName>
					  <FieldType>nvarchar(max)</FieldType>
				  </Field>
				  <Field>
					  <FieldName>StatusID</FieldName>
					  <FieldType>int</FieldType>
				  </Field>
				  <Field>
					  <FieldName>nUser</FieldName>
					  <FieldType>nvarchar(50)</FieldType>
				  </Field>
				  <Field>
					  <FieldName>nSubject</FieldName>
					  <FieldType>nvarchar(max)</FieldType>
				  </Field>
				  <Field>
					  <FieldName>Description</FieldName>
					  <FieldType>nvarchar(max)</FieldType>
				  </Field>
			  </Fields>
		  </Schema>
		  <ContentFormatter>
			  <ClassName>XsltFormatter</ClassName>
			  <Arguments>
				  <Argument>
					  <Name>XsltBaseDirectoryPath</Name>
					  <Value>%_AppPath_%</Value>
				  </Argument>
				  <Argument>
					  <Name>XsltFileName</Name>
					  <Value>MessageTransform.xslt</Value>
				  </Argument>
			  </Arguments>
		  </ContentFormatter>
		  <DigestDelivery>true</DigestDelivery>
		  <Protocols>
			  <Protocol>
				  <ProtocolName>SMTP</ProtocolName>
				  <Fields>
					  <Field>
						  <FieldName>Subject</FieldName>
						  <SqlExpression>'NOCMon Notification: '+CONVERT (NVARCHAR(30), GETDATE())</SqlExpression>
					  </Field>
					  <Field>
						  <FieldName>BodyFormat</FieldName>
						  <SqlExpression>'html'</SqlExpression>
					  </Field>
					  <Field>
						  <FieldName>From</FieldName>
						  <SqlExpression>'noc@captelmail.com'</SqlExpression>
					  </Field>
					  <Field>
						  <FieldName>Priority</FieldName>
						  <SqlExpression>'Normal'</SqlExpression>
					  </Field>
					  <Field>
						  <FieldName>To</FieldName>
						  <SqlExpression>DeviceAddress</SqlExpression>
					  </Field>
				  </Fields>
			  </Protocol>
		  </Protocols>
		  <ExpirationAge>PT2H</ExpirationAge>
	  </NotificationClass>
  </NotificationClasses>

  <!-- Event Providers -->
  <Providers>
    <NonHostedProvider>
      <ProviderName>MessageSPEventProvider</ProviderName>
    </NonHostedProvider>
    <NonHostedProvider>
      <ProviderName>SQLTriggerEventProvider</ProviderName>
    </NonHostedProvider>
  </Providers>

  <!-- Generator -->
  <Generator>
    <SystemName>%_NSServer_%</SystemName>
  </Generator>

  <!-- Distributors -->
  <Distributors>
    <Distributor>
      <SystemName>%_NSServer_%</SystemName>
      <QuantumDuration>PT15S</QuantumDuration>
    </Distributor>
  </Distributors>

  <!-- ApplicationExecutionSettings -->
  <ApplicationExecutionSettings>
    <QuantumDuration>PT15S</QuantumDuration>
    <DistributorLogging>
      <LogBeforeDeliveryAttempts>false</LogBeforeDeliveryAttempts>
      <LogStatusInfo>false</LogStatusInfo>
      <LogNotificationText>false</LogNotificationText>
    </DistributorLogging>
	  <PerformanceQueryInterval>PT5S</PerformanceQueryInterval>
	  <SubscriptionQuantumLimit>1</SubscriptionQuantumLimit>
	  <ChronicleQuantumLimit>1</ChronicleQuantumLimit>
    <Vacuum>
      <RetentionAge>P1D</RetentionAge>
      <VacuumSchedule>
        <Schedule>
          <StartTime>23:00:00</StartTime>
          <Duration>P0DT02H00M00S</Duration>
        </Schedule>
      </VacuumSchedule>
    </Vacuum>
  </ApplicationExecutionSettings>

</Application>

The NOCMonMessageEvents Condition Action stored procedure looks like this:

ALTER PROCEDURE [dbo].[stp_Insert_Message_Alerts]

AS

DECLARE @matchID int

BEGIN

	SET NOCOUNT ON;

	INSERT INTO MessageAlerts(SubscriberId, DeviceName, SubscriberLocale, [Description], SourceID, Source, ErrorCategoryID, ErrorText, Date, Station, [Message], StatusID, [Status], nUser, nSubject)
	SELECT r.[Subscription.SubscriberId],
	r.[Subscription.DeviceName],
	r.[Subscription.SubscriberLocale],
	r.[Subscription.Description],
	r.[Input.SourceID],
	SRC.SourceName,
	r.[Input.ErrorCategoryID],
	ERR.ErrText,
	r.[Input.Date],
	r.[Input.Station],
	r.[Input.Message],
	r.[Input.StatusID],
	STAT.[LongDesc],
	r.[Input.nUser],
	r.[Input.nSubject]
	FROM MessageEventRule r
	INNER JOIN tblErrCategory_Sup ERR
		ON ERR.ErrorCategoryID = r.[Input.ErrorCategoryID]
	INNER JOIN tblSource_Sup SRC
		ON SRC.SourceID = r.[Input.SourceID]
	INNER JOIN tblStatus_Sup STAT
		ON STAT.StatusID = r.[Input.StatusID]

	SELECT @matchID = ErrorCategoryID 
	FROM MessageEventRule MER
	INNER JOIN ErrorMatchClearings EMATCH
		ON EMATCH.errorCategoryID = MER.[Input.ErrorCategoryID]

	IF @matchID IS NOT NULL
		BEGIN

			INSERT INTO ErrorMatches(SubscriberId, DeviceName, SubscriberLocale, [Description], SourceID, ErrorCategoryID, Date, Station, [Message], StatusID, nUser, nSubject)
			SELECT r.[Subscription.SubscriberId],
			r.[Subscription.DeviceName],
			r.[Subscription.SubscriberLocale],
			r.[Subscription.Description],
			r.[Input.SourceID],
			r.[Input.ErrorCategoryID],
			r.[Input.Date],
			r.[Input.Station],
			r.[Input.Message],
			r.[Input.StatusID],
			r.[Input.nUser],
			r.[Input.nSubject]
			FROM MessageEventRule r
			WHERE r.[Input.ErrorCategoryID] = @matchID

		END


END

The vb.net I am using to create the subscription (and I suspect this is where I’m doing something wrong?):

        Private Function GetSubscriptionData(ByRef e As Telerik.Web.UI.GridCommandEventArgs) As EventSubscription

            Dim editedItem As GridEditableItem = CType(e.Item, GridEditableItem)
            Dim s As New EventSubscription(EventSubscription.UserName)


            Dim svr As sqlsmo.Server = New sqlsmo.Server("MyServer")
            svr.ConnectionContext.LoginSecure = False

            svr.ConnectionContext.Login = "mylogin"
            svr.ConnectionContext.Password = "mypassword"

            Dim nocmonDB As sqlsmo.Database = svr.Databases("NOCMonMessages")
            Dim errorMatchClearings As sqlsmo.Table = nocmonDB.Tables("ErrorMatchClearings")
            Dim errorMatches As sqlsmo.Table = nocmonDB.Tables("ErrorMatches")
            Dim eventView As sqlsmo.View = nocmonDB.Views("NOCMonMessageEvents")


            Dim sourceDropDown As DropDownList = e.Item.FindControl("sourceDropdown")
            Dim errorDropDown As DropDownList = e.Item.FindControl("errorDropdown")
            Dim stationDropDown As DropDownList = e.Item.FindControl("stationDropdown")
            Dim txtDescription As TextBox = e.Item.FindControl("txtDescription")
            Dim txtThreshold As TextBox = e.Item.FindControl("txtThreshold")
            Dim txtTimeOfDayRangeBegin As TextBox = e.Item.FindControl("txtTimeOfDayRangeBegin")
            Dim txtTimeOfDayRangeEnd As TextBox = e.Item.FindControl("txtTimeOfDayRangeEnd")
            Dim txtTimeBuffer As TextBox = e.Item.FindControl("txtTimeBuffer")
            Dim txtGroupingTime As TextBox = e.Item.FindControl("txtGroupingTime")
            Dim txtElementContainer As TextBox = e.Item.FindControl("txtElementContainer")
            Dim txtSecondaryNotification As TextBox = e.Item.FindControl("txtSecondaryNotification")
            Dim txtTertiaryNotification As TextBox = e.Item.FindControl("txtTertiaryNotification")

            Dim strSource As String = sourceDropDown.SelectedItem.Value
            Dim strErrorText As String = errorDropDown.SelectedItem.Value
            Dim strStation As String = stationDropDown.SelectedItem.Text

            s.Station = strStation
            s.ErrorCategoryID = strErrorText
            s.SourceID = strSource

            Dim sourceOperator As nsr.SimpleOperator = New nsr.SimpleOperator
            Dim errorOperator As nsr.SimpleOperator = New nsr.SimpleOperator
            Dim stationOperator As nsr.SimpleOperator = New nsr.SimpleOperator

            If Trim(strSource) = "ANY" Then
                strSource = ""
                sourceOperator = Microsoft.SqlServer.NotificationServices.Rules.SimpleOperator.NotEquals
            Else
                sourceOperator = Microsoft.SqlServer.NotificationServices.Rules.SimpleOperator.Equals
            End If

            If Trim(strErrorText) = "67" Then
                strErrorText = ""
                errorOperator = Microsoft.SqlServer.NotificationServices.Rules.SimpleOperator.NotEquals
            Else
                errorOperator = Microsoft.SqlServer.NotificationServices.Rules.SimpleOperator.Equals
            End If

            If Trim(strStation) = "ANY" Then
                strStation = ""
                stationOperator = Microsoft.SqlServer.NotificationServices.Rules.SimpleOperator.NotEquals
            Else
                stationOperator = Microsoft.SqlServer.NotificationServices.Rules.SimpleOperator.Equals
            End If

            If txtTimeBuffer.Text <> "00:00:00" Then

                Dim clearingFilter As nsr.FilterRule = New nsr.FilterRule( _
                    New nsr.TableInputType(nocmonDB.Tables("ErrorMatches")), _
                        New nsr.FilterStatement( _
                            New nsr.SimpleLeafCondition( _
                                New nsr.FieldValue("Date"), _
                                    Microsoft.SqlServer.NotificationServices.Rules.SimpleOperator.LessThan, _
                                        New nsr.FunctionValue(nocmonDB.UserDefinedFunctions("TIMEBUFFER", "dbo"), _
                                        txtTimeBuffer.Text, New nsr.FieldValue("Date"))), _
                                            Microsoft.SqlServer.NotificationServices.Rules.FilterAction.Exclude))


                s.UserCondition = New nsr.AndCondition( _
                                    New nsr.SimpleLeafCondition( _
                                        New nsr.FieldValue("SourceID"), _
                                            sourceOperator, strSource), _
                                    New nsr.SimpleLeafCondition( _
                                        New nsr.FieldValue("ErrorCategoryID"), _
                                            errorOperator, strErrorText), _
                                    New nsr.SimpleLeafCondition( _
                                        New nsr.FieldValue("Station"), _
                                            stationOperator, strStation), _
                                    New nsr.LinkLeafCondition( _
                                          Microsoft.SqlServer.NotificationServices.Rules.LinkLeafOperator.Any, _
                                          clearingFilter, _
                                          New nsr.JoinClause( _
                                            eventView.Columns("ErrorCategoryID"), _
                                            errorMatches.Columns("ErrorCategoryID")), _
                                          New nsr.JoinClause( _
                                            errorMatches.Columns("ErrorCategoryID"), _
                                            errorMatchClearings.Columns("clearingErrorCategoryID"))))

            End If

            s.DeviceName = "myDevice"
            s.Locale = "en-us"
            s.Description = txtDescription.Text
            s.Threshold = txtThreshold.Text
            s.TimeOfDayRangeBegin = txtTimeOfDayRangeBegin.Text
            s.TimeOfDayRangeEnd = txtTimeOfDayRangeEnd.Text
            s.TimeBuffer = txtTimeBuffer.Text
            s.GroupingTime = txtGroupingTime.Text
            s.ElementContainer = txtElementContainer.Text
            s.SecondaryNotification = txtSecondaryNotification.Text
            s.TertiaryNotification = txtTertiaryNotification.Text

            Return s

        End Function

Note that where I am creating the clearingFilter, I specify ErrorMatches as the input table, yes ErrorMatches contains a field called Date, I tried changing the name of the field to fooDate, still I got the error, but updated to say could not find ‘fooDate’.

When I use the debugging stored procedures and fire the rule I get:

Msg 207, Level 16, State 1, Line 16
Invalid column name 'Date'.
Msg 207, Level 16, State 1, Line 16
Invalid column name 'Date'.

Here is the XML for the Condition:

<NSRulesObject xmlns="http://www.microsoft.com/MicrosoftNotificationServices/RulesSchema">
<Condition>
	<And>
		<SimpleLeaf Operator="=">
			<Left>
				<Field Name="SourceID" />
			</Left>
			<Right>
				<Constant Type="System.String" Value="2" />
			</Right>
		</SimpleLeaf>
		<SimpleLeaf Operator="=">
			<Left>
				<Field Name="ErrorCategoryID" />
			</Left>
			<Right>
				<Constant Type="System.String" Value="51" />
			</Right>
		</SimpleLeaf>
		<SimpleLeaf Operator="&lt;&gt;">
			<Left>
				<Field Name="Station" />
			</Left>
			<Right>
				<Constant Type="System.String" Value="" />
			</Right>
		</SimpleLeaf>
		<LinkLeaf Operator="Any">
			<FilterRule>
				<InputType>
					<Table Database="NOCMonMessages" Schema="dbo" Name="ErrorMatches" />
				</InputType>
				<Statements>
					<FilterStatement Action="Exclude">
					<Condition>
						<SimpleLeaf Operator="&lt;">
							<Left>
								<Field Name="Date" />
							</Left>
							<Right>
								<Function Db="NOCMonMessages" Schema="dbo" Name="TIMEBUFFER">
									<Parameters>
										<Constant Type="System.String" Value="5" />
										<Field Name="Date" />
									</Parameters>
								</Function>
							</Right>
						</SimpleLeaf>
					</Condition>
					</FilterStatement>
				</Statements>
			</FilterRule>
			<LinkChain>
				<JoinClause SourceDb="NOCMonMessages" SourceSchema="dbo" SourceView="NOCMonMessageEvents" SourceColumn="ErrorCategoryID" 						TargetDb="NOCMonMessages" TargetSchema="dbo" TargetView="ErrorMatches" TargetColumn="ErrorCategoryID" />
				<JoinClause SourceDb="NOCMonMessages" SourceSchema="dbo" SourceView="ErrorMatches" SourceColumn="ErrorCategoryID" 							TargetDb="NOCMonMessages" TargetSchema="dbo" TargetView="ErrorMatchClearings" TargetColumn="clearingErrorCategoryID" />
			</LinkChain>
		</LinkLeaf>
	</And>
</Condition>
</NSRulesObject>

You can see the Date field referenced in the FilterRule.

The subscription saves just fine, so this all really boils down to the rule firing error.

I hope someone can help me or point me in the right direction.

Regards,
Trevor

Describe what is not working as expected.

I have an entity called Note, and a DbSet Notes. When I try to access it via the dbContext, it throws an exception with the message «Invalid column name ‘NotificationId'».

We have an entity called Notification, which has a primary key of NotificationId, but this entity is not related to the Note entity in any way.

The Note table has no column named NotificationId, and there are no navigation properties or joins between Note and Notification.

The Note table is right before the Notification table in the database, but other than that, I can’t find any relationship between the two tables. How could this extra column be getting added to the entity in the DbContext?

I ran this in the immediate window in order to capture all of the exception details:

_dbContext.Notes.FirstOrDefault()
Microsoft.EntityFrameworkCore.Query: Warning: Query: ‘(from Note _1 in DbSet select [_1]).FirstOrDefault()’ uses First/FirstOrDefault/Last/LastOrDefault operation without OrderBy and filter which may lead to unpredictable results.
Microsoft.EntityFrameworkCore.Database.Command: Debug: Executing DbCommand [Parameters=[], CommandType=’Text’, CommandTimeout=’30’]
SELECT TOP(1) [e].[NoteId], [e].[ActiveFlag], [e].[CreateDate], [e].[CreateUserId], [e].[Description], [e].[NotificationId], [e].[SecurityFilter], [e].[Title], [e].[UpdateDate], [e].[UpdateUserId]
FROM [Note] AS [e]
WHERE [e].[ActiveFlag] = 1
Microsoft.EntityFrameworkCore.Database.Command: Error: Failed executing DbCommand (7ms) [Parameters=[], CommandType=’Text’, CommandTimeout=’30’]
SELECT TOP(1) [e].[NoteId], [e].[ActiveFlag], [e].[CreateDate], [e].[CreateUserId], [e].[Description], [e].[NotificationId], [e].[SecurityFilter], [e].[Title], [e].[UpdateDate], [e].[UpdateUserId]
FROM [Note] AS [e]
WHERE [e].[ActiveFlag] = 1

System.Data.SqlClient.SqlException (0x80131904): Invalid column name ‘NotificationId’.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary2 parameterValues) ClientConnectionId:01e5c025-ae4f-44d6-8b58-67e63f6577df Error Number:207,State:1,Class:16 Microsoft.EntityFrameworkCore.Query: Error: An exception occurred while iterating over the results of a query for context type 'WinsApp.Infrastructure.Data.WinsAppContext'. System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'NotificationId'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary2 parameterValues)
at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable1.Enumerator.BufferlessMoveNext(DbContext _, Boolean buffer)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func3 operation, Func3 verifySucceeded)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable1.Enumerator.MoveNext() at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable1 source)
at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ResultEnumerable1.GetEnumerator() at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.<_TrackEntities>d__172.MoveNext()
at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ExceptionInterceptor`1.EnumeratorExceptionInterceptor.MoveNext()
ClientConnectionId:01e5c025-ae4f-44d6-8b58-67e63f6577df
Error Number:207,State:1,Class:16

System.Data.SqlClient.SqlException (0x80131904): Invalid column name ‘NotificationId’.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary2 parameterValues)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable1.Enumerator.BufferlessMoveNext(DbContext _, Boolean buffer) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func3 operation, Func3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable1.Enumerator.MoveNext()
at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable1 source) at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ResultEnumerable1.GetEnumerator()
at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.<_TrackEntities>d__172.MoveNext() at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ExceptionInterceptor1.EnumeratorExceptionInterceptor.MoveNext()
ClientConnectionId:01e5c025-ae4f-44d6-8b58-67e63f6577df
Error Number:207,State:1,Class:16
Microsoft.EntityFrameworkCore.Query: Error: An exception occurred while iterating over the results of a query for context type ‘WinsApp.Infrastructure.Data.WinsAppContext’.
System.Data.SqlClient.SqlException (0x80131904): Invalid column name ‘NotificationId’.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary2 parameterValues)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable1.Enumerator.BufferlessMoveNext(DbContext _, Boolean buffer) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func3 operation, Func3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable1.Enumerator.MoveNext()
at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable1 source) at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ResultEnumerable1.GetEnumerator()
at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.<_TrackEntities>d__172.MoveNext() at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ExceptionInterceptor1.EnumeratorExceptionInterceptor.MoveNext()
at System.Linq.Enumerable.First[TSource](IEnumerable1 source) at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.<>c__DisplayClass15_11.b__0(QueryContext qc)
ClientConnectionId:01e5c025-ae4f-44d6-8b58-67e63f6577df
Error Number:207,State:1,Class:16

System.Data.SqlClient.SqlException (0x80131904): Invalid column name ‘NotificationId’.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary2 parameterValues)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable1.Enumerator.BufferlessMoveNext(DbContext _, Boolean buffer) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func3 operation, Func3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable1.Enumerator.MoveNext()
at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable1 source) at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ResultEnumerable1.GetEnumerator()
at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.<_TrackEntities>d__172.MoveNext() at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ExceptionInterceptor1.EnumeratorExceptionInterceptor.MoveNext()
at System.Linq.Enumerable.First[TSource](IEnumerable1 source) at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.<>c__DisplayClass15_11.b__0(QueryContext qc)
ClientConnectionId:01e5c025-ae4f-44d6-8b58-67e63f6577df
Error Number:207,State:1,Class:16
‘_dbContext.Notes.FirstOrDefault()’ threw an exception of type ‘System.Data.SqlClient.SqlException’
Class: 16
ClientConnectionId: {01e5c025-ae4f-44d6-8b58-67e63f6577df}
Data: {System.Collections.ListDictionaryInternal}
ErrorCode: -2146232060
Errors: {System.Data.SqlClient.SqlErrorCollection}
HResult: -2146232060
HelpLink: null
InnerException: null
LineNumber: 1
Message: «Invalid column name ‘NotificationId’.»
Number: 207
Procedure: «»
Server: «(local)»
Source: «.Net SqlClient Data Provider»
StackTrace: » at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)rn at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)rn at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)rn at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()rn at System.Data.SqlClient.SqlDataReader.get_MetaData()rn at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)rn at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 t imeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)rn at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)rn at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)rn at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)rn at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary2 parameterValues)rn at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary2 parameterValues)rn at Microsoft.EntityFrameworkCore.Quer
y.Internal.QueryingEnumerable1.Enumerator.BufferlessMoveNext(DbContext _, Boolean buffer)rn at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func3 operation, Func3 verifySucceeded)rn at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable1.Enumerator.MoveNext()rn at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable1 source)rn at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ResultEnumerable1.GetEnumerator()rn at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.<_TrackEntities>d__172.MoveNext()rn at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ExceptionInterceptor1.EnumeratorExceptionInterceptor.MoveNext()rn at System.Linq.Enumerable.First[TSource](IEnumerable1 source)rn at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.<>c__DisplayClass15_11.b__0(QueryContext qc)»
State: 1
TargetSite: {Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])}

Further technical details

EF Core version: 2.2
Database Provider: Microsoft.EntityFrameworkCore.SqlServer
Operating system: Windows 10 64 bit
IDE: Visual Studio 2017 latest build

• December 6, 2011 at 12:35 pm

  #251607

  I just altered my table as follows:

  ALTER TABLE dbo.EpisodePackage

  ADD

  WebTagBroadViewId varchar(50) NULL

  , FormatSheetBroadViewId varchar(50) NULL

  , OnAirOfferBroadViewId varchar(50) NULL

  , FundingBedBroadViewId varchar(50) NULL

  then I alterd my Stored procedure:

  Update dbo.EpisodePackage

  Set WebTagBroadViewId = ‘1’

  where id = 586

  I get an error: on the line for:

  Set WebTagBroadViewId = ‘1’

  Msg 207, Level 16, State 1 Invalid column name ‘WebTagBroadViewId’.

  How can I resolve it?

• Gail Shaw

  SSC Guru

  Points: 1004494

  Did you run the ALTER TABLE. Did it succeed?

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Johan Bijnens

  SSC Guru

  Points: 135009

  Did you commit the alter table statement ?

  What’s the @@opentran count for that session ?

• Faye Fouladi

  SSCrazy

  Points: 2770

  The Alter Table statement succedded well.

  When I expand the table columns, I already see the added columns. Is there anything ellse I need to do for the stored procedure to see the cloumns?

• toddasd

  SSCertifiable

  Points: 6298

  Faye Fouladi (12/6/2011)

  ---

  The Alter Table statement succedded well.

  When I expand the table columns, I already see the added columns. Is there anything ellse I need to do for the stored procedure to see the cloumns?

  There is nothing else you need to do. Check that you are not running the alter procedure statement on a different database. For example, run your code as one entire script:

  ALTER TABLE dbo.EpisodePackage

  ADD

  WebTagBroadViewId VARCHAR(50) NULL

  , FormatSheetBroadViewId VARCHAR(50) NULL

  , OnAirOfferBroadViewId VARCHAR(50) NULL

  , FundingBedBroadViewId VARCHAR(50) NULL

  GO

  ALTER PROCEDURE dbo.UpdatePackage

  AS

  UPDATE dbo.EpisodePackage

  SET WebTagBroadViewId = '1'

  WHERE id = 586

  GO

  ______________________________________________________________________________
  How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.

• Faye Fouladi

  SSCrazy

  Points: 2770

  I have something like this in the stored proc:

  — table variable for the BroadView data transformed into PackagingForms format

  DECLARE @BroadViewData TABLE

  (

  EpisodeId INT,

  EpisodePackageFormatId INT,

  EpisodePackageNumber VARCHAR(50),

  WebTagBroadViewId VARCHAR(50),

  FormatSheetBroadViewId VARCHAR(50),

  OnAirOfferBroadViewId VARCHAR(50),

  FundingBedBroadViewId VARCHAR(50),

  FlattenedInd CHAR(1),

  BroadViewId INT,

  BroadViewHashCode VARBINARY(MAX),

  RowId INT IDENTITY,

  UNIQUE CLUSTERED (BroadViewId, RowId)

  )

  The data for updating EpisodePackage table and updating those new fields is coming from this table variable. I also added the fields to the table variable. Do you think I should do something different becuase there is table variable involved here?

• mhike2hale

  SSC Eights!

  Points: 858

  Is there trigger associated with this table?

  «Often speak with code not with word,
  A simple solution for a simple question»

• toddasd

  SSCertifiable

  Points: 6298

  Faye Fouladi (12/6/2011)

  ---

  I have something like this in the stored proc:

  …

  The data for updating EpisodePackage table and updating those new fields is coming from this table variable. I also added the fields to the table variable. Do you think I should do something different becuase there is table variable involved here?

  The only thing I can think of is maybe your table aliases are mixed up in the update statement. Post your whole proc.

  ______________________________________________________________________________
  How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.

• Erwin Dockx

  SSC Eights!

  Points: 842

  Faye Fouladi (12/6/2011)

  ---

  I have something like this in the stored proc

  Have you tried recompiling the stored procedure?

  exec sp_recompile 'your_proc_name_goes_here';

  exec sp_refreshsqlmodule 'your_proc_name_goes_here';

  _____________________________________________________
  Do not go past the mark you aimed for, but learn when to stop.

  You can find me on LinkedIn.
  I support The Programmer’s Bill of Rights.

  MCITP, MCDBA, MCSD

• glothin

  SSC Rookie

  Points: 45

  One thing important to note: GO is not a SQL Server command, but a tool of SQL Management studio.

  When you run that script directly, SQL MS executes it batches separated by the ‘GO’. Therefore the new columns are committed/posted before update is ran.

  GO does not work in a stored procedure. When the procedure is compiled, it simply does not recognize the alter table.

  I have inherited a script with a similiar problem. I welcome a better solution than I have.

  My terrible temporary workaround is to create the table outside the stored procedure so that it contains all the columns it will eventually contain inside the stored procedure. Then the stored procedure will compile.

  If the table exists when the procedure is compiled it will work. Then my stored procedure will:

  1. drops the table if it exists;

  2. creates the new table with one field Junk(200)

  3. Perform bulk insert into my table

  4. alters my table and adds columns used to more precisely split up the data from the bulk insert

  5. Performs updates and other commands

  In my case using the #temp session tables improve the situation. The script can also be rewritten to extract data from the imported table to the correct columns or copy to a second table.

• toddasd

  SSCertifiable

  Points: 6298

  As far as I can tell, the OP is not trying to alter a table within a proc. OP has run the alter table and is now trying to alter a proc which is returning the column not found error. We need to see the proc.

  ______________________________________________________________________________
  How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.

• Faye Fouladi

  SSCrazy

  Points: 2770

  No triggers associated with this stored procedure.

Hi Guys,

I’m was create all table on database Sql Server version 9.00.3042.00(2020) and then I’m want make automatic model that generate from Entity Framework in Visual Studio 2019 via Package Manager Console but alwasy get this error

Invalid column name 'has_filter'.
Invalid column name 'filter_definition'.

 Below the error shown.

PM> Scaffold-DbContext "Server=DESKTOP-REM8S41SQLEXPRESS;Database=db_klinik;Integrated Security=True" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Database -Context "ApplicationDbContext" -DataAnnotations
Build started...
Build succeeded.
To protect potentially sensitive information in your connection string, you should move it out of source code. You can avoid scaffolding the connection string by using the Name= syntax to read it from configuration - see https://go.microsoft.com/fwlink/?linkid=2131148. For more guidance on storing connection strings, see http://go.microsoft.com/fwlink/?LinkId=723263.
Security Warning: The negotiated TLS 1.0 is an insecure protocol and is supported for backward compatibility only. The recommended protocol version is TLS 1.2 and later.
Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'has_filter'.
Invalid column name 'filter_definition'.
   at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData()
   at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean isAsync, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String method)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at Microsoft.EntityFrameworkCore.SqlServer.Scaffolding.Internal.SqlServerDatabaseModelFactory.GetIndexes(DbConnection connection, IReadOnlyList`1 tables, String tableFilter)
   at Microsoft.EntityFrameworkCore.SqlServer.Scaffolding.Internal.SqlServerDatabaseModelFactory.GetTables(DbConnection connection, DatabaseModel databaseModel, Func`3 tableFilter, IReadOnlyDictionary`2 typeAliases)
   at Microsoft.EntityFrameworkCore.SqlServer.Scaffolding.Internal.SqlServerDatabaseModelFactory.Create(DbConnection connection, DatabaseModelFactoryOptions options)
   at Microsoft.EntityFrameworkCore.SqlServer.Scaffolding.Internal.SqlServerDatabaseModelFactory.Create(String connectionString, DatabaseModelFactoryOptions options)
   at Microsoft.EntityFrameworkCore.Scaffolding.Internal.ReverseEngineerScaffolder.ScaffoldModel(String connectionString, DatabaseModelFactoryOptions databaseOptions, ModelReverseEngineerOptions modelOptions, ModelCodeGenerationOptions codeOptions)
   at Microsoft.EntityFrameworkCore.Design.Internal.DatabaseOperations.ScaffoldContext(String provider, String connectionString, String outputDir, String outputContextDir, String dbContextClassName, IEnumerable`1 schemas, IEnumerable`1 tables, String modelNamespace, String contextNamespace, Boolean useDataAnnotations, Boolean overwriteFiles, Boolean useDatabaseNames, Boolean suppressOnConfiguring, Boolean noPluralize)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.ScaffoldContextImpl(String provider, String connectionString, String outputDir, String outputDbContextDir, String dbContextClassName, IEnumerable`1 schemaFilters, IEnumerable`1 tableFilters, String modelNamespace, String contextNamespace, Boolean useDataAnnotations, Boolean overwriteFiles, Boolean useDatabaseNames, Boolean suppressOnConfiguring, Boolean noPluarlize)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.ScaffoldContext.<>c__DisplayClass0_0.<.ctor>b__0()
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.<>c__DisplayClass3_0`1.<Execute>b__0()
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
ClientConnectionId:cdd89a38-9156-4634-b34d-ff0e4532ac4f
Error Number:207,State:1,Class:16
Invalid column name 'has_filter'.
Invalid column name 'filter_definition'.

Any help could be apriciate.