Because Stage is required, all one-to-many relationships where Stage is involved will have cascading delete enabled by default. It means, if you delete a Stage entity the delete will cascade directly to Side the delete will cascade directly to Card and because Card and Side have a required one-to-many relationship with cascading delete enabled by … Read more
It is rare, in reality, that you would want to use an array. Definitely use a List<T> any time you want to add/remove data, since resizing arrays is expensive. If you know the data is fixed length, and you want to micro-optimise for some very specific reason (after benchmarking), then an array may be useful. … Read more
P7 and P8 are the important ones to find out where the P9 exception was raised. Use P4 to know what assembly to look for. Run ildasm.exe and open that assembly. File + Dump, tick the “Token values” checkbox, OK and save the .il file somewhere. Open the file in a text editor. P7 gives … Read more
I have an article on this very topic. (It has lots of examples.) In essence, a closure is a block of code which can be executed at a later time, but which maintains the environment in which it was first created – i.e. it can still use the local variables etc of the method which … Read more
‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
One solution is to install both x86 (32-bit) and x64 Oracle Clients on your machine, then it does not matter on which architecture your application is running. Here an instruction to install x86 and x64 Oracle client on one machine: Assumptions: Oracle Home is called OraClient11g_home1, Client Version is 11gR2 Optionally remove any installed Oracle … Read more
Are there any disadvantages using the IDisposable Interace Sure, it accomplishes absolutely nothing. Using Using or calling Dispose() is never an appropriate way to set a variable to Nothing. Which is all that your code does. We completely avoid to use the two dot rule. Feel free to continue to ignore it, it is nonsense … Read more
Binding generally doesn’t work to fields. Most binding is based, in part, on the ComponentModel PropertyDescriptor model, which (by default) works on properties. This enables notifications, validation, etc (none of which works with fields). For more reasons than I can go into, public fields are a bad idea. They should be properties, fact. Likewise, mutable … Read more
Option Explicit means that all variables must be declared. See here. Without this, you can accidentally declare a new variable just by misspelling another variable name. This is one of those things that cause a lot of grief as you’re trying to debug VB programs and figure out why your program isn’t working properly. In … Read more
Connection pooling is handled as in any other ADO.NET application. Entity connection still uses traditional database connection with traditional connection string. I believe you can turn off connnection pooling in connection string if you don’t want to use it. (read more about SQL Server Connection Pooling (ADO.NET)) Never ever use global context. ObjectContext internally implements … Read more