Geeks With Blogs

Steve Clements .Net and then some.... LINQ
Dynamic connection for LINQ to SQL DataContext
If for some reason you need to specify a specific connection string for a DataContext, you can of course pass the connection string when you initialise you DataContext object. A common scenario could be a dev/test/stage/live connection string, but in my case its for either a live or archive database. I however want the connection string to be handled by the DataContext, there are probably lots of different reasons someone would want to do this…but here are mine. I want the same connection string ......

Posted On Friday, April 16, 2010 1:14 AM

LINQ the lot
LINQ goes so much further than just SQL and XML. Something like this is just why I love LINQ, a LINQ query on an ASP.NET ListView controls items. 1: Dim items = From lvi In AspNetListViewControl.Items _ 2: Where CType(lvi.FindControl("Drop... DropDownList).SelectedValue = someIntVar _ 3: Select lvi) Getting a ListViewItem's where the selected value of a DropDownList is set to the value I want. So simple, yet so powerful. The observant among you will notice that this is in, not my ......

Posted On Wednesday, May 28, 2008 5:01 PM

LINQ to SQL: Property Changed / Changing Logging
I have recently came up against a perfect opportunity to get stuck into LINQ to SQL, its a small project where RAD is top priority. As often is the case I need to audit changes to properties, normally I would probably do some work in the getter and setter of the property, but of course with LINQ to SQL I don't have access to the properties in the same way. Looking through the intellisense of the LINQ generated class I can see a PropertyChanged and PropertyChanging event, perfect! Not exactly. Here ......

Posted On Tuesday, April 15, 2008 5:39 PM

Copyright © Steve Clements | Powered by: