Visual Studio Magazine

Dynamic Data Access with Plain Old SQL and SqlQuery

You don't have to give up using dynamic SQL just because you're using Entity Framework. The Entity Framework SqlQuery method will give you back the flexibility of dynamic SQL and still let you work ...
dbta

Dynamic Data Masking and Row-Level Security Features on the Way in SQL Server 2016

SQL Server 2016, the next major release of Microsoft’s flagship database and analytics platform (which is available as a Community Technology Preview [CTP] as of this writing), includes exciting ...
Ars Technica

SQL Server DTS Q.... Take two fields in .txt file and update based on query

I have a txt file with two fields. I want to update a value in a table in a SQL Server Db with a value from one of the fields in the text file. I want to do this based on a query using the second ...
Ars Technica

Any way to dynamically choose fields in a LINQ query expression?

So I've got this large dataset...call it t_Data, it's pretty easy to cut it up with a where condition in LINQ, but I want to be able to interrogate another dataset....call it q_Category (which ...