I am working on windows application from where user will be able to get the backup of .sdf file and later user will be able to restore the .sdf file.
Before file restoring file from my .Net application, I want to check whether user has selected valid file (having same database schema).
So if some one has idea to do this then please give suggestion.
You can connect to the two databases with SqlCeConnections, then use the GetSchema command to retrieve data about table/column structure. Then you will need to walk through the contents of the tables and make sure all the fields match.
Have you considered using some sort of versioning in your databases with a compatibility list? For instance, have a table Version with a single column/row of the version number in your database, say VersonNumber. Then your application knows that, say, version 1.05 - 1.09 are all compatible with each other, but 1.10 is not, etc. If that Version table is missing completely (or contains an invalid version number), then you automatically know it is not a valid .sdf file for your application.
As a learning experience I recently tried implementing Quicksort with 3 way partitioning in C#. Apart from needing to add an extra range check on the left/right variables before the recursive call, ...
I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...
I have two EF entities. One has a property called HouseNumber. The other has two properties, one called StartHouseNumber and one called EndHouseNumber. I want to create a many to many association ...
I m using decimal type (.net), and I want to see if two numbers are equal. But I only want to be accurate to 10 decimal places. For example take these three numbers. I want them all to be equal. 0....
I m creating an STA version of the SynchronizationContext for use in Windows Workflow 4.0. I m wondering what to do about exceptions when Post-ing callbacks. The SynchronizationContext can be used ...
I ve got some code which sets up a datacontext. Often enough, the datacontext should be set to some underlying data collection, such as an ObservableCollection - but occasionally I d like to set it ...
I am building an application with C#. I managed to turn this into a single instance application by checking if the same process is already running. Process[] pname = Process.GetProcessesByName("...
NOTE I have asked the related question (with an accepted answer): How to combine DataTrigger and Trigger? I think I need to combine an EventTrigger and a DataTrigger to achieve what I m after: when ...
