2 ms·
We mainly do DB construction ourselves, and for C# use LinqToSql and our own repos to integrate with it. This is mainly because entity framework is terrible. I
by eksemplar 8y ago
We mainly do DB construction ourselves, and for C# use LinqToSql and our own repos to integrate with it.
This is mainly because entity framework is terrible. It’s slow enough that the lack of speed which is worse in Linq gets negligible. It’s unproductive in that it’s really verbose and unintuitive in how it works, especially code first. And worst of all, it’s migrations often break, leading to a lot of time fixing it.
So if you’re doing C# I’d probably keep doing raw sql if I were you.
Django by contrast has an excellent ORM, and with node you have stuff like prisma (though it doesn’t have a mssql driver.
So really, I’d suggest you looked into python for your services.