Tag Archives: SQL

EntityDataSource and Relationships, why oh why did you not bring along my relationship?

I spent about 3 hours cursing up a storm over some data binding I was doing using the EntityDataSource against my Entity Framework context. I was feeling lazy and using the declarative data sources to bind against my grid for some automatic operations.  So, should be easy right? Slap on the data source, bind to… Read More »

How to delete those pesky duplicate SQL records…

So every once in a while I find that I have some duplicate records in my database as a result of testing or development or plain oversight. How to remedy the situation? Well, its as easy as this simple SQL. delete sourceTable from YOURTABLENAME sourceTable, YOURTABLENAME compareTable where sourceTable.fieldWithDuplicatesToMatch= compareTable.fieldWithDuplicatesToMatch and sourceTable.PrimaryKey > compareTable.PrimaryKey Basically,… Read More »

.NET Illuminator v1 Alpha Released to the wild

So….I finally decided to release my alpha version to all you hooligans who want to see whats under the hood of fellow .NET’ers applications. You can use .NET Illuminator to see all the UI objects in another .NET application and even manipulate them. Yes, pretend like you are in Visual Studios Form Designer and just… Read More »