I have a stored procedure to update a column for a given value. I have the following sql in the stored procedure

update TicketingWillcallLocations set InternetWillCallAllowed = @willCallFlag where willcallId = @willCallId

@willCallFlag - .NET type string and DB type is char(1) @willCallId - .NET type is int and DB type is int (Note: It is an identity key in the table)

While I debug I see the value('Y' or 'N') sent from the program, but the value doesn't seem to be passed correctly to the stored procedure since it updates the willcallflag to empty string after the stored procedure is called.

Any help would be greatly appreciated.

Thanks, Santhi

This has nothing to do with Linq so this is the wrong forum. I'll move it to General You should give more information: version of llblgen pro, runtime library build nr, your code you use to call the procedure etc. (see guidelines thread in all the forums)

LLBLGEN PRo - 2.5 Runtime Library - DotNet20 C# code int i = ActionProcedures.UpdateTicketingWillCallLocations(willCallId, willCallFlag); eg values passed to stored procedure willCallId = 123 willCallFlag = "Y" or "N"

Stored procedure

CREATE PROCEDURE dbo.sp_UpdateTicketingWillCallLocations

@willCallId int, @willCallFlag char(1)

AS

SET NOCOUNT ON

update TicketingWillcallLocations set InternetWillCallAllowed = @willCallFlag where willcallId = @willCallId

GO

In the database: is there a check constraint on the field?

Would you please try the following code:

int i = ActionProcedures.UpdateTicketingWillCallLocations(123, 'Y');

Note I used 'Y' instead of "Y"

Yes, it works by changing the LLBLGEN generated code to take the parameter of type char instead of string.

I was wondering whether we could have some settings in the LLBLGEN project to generate the code with the .net type matching the DB data type.

Which runtime library version are you using?

Runtime version is 2.5.7.1019

Would you please download and use the latest release of LLBLGen Pro (the Full Package)? And then refresh the catalog and re-generate the code and try again.