{"action":"opened","issue":{"url":"https://api.github.com/repos/aspnet/Identity/issues/921","repository_url":"https://api.github.com/repos/aspnet/Identity","labels_url":"https://api.github.com/repos/aspnet/Identity/issues/921/labels{/name}","comments_url":"https://api.github.com/repos/aspnet/Identity/issues/921/comments","events_url":"https://api.github.com/repos/aspnet/Identity/issues/921/events","html_url":"https://github.com/aspnet/Identity/issues/921","id":167712285,"number":921,"title":"What is causing all these database calls?","user":{"login":"twilliamsgsnetx","id":13950486,"avatar_url":"https://avatars.githubusercontent.com/u/13950486?v=3","gravatar_id":"","url":"https://api.github.com/users/twilliamsgsnetx","html_url":"https://github.com/twilliamsgsnetx","followers_url":"https://api.github.com/users/twilliamsgsnetx/followers","following_url":"https://api.github.com/users/twilliamsgsnetx/following{/other_user}","gists_url":"https://api.github.com/users/twilliamsgsnetx/gists{/gist_id}","starred_url":"https://api.github.com/users/twilliamsgsnetx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/twilliamsgsnetx/subscriptions","organizations_url":"https://api.github.com/users/twilliamsgsnetx/orgs","repos_url":"https://api.github.com/users/twilliamsgsnetx/repos","events_url":"https://api.github.com/users/twilliamsgsnetx/events{/privacy}","received_events_url":"https://api.github.com/users/twilliamsgsnetx/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-07-26T21:08:17Z","updated_at":"2016-07-26T21:08:17Z","closed_at":null,"body":"Everytime I hit one of my controller actions, I'm noticing these calls that appear to be from identity framework. I haven't been able to pinpoint exactly where they are originating or why. Is this just the nature of the beast when using Identity?\r\n\r\n```\r\nMicrosoft.AspNetCore.Hosting.Internal.WebHost: Information: Request starting HTTP/1.1 GET http://localhost:1412/api/metrics/membership/full?membYear=2017&fromDate=4%2F27%2F2016&throughDate=4%2F30%2F2016&aggregates=Troop  \r\nMicrosoft.AspNetCore.StaticFiles.StaticFileMiddleware: Debug: The request path /api/metrics/membership/full does not match a supported file type\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.SqlServerConnection: Debug: Opening connection to database 'DataPlatform' on server 'T1564\\TIMDEVSQLSERVER'.\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilderFactory: Information: Executed DbCommand (0ms) [Parameters=[@__id_0='?' (Size = 450)], CommandType='Text', CommandTimeout='30']\r\nSELECT TOP(1) [u].[Id], [u].[AccessFailedCount], [u].[ConcurrencyStamp], [u].[Department], [u].[Email], [u].[EmailConfirmed], [u].[FirstName], [u].[LastName], [u].[LockoutEnabled], [u].[LockoutEnd], [u].[Name], [u].[NormalizedEmail], [u].[NormalizedUserName], [u].[PasswordHash], [u].[PhoneNumber], [u].[PhoneNumberConfirmed], [u].[PictureThumbnail], [u].[SecurityStamp], [u].[TwoFactorEnabled], [u].[UserName]\r\nFROM [AspNet.Users] AS [u]\r\nWHERE [u].[Id] = @__id_0\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.SqlServerConnection: Debug: Closing connection to database 'DataPlatform' on server 'T1564\\TIMDEVSQLSERVER'.\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.SqlServerConnection: Debug: Opening connection to database 'DataPlatform' on server 'T1564\\TIMDEVSQLSERVER'.\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilderFactory: Information: Executed DbCommand (0ms) [Parameters=[@__userId_0='?' (Size = 450)], CommandType='Text', CommandTimeout='30']\r\nSELECT [role].[Name]\r\nFROM [AspNet.UserRoles] AS [userRole]\r\nINNER JOIN [AspNet.Roles] AS [role] ON [userRole].[RoleId] = [role].[Id]\r\nWHERE [userRole].[UserId] = @__userId_0\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.SqlServerConnection: Debug: Closing connection to database 'DataPlatform' on server 'T1564\\TIMDEVSQLSERVER'.\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.SqlServerConnection: Debug: Opening connection to database 'DataPlatform' on server 'T1564\\TIMDEVSQLSERVER'.\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilderFactory: Information: Executed DbCommand (0ms) [Parameters=[@__normalizedName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30']\r\nSELECT TOP(1) [r].[Id], [r].[ConcurrencyStamp], [r].[Name], [r].[NormalizedName]\r\nFROM [AspNet.Roles] AS [r]\r\nWHERE [r].[NormalizedName] = @__normalizedName_0\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.SqlServerConnection: Debug: Closing connection to database 'DataPlatform' on server 'T1564\\TIMDEVSQLSERVER'.\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.SqlServerConnection: Debug: Opening connection to database 'DataPlatform' on server 'T1564\\TIMDEVSQLSERVER'.\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilderFactory: Information: Executed DbCommand (0ms) [Parameters=[@__role_Id_0='?' (Size = 450)], CommandType='Text', CommandTimeout='30']\r\nSELECT [rc].[ClaimType], [rc].[ClaimValue]\r\nFROM [AspNet.RoleClaims] AS [rc]\r\nWHERE [rc].[RoleId] = @__role_Id_0\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.SqlServerConnection: Debug: Closing connection to database 'DataPlatform' on server 'T1564\\TIMDEVSQLSERVER'.\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.SqlServerConnection: Debug: Opening connection to database 'DataPlatform' on server 'T1564\\TIMDEVSQLSERVER'.\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilderFactory: Information: Executed DbCommand (0ms) [Parameters=[@__normalizedName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30']\r\nSELECT TOP(1) [r].[Id], [r].[ConcurrencyStamp], [r].[Name], [r].[NormalizedName]\r\nFROM [AspNet.Roles] AS [r]\r\nWHERE [r].[NormalizedName] = @__normalizedName_0\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.SqlServerConnection: Debug: Closing connection to database 'DataPlatform' on server 'T1564\\TIMDEVSQLSERVER'.\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.SqlServerConnection: Debug: Opening connection to database 'DataPlatform' on server 'T1564\\TIMDEVSQLSERVER'.\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilderFactory: Information: Executed DbCommand (0ms) [Parameters=[@__role_Id_0='?' (Size = 450)], CommandType='Text', CommandTimeout='30']\r\nSELECT [rc].[ClaimType], [rc].[ClaimValue]\r\nFROM [AspNet.RoleClaims] AS [rc]\r\nWHERE [rc].[RoleId] = @__role_Id_0\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.SqlServerConnection: Debug: Closing connection to database 'DataPlatform' on server 'T1564\\TIMDEVSQLSERVER'.\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.SqlServerConnection: Debug: Opening connection to database 'DataPlatform' on server 'T1564\\TIMDEVSQLSERVER'.\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilderFactory: Information: Executed DbCommand (0ms) [Parameters=[@__normalizedName_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30']\r\nSELECT TOP(1) [r].[Id], [r].[ConcurrencyStamp], [r].[Name], [r].[NormalizedName]\r\nFROM [AspNet.Roles] AS [r]\r\nWHERE [r].[NormalizedName] = @__normalizedName_0\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.SqlServerConnection: Debug: Closing connection to database 'DataPlatform' on server 'T1564\\TIMDEVSQLSERVER'.\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.SqlServerConnection: Debug: Opening connection to database 'DataPlatform' on server 'T1564\\TIMDEVSQLSERVER'.\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilderFactory: Information: Executed DbCommand (0ms) [Parameters=[@__role_Id_0='?' (Size = 450)], CommandType='Text', CommandTimeout='30']\r\nSELECT [rc].[ClaimType], [rc].[ClaimValue]\r\nFROM [AspNet.RoleClaims] AS [rc]\r\nWHERE [rc].[RoleId] = @__role_Id_0\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.SqlServerConnection: Debug: Closing connection to database 'DataPlatform' on server 'T1564\\TIMDEVSQLSERVER'.\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.SqlServerConnection: Debug: Opening connection to database 'DataPlatform' on server 'T1564\\TIMDEVSQLSERVER'.\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilderFactory: Information: Executed DbCommand (0ms) [Parameters=[@__user_Id_0='?' (Size = 450)], CommandType='Text', CommandTimeout='30']\r\nSELECT [uc].[Id], [uc].[ClaimType], [uc].[ClaimValue], [uc].[UserId]\r\nFROM [AspNet.UserClaims] AS [uc]\r\nWHERE [uc].[UserId] = @__user_Id_0\r\nMicrosoft.EntityFrameworkCore.Storage.Internal.SqlServerConnection: Debug: Closing connection to database 'DataPlatform' on server 'T1564\\TIMDEVSQLSERVER'.\r\n```"}}
{"actor":{"display_login":"twilliamsgsnetx"}}