General information
Category:
The Mere Mortals .NET Framework
Title:
Business Layer Generator error in case sensitive SQL server?
Dear All,
Does anyone ever try the BLG in a case sensitive SQL server?
I encounter a problem that suspiciously due to my SQL server is case sensitive. The error stack is very long, I cannot find the log file (where is it anyway?), so I will higlight it:
a. Error: Invalid Column Name : CDEFAULT, Invalid Column Text.
b. I think the error originated in OakLeaf.Main.Data.mmData.GetStoredProcedureParameter line 950 which has a SQL select into the backend server with param.CDEFAULT (CDEFAULT all capital.)
c. If I choose NOT to create Data Access Layer, then the error won't happen.
d. I chose "Use dynamic SQL statements"
e. The error also happen if you click "View SQL Script" button which visible if you choose "Create New Procedure" in "Generate Data Access Layer" step.
Any suggestions how to handle this problem? I dare not rebuild the BLG. :) I cannot change my SQL Server to case insensitive either, my customer required it.
Thanks & Regards,
Rusli
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only