Browse by Tags

All Tags » Entity Framework (EF) » SQL (RSS)

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...

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...