If you are using entity framework and gets the following error message “Unable to load the specified metadata resource” while trying to fetch some data from a database. You can see what cause this message and how to solve it.…
To view current sql queries running on sql database you can use this sql script to get current query and elapsed time. SELECT sqltext.TEXT, req.session_id, req.status, req.command, req.cpu_time, req.total_elapsed_time FROM sys.dm_exec_requests req CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext I have only…
The entity type <Type> is not part of the model for the current context. ExceptionType: System.InvalidOperationException System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) vid System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) vid System.Runtime.CompilerServices.TaskAwaiter`1.GetResult() vid System.Web.Http.Controllers.ApiControllerActionInvoker.d__0.MoveNext() — Slut på stackspårningen från föregående plats där ett undantag utlöstes — vid System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)…