SQL Server 2008 – Retrieving a Users’ Privileges for all tables in a databse

I recently answered a question on StackOverflow.com by a user who needed to retrieve a list of a given users Privileges for each Table in a given Database.After some trial an error I ended up with the following T-SQL Script; declare @Proc nvarchar(50)declare @RowCnt intdeclare @MaxRows intdeclare @ExecSql nvarchar(255) select @RowCnt = 1select @Proc = 'SELECT [...]

By |2017-07-24T08:33:18+01:00January 21st, 2013|Data, SQL Server, T-SQL|0 Comments

Using Reflection to retrieve Entity Framework Data using a Column Name String

If you ever need to retrieve data from EF using the name of a column, rather than the built in Intellisense, then the following vb.net code snippet may help. GetType(TypeOfEntity).GetProperty(NameOfColumn).GetValue(ActualEntity, Nothing)TypeOfEntity is the name of the Entity from which you wish to retrieve data. NameOfColumn is obviously the Name of the Column from which you [...]

By |2017-07-24T08:33:19+01:00November 20th, 2012|.Net Framework, C#, Data, Entity Framework, VB.net, Visual Studio|0 Comments

MVVM: Binding a Linq Query result to a DataGrids’ ItemSource doesn’t update the UI

While creating Desktop Applications using WPF, I always employ the MVVM model if I can. This model is not only great at developing testable n-tier applications, but of course is also highly recommended by Microsoft. However, as with most software development, there are nearly always specific methods to employ for certain processes and functions. One [...]

By |2017-07-24T08:33:19+01:00September 21st, 2012|Data, MVVM, VB.net, Visual Studio|0 Comments