CODEWITHSUNDEEP
visual-studioentity-frameworkfirebirddatabase-first
Amin
Amin

Reputation: 153

Firebird Entity Framework casts all string parameters to Varchar(8191)

I'm using VS2017 and Firebird as database. I use database first to create my Model from all stored procedures. When I execute a procedure, all string variables cast as CAST(@I_NAME AS VARCHAR(8191)) and when I have more than 5-6 string variable I get this error:

SQL error code = -204
Implementation limit exceeded
block size exceeds implementation restriction.

Why it does not get the size which is defined in the stored procedure in Firebird (for example varchar(20))?

I there any way to prevent casting here? Or any other idea to sole this problem.

Upvotes: 1

Views: 252

Answers (0)

Related Questions