LINQ
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...
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 VB.net, not my...
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...