Browse by Tags

All Tags » .Net » SQL (RSS)
Sat, Nov 21 2009 9:42

4 in 1: EF won’t fire DBAs, Velocity, SQL CLR and SQL Dependency

Imagine that we have a table Cars with a PK Id (nvarchar(8)) based on the following regex pattern [1-9][0-9]{1,2}[A-Z]{2,3}[0-9]{2}. The last two numbers are a region code. The increasement is done like this: 10AA[region], 11AA[region], …, 999AA[region...
Posted by Matthieu MEZIL | with no comments
Filed under: , , , , ,
Thu, Jan 29 2009 8:20

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...
Posted by Matthieu MEZIL | 2 comment(s)
Filed under: , , ,
Wed, Oct 22 2008 3:33

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: ,