‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
Well, you need to install it. You’re looking for: The 2007 Office System Driver: Data Connectivity Components.
.net
How do I run Visual Studio as an administrator by default?
Copied and pasted from here, the Using Advanced Properties section. This will allow you to always have the program run as an administrator when you open it. Right click on the shortcut of the program, then click on Properties. Click on the Shortcut tab for a program shortcut, then click on the Advanced button. Check … Read more
What does the Visual Studio “Any CPU” target mean?
An AnyCPU assembly will JIT to 64-bit code when loaded into a 64-bit process and 32 bit when loaded into a 32-bit process. By limiting the CPU you would be saying: There is something being used by the assembly (something likely unmanaged) that requires 32 bits or 64 bits.
LINQ: When to use SingleOrDefault vs. FirstOrDefault() with filtering criteria
If your result set returns 0 records: SingleOrDefault returns the default value for the type (e.g. default for int is 0) FirstOrDefault returns the default value for the type If you result set returns 1 record: SingleOrDefault returns that record FirstOrDefault returns that record If your result set returns many records: SingleOrDefault throws an exception … Read more
“The breakpoint will not currently be hit. The source code is different from the original version.” What does this mean?
As it says, the “source code is different from the original version”. Right click on the project folder inside the solution explorer and choose to Clean. Build a new version of the project and the breakpoint will work again!
How do you get a string from a MemoryStream?
This sample shows how to read and write a string to a MemoryStream. Imports System.IO Module Module1 Sub Main() ‘ We don’t need to dispose any of the MemoryStream ‘ because it is a managed object. However, just for ‘ good practice, we’ll close the MemoryStream. Using ms As New MemoryStream Dim sw As New … Read more
Is it better to call ToList() or ToArray() in LINQ queries?
Unless you simply need an array to meet other constraints you should use ToList. In the majority of scenarios ToArray will allocate more memory than ToList. Both use arrays for storage, but ToList has a more flexible constraint. It needs the array to be at least as large as the number of elements in the … Read more
System.Timers.Timer vs System.Threading.Timer
This article offers a fairly comprehensive explanation: “Comparing the Timer Classes in the .NET Framework Class Library” – also available as a .chm file The specific difference appears to be that System.Timers.Timer is geared towards multithreaded applications and is therefore thread-safe via its SynchronizationObject property, whereas System.Threading.Timer is ironically not thread-safe out-of-the-box. I don’t believe … Read more
How do I use WPF bindings with RelativeSource?
If you want to bind to another property on the object: {Binding Path=PathToProperty, RelativeSource={RelativeSource Self}} If you want to get a property on an ancestor: {Binding Path=PathToProperty, RelativeSource={RelativeSource AncestorType={x:Type typeOfAncestor}}} If you want to get a property on the templated parent (so you can do 2 way bindings in a ControlTemplate) {Binding Path=PathToProperty, RelativeSource={RelativeSource TemplatedParent}} … Read more
In WPF, what are the differences between the x:Name and Name attributes?
There really is only one name in XAML, the x:Name. A framework, such as WPF, can optionally map one of its properties to XAML’s x:Name by using the RuntimeNamePropertyAttribute on the class that designates one of the classes properties as mapping to the x:Name attribute of XAML. The reason this was done was to allow … Read more