Click here to Skip to main content
15,887,746 members
Home / Discussions / WPF
   

WPF

 
QuestionSP1 issue Pin
Tauseef A21-Jan-09 18:55
Tauseef A21-Jan-09 18:55 
QuestionRe: SP1 issue Pin
Mark Salsbery22-Jan-09 9:47
Mark Salsbery22-Jan-09 9:47 
AnswerRe: SP1 issue Pin
Michael Sync29-Jan-09 2:20
Michael Sync29-Jan-09 2:20 
GeneralRe: SP1 issue Pin
Mark Salsbery29-Jan-09 5:28
Mark Salsbery29-Jan-09 5:28 
AnswerRe: SP1 issue Pin
Michael Sync29-Jan-09 2:19
Michael Sync29-Jan-09 2:19 
QuestionRe: SP1 issue Pin
Tauseef A29-Jan-09 23:40
Tauseef A29-Jan-09 23:40 
AnswerRe: SP1 issue Pin
Michael Sync31-Jan-09 4:57
Michael Sync31-Jan-09 4:57 
QuestionSQL Server Syncronization Pin
NetContractor21-Jan-09 15:03
NetContractor21-Jan-09 15:03 
What do people recommend for synchronizing to SQL Server 2005 databases.

My application is WPF, C#. both databases are SQL Express 2005, and I use LINQ in code for most of the access (with the odd stored proc when I wanted to go "old school").

The problem is that I need to create a template for a new customer database. When a new customer is created the default values from the database get inserted into a local SQL Express Database, adding a customer Id as a composite key to some customer specific tables. The schema of both databases is the same apart from the additional customerID fields in the target.

One option is to script the inserts; and store the scripts as embedded resources in a setup project. I find that a bit of a hassle for maintenance.
From a maintenance perspective I prefer keeping a template mdf file in a zip, uncompressing, connecting, and importing the data at run time.

So what is the best way to do it? Do I use Linq? or just iterate through all of the tables and copy row by row? Or is there a better way?

THanks.
AnswerRe: SQL Server Syncronization Pin
Pete O'Hanlon21-Jan-09 22:38
mvePete O'Hanlon21-Jan-09 22:38 
GeneralRe: SQL Server Syncronization Pin
NetContractor21-Jan-09 23:12
NetContractor21-Jan-09 23:12 
GeneralRe: SQL Server Syncronization Pin
Pete O'Hanlon21-Jan-09 23:30
mvePete O'Hanlon21-Jan-09 23:30 
QuestionChrome shows Silverlight plugin control transparent initially Pin
AshishTijare21-Jan-09 4:35
AshishTijare21-Jan-09 4:35 
AnswerRe: Chrome shows Silverlight plugin control transparent initially Pin
ColinM12321-Jan-09 12:14
ColinM12321-Jan-09 12:14 
GeneralRe: Chrome shows Silverlight plugin control transparent initially Pin
AshishTijare21-Jan-09 17:33
AshishTijare21-Jan-09 17:33 
GeneralRe: Chrome shows Silverlight plugin control transparent initially Pin
Mark Salsbery22-Jan-09 9:52
Mark Salsbery22-Jan-09 9:52 
GeneralRe: Chrome shows Silverlight plugin control transparent initially Pin
Kevin McFarlane24-Jan-09 4:13
Kevin McFarlane24-Jan-09 4:13 
QuestionTreeView in a ListView Pin
Jesper Nordestgaard20-Jan-09 23:35
Jesper Nordestgaard20-Jan-09 23:35 
AnswerRe: TreeView in a ListView Pin
ColinM12321-Jan-09 11:40
ColinM12321-Jan-09 11:40 
AnswerRe: TreeView in a ListView Pin
Pete O'Hanlon21-Jan-09 22:41
mvePete O'Hanlon21-Jan-09 22:41 
QuestionRadio Button Group Problem Pin
Xaverria20-Jan-09 17:23
Xaverria20-Jan-09 17:23 
AnswerRe: Radio Button Group Problem Pin
ColinM12321-Jan-09 12:05
ColinM12321-Jan-09 12:05 
AnswerRe: Radio Button Group Problem Pin
Pete O'Hanlon21-Jan-09 22:36
mvePete O'Hanlon21-Jan-09 22:36 
QuestionNeed to create a sidebar aplication using WPF Pin
garima_sri_0820-Jan-09 0:51
garima_sri_0820-Jan-09 0:51 
AnswerRe: Need to create a sidebar aplication using WPF Pin
User 27100920-Jan-09 3:20
User 27100920-Jan-09 3:20 
AnswerRe: Need to create a sidebar aplication using WPF Pin
Not Active20-Jan-09 6:39
mentorNot Active20-Jan-09 6:39 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.