CODEWITHSUNDEEP
c#sql-serverentity-frameworktable-valued-parameters
Frantisek
Frantisek

Reputation: 1

SQL table valued function and Entity Framework using C#

Please, could you give me some tips for my problem with table valued function in SQL?

I am designing Windows Forms app in C#, Visual Studio and I am using Entity Framework to join SQL database.

I've already created number of table valued functions and most of them work fine, but a few of them don't.

They usually works OK, but from time to time it freezes when program starts to read data from SQL (using foreach). It shows exception that time expired (after maybe 30 seconds).

The strange thing is, that usually after PC restart table valued function starts to work OK for a while.

Please, do you have any suggests what to do with it?

I am using Microsoft sql server.

Thank you very much.

Upvotes: 0

Views: 192

Answers (1)

yildizyasin
yildizyasin

Reputation: 116

It seems like the problem is not on the server-side. Check out that: Set database timeout in Entity Framework

Upvotes: 0

Related Questions