Browse by Tags

All Tags » SQL (RSS)

EDM can save your hair :-)

I am doing a training this week and one of my student told me that his DB can be used with EF. Indeed, his base isn't great for EF: a table Bases with 4 columns: Id, int, Identity (PK) Key, int, not null Value, int, not null Text, nvarchar He explained...

Length too important, SP truncates instead of returning an error

Imagine that we have a stored procedure with a varchar(3) parameter. If we call it with "AZERTY" as parameter, the SP is executed as with "AZE" as parameter. I find it really bad! I think we should have a sql error and then if a .NET...
Posted by Matthieu MEZIL | with no comments
Filed under: ,