Function evaluation disabled because a previous function evaluation timed out. You must continue execution to reenable function evaluation.

Question

1.00/5 (1 vote)

See more:

Hi,

I am getting the following error when I am debugging the application. It is giving me the Problem where I am using the EF collection, I am trying to see what's inside, then it gave an error, when I refreshed it and try to see next steps, this error popped-up, any help please to not to see this error at all?

Function evaluation disabled because a previous function evaluation timed out. You must continue execution to reenable function evaluation.

What I have tried:

I am searching in Google, and trying while debugging frequently

Posted 24-May-16 5:25am

indian143

Updated 24-May-16 15:00pm

Add a Solution

Comments

Philippe Mori 24-May-16 21:08pm

Add additional information in the question. Be careful to properly use code block with the correct language set.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2016-05-24T07:39:00

Solution 1

If you have a long running query the debugger times out before the query and reconstitution is finished. I have never found a way to get around this timeout, modify it, or turn it off.

I have found that there are certain things you cannot do with the debugger in the middle of an EF operation without running into this. I mitigated some of it by rewriting the code a bit to limit the number of items returned from the database.

Posted 24-May-16 7:39am

Dave Kreskowiak

Comments

[no name] 24-May-16 14:44pm

No, its not a long query, its just a small table with 4 rows. And all I did was I stopped my execution there and tried to find what's there inside the object by using immediate window.

No EF before was not behaving like this I was using it before.

And here is my code:

My ASP.Net Controller is as below

namespace TestAngularJSApplication.Controllers
{
public class EmployeeController : Controller
{
public ActionResult Index()
{
return View();
}

public JsonResult GetEmployees()
{
DAL oDAL = new DAL();
//List<employee> listOfEmployees;
var a = oDAL.employees;
var listOfEmployees = oDAL.employees.ToList();
return Json(listOfEmployees,JsonRequestBehavior.AllowGet);
}
}
}

And my DAL is as below

public class DAL : DbContext
{
public DAL() : base("TestConnectionString") { }

public DbSet<employee> employees { get; set; }

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
//base.OnModelCreating(modelBuilder);
modelBuilder.Entity<employee>().ToTable("EmployeeTable");
modelBuilder.Entity<employee>().HasKey(x => x.Id);
}
}

Dave Kreskowiak 24-May-16 16:27pm

First, DAL is a bad name for a DbContext class. You can have multiple DbCOntexts in your application all looking at the same database, so it's better to call them exactly what they are.

Second, set the breakpoint on the "return Json..." line and you can look at the collection immediately above it.

Patrice T 24-May-16 19:14pm

Use Improve question to update your question.
So that everyone can pay attention to this information.

Philippe Mori 24-May-16 21:04pm

Write your code in the question and use code block. Do you really believe someone would be enough crazy to read code that is not formatted? You are not helping yourself if you don't make minimal effort so that other might help you.

[no name] 24-May-16 16:46pm

I will change the name of DAL class but I tried to check, the collection is not getting loaded. Table schema is also matching with the class members that I am mapping with.
Can you please help me

Here is my table structure
CREATE TABLE [dbo].[EmployeeTable](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](max) NULL,
[EmployeeAddress] [nvarchar](max) NULL,
[EmployeeSalary] [decimal](10, 2) NULL,
[IsActive] [bit] NULL,
CONSTRAINT [PK_EmployeeTable] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

And here is my class structure
namespace TestAngularJSMCVApplication.Models
{
public class Employee
{
public int Id { get; set; }
public string Name { get; set; }
public string EmployeeAddress { get; set; }
public decimal EmpployeeSalary { get; set; }
public bool IsActive { get; set; }
}
}

And here how I have written in DAL, any issues please Connection string is fine as its not throwing error in it and table has data but two rows has null values for the EmployeeAddress and EmployeeSalary, could that be a problem.

Here is how I am trying to retrieve values from Database table using DAL
public class DAL : DbContext
{
public DAL() : base("TestConnectionString") { }

public DbSet<employee> employees { get; set; }

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
//base.OnModelCreating(modelBuilder);
modelBuilder.Entity<employee>().ToTable("EmployeeTable");
modelBuilder.Entity<employee>().HasKey(x => x.Id);
}
}

Any ideas please?

Dave Kreskowiak 24-May-16 16:59pm

Everything LOOKS ok. I'd really avoid using the field name of "Id" because in larger databases you're going to have a ton of these running around and it's just going to make your life hell if you have to figure out which "Id" is which.

Verify the connection string points to the database you expect it to and on the server you expect it to. Use whatever manager app your database engine uses to verify the table "ExployeeTable" exists and that there is data in it.

No, NULL's in those fields won't do anything.

The code is telling you that the table is empty. So you have to verify that you're looking in the same place the code is looking.

[no name] 24-May-16 17:44pm

About Id I would change the name OK, but it is the same table and Table has data. Is the Entity Framework Version would a Problem? I am not understanding what it is causing this issue? The Systems.Data.Entity Version is : 4.0 and EntityFramework Version=5.0.0.0.

I am not understanding what could the reason please help me in this - Thank you.

Dave Kreskowiak 24-May-16 18:16pm

Well, the code is saying there's no data in the table. That would lead me to believe the connection string is looking at some database that you are not.

You didn't show any code putting data into the table, so does that mean that you typed the data directly into the table?

[no name] 24-May-16 18:44pm

yes I directly put the data into the table. And to look in different Database, there is no table in different data base with same name. It should have thrown Exception, no its not throwing exception of any kind running smoothly but not giving me the data.

Dave Kreskowiak 24-May-16 18:49pm

All I can tell you is that you're looking at a different database from what the code is looking at. Like I said before, double check everything in the connection string in your app.config file.

You're looking at a different database than the code is. There is no other possibility.

[no name] 24-May-16 19:56pm

Hi Dave, When I wrote the following code as below in the same function just to check if I am connecting to different database, it is not connecting and returning me a table as well which is same as the one in the database.

Please help me buddy I am not understanding what's going on or what's missing.
Here is the code that I wrote to test the my connections and database values, I used the same connection string that I used before. Here is the code

SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["TestConnectionString"].ToString());
if (con.State == System.Data.ConnectionState.Closed)
{
con.Open();
}

SqlDataAdapter ad = new SqlDataAdapter("select * from EmployeeTable", con);
DataSet ds = new DataSet();
ad.Fill(ds);

int a = ds.Tables.Count;

this ds.Tables.Count me value 1 and when I put ds.Tables[0] in the immediate window I am getting the Table that I have in Db, can you please help me in this I am not understanding what it is.

Dave Kreskowiak 24-May-16 20:14pm

I've taken it as far as I can go. I've already told you what the possibility is. At no point did you ever show what the connection string was that is called "TestConnectionString". I've told you where to find it.

[no name] 24-May-16 20:17pm

Here is the connection String buddy, sorry I was about to send you that, thanks for helping me in all this way long

<add name="TestConnectionString" connectionstring="Data Source=KNW-DEL-ABDUL\SQL2008R2;Integrated Security=True;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False" providername="System.Data.SqlClient" > </add>

Can you please let me know did I miss something in the connection string?

Dave Kreskowiak 24-May-16 21:05pm

OK, there's an SQL Server instance called SQL1008R2 on a machine called KNW-DEL-ABDUL. The database name, by default, is going to be "[namespace].DAL".

Sascha Lefèvre · Answer 2 · 2016-05-24T15:00:00

In addition to the potential timeout issue there's also the possibility of a threading issue, because the debugger evaluation is being run on a separate thread. If your code that is being implicitly run by the debugger evaluation is not thread safe it can lead to this error as well.
Ref: debugging - "Function evaluation disabled because a previous function evaluation timed out." - in vs2012 - Stack Overflow[^]

If you can neither identify a timeout nor a threading issue then I suggest to resort to logging.