I tend to forget how to insert into another table from selecting the data form another table so here is an upgrade snippet for next time.

INSERT INTO [FieldExplorer].[dbo].[Field_Guide_Annotations]
([Record_ID],[Value],[Type],[Table_ID]) Select [Id],
[Definition], 0,6 From [FieldExplorer].[dbo].[Field_Details] Where [Definition] isnotNULL

Under the remarks section for System.IO.File.Replace in the MSDN documentation there is mention that an exception will be thrown  if the volume(drive) is different between the source and destination paths.

If the sourceFileName and destinationFileName are on different volumes, this method will raise an exception.

There is no mention in the exception section what type of System.IO.IOException you will receive in this case.

I found that when the volume for the destination and the source files differ you will receive:

System.IO.IOException: Unable to move the replacement file to the file to be replaced. The file to be replaced has retained its original name.

System.IO.FileInfo.Replace will also throw the above exception when the destination volume differs from the source file’s volume.  However the Documentation for System.IO.FileInfo.Replace makes no mention of this error condition.

I thought I would take a minute and tell you about my new favorite website www.somesite.com it took seconds for me to fall in love with it and I think if you are a web developer working on your local box you will too.  Somesite.com and *Somesite.com resolves to 127.0.0.1 in other words it can serve as a replacement for localhost. 

I can’t find any  whois info the somesite.com domain so depend on it at your own risk.

• Kevin's WPF Bag-o-Tricks
• Smart Border
• Microsoft® Health Common User Interface Control Toolkit

Community

• NETIKA - GOA Toolkit
• VISIfire Silverlight & WPF Charts
• Silverlight rich text editor
• Vectorlight-Liquid Silverlight Controls
• Silverlight applications in No Time - Visual WebGui Framework
• Silverlight P2P Library
• BlackLight
• Silverlight toolkit demo
• silverlight toolkit
• Patient Journey Demonstrator
• Microsoft® Health Common User Interface Control Toolkit
• Silverlight Contrib / SilverLight Extenxsions (These are merging into one project)

Third Party Silverlight controls

• ComponentOne - Studio for Silverlight
• Telerik RadControls for Silverlight
• Infragistics- NetAdvantage Silverlight
• Devexpress - Silverlight Controls

I found this video on visitmix.com  outlining the Microsoft BizSpark program which if you are a startup or contemplating becoming one you qualify for.  You receive Microsoft products and support for 25 developers.  Your supposed to be a private company but evidently if you still qualify if you will form a company with in 12 months of signing up.  Check out the full video

I installed IE 8 today.  you can down load it from http://www.microsoft.com/windows/internet-explorer/worldwide-sites.aspx  over all I don’t see much difference.  I am disappointed they did not pick up Chrome’s tear out tabs.  Disappointed that they didn’t add Opera’s fast forward.  It’s nifty to have the developer tool bar in IE by default, though honestly who uses that? why distribute it to all internet users?  web slices, is a proprietary waste. I just want an unobtrusive browser.  I appreciate that while 8 breaks several websites it is more standards compliant, this site renders better under 8 then 7 or 6. 

Microsoft says ie 8 is just the beginning, which is good because they still have a lot of catching up to do.

I had a short hall way conversation with a co-worker regarding programming in the real world.  Or in other words meeting your dead line at any cost.  His contention was that in order to meet his dead line, it’s better to give up on layered architecture and mix the  UI, business,  and data access.  That this is fast and produced the desired end results.

I agree that his team is producing the desired end results, So it’s very difficult to argue over code structure.  But This is a green field project, and already no structure.  There is little doubt in my mind that at some point, a feature will be dropped because the code/framework was just to much of an obstruction . 

I think it is important to remember that the quality of our deliverables is in the code as well as the GUI.   Maintenance counts.

I wanted to create a list of useful design information for user access rights.   This isn’t such a common term in the industry just in our office.  What we really want to talk about is user authorization.  Authorization can be broken into two main listings Access Control Lists(ACL) and Role Based Access Control(RBAC)

ACL

Access control list(wikipedia )

Access Control Lists & Access Control Objects, good tutorial?(stackoverflow)

Access Control List

RBAC

How to build role-based access control in SQL

How To: Use Authorization Manager (AzMan) with ASP.NET 2.0

What Is Authorization Manager

Implementing Role Based Security using CSharp

Role-Based Security