Click here to Skip to main content
15,902,635 members
Home / Discussions / C#
   

C#

 
RantRe: Error: "type name expected, but namespace name found" on calling a .WSDL Pin
Nagy Vilmos17-Feb-09 6:12
professionalNagy Vilmos17-Feb-09 6:12 
GeneralRe: Error: "type name expected, but namespace name found" on calling a .WSDL Pin
expresso100016-Sep-09 11:17
expresso100016-Sep-09 11:17 
GeneralRe: Error: "type name expected, but namespace name found" on calling a .WSDL Pin
Nagy Vilmos17-Sep-09 0:38
professionalNagy Vilmos17-Sep-09 0:38 
QuestionCrystalReports how to Reset Record Number ? Pin
leeoze17-Feb-09 4:19
leeoze17-Feb-09 4:19 
AnswerHere is the answer... Pin
leeoze17-Feb-09 4:32
leeoze17-Feb-09 4:32 
GeneralRe: Here is the answer... Pin
Ennis Ray Lynch, Jr.17-Feb-09 4:42
Ennis Ray Lynch, Jr.17-Feb-09 4:42 
QuestionRetrieve a full CE database Pin
J-Cop17-Feb-09 4:15
J-Cop17-Feb-09 4:15 
AnswerRe: Retrieve a full CE database Pin
Wendelius17-Feb-09 8:20
mentorWendelius17-Feb-09 8:20 
Jacob Flarup wrote:
I am guessing I have to do it with code since Express doesn't support replication


Express supports replication but not in this scenario. Express can be a subscriber if you have a Standard edition which acts as a publisher.

To the main question: I'm not sure that I would use SMO. Instead I think I would use SqlBulkCopy[^] against the Express database and use data reader against the CE database. This way I could load all the data from the CE database to the Express database (of course to different tables or even different database).

After loading the data you could use SQL (and procedures etc) to compare the contents. Of course this could be done using datasets in C# but if you have lots of data, I think the comparison will be more efficient in the database. If you have only small amounts of data you could fill one dataset from CE and another dataset from Express and compare the contents of the datatables in the datasets. SELECT * should fill a datatable nicely.

Hope this helps,

Mika

The need to optimize rises from a bad design.My articles[^]

Questionhow to show massage before form is load Pin
E_Gold17-Feb-09 3:22
E_Gold17-Feb-09 3:22 
AnswerRe: how to show massage before form is load Pin
EliottA17-Feb-09 3:39
EliottA17-Feb-09 3:39 
JokeRe: how to show massage before form is load Pin
Kristian Sixhøj17-Feb-09 4:18
Kristian Sixhøj17-Feb-09 4:18 
GeneralRe: how to show massage before form is load Pin
Rutvik Dave17-Feb-09 6:39
professionalRutvik Dave17-Feb-09 6:39 
GeneralRe: how to show massage before form is load Pin
E_Gold17-Feb-09 8:21
E_Gold17-Feb-09 8:21 
GeneralRe: how to show massage before form is load Pin
Rutvik Dave17-Feb-09 8:26
professionalRutvik Dave17-Feb-09 8:26 
AnswerRe: how to show massage before form is load Pin
Tony Pottier17-Feb-09 4:32
Tony Pottier17-Feb-09 4:32 
GeneralRe: how to show massage before form is load Pin
E_Gold17-Feb-09 4:57
E_Gold17-Feb-09 4:57 
GeneralRe: how to show massage before form is load Pin
Tony Pottier17-Feb-09 6:40
Tony Pottier17-Feb-09 6:40 
AnswerRe: how to show massage before form is load Pin
Xmen Real 17-Feb-09 5:14
professional Xmen Real 17-Feb-09 5:14 
AnswerRe: how to show massage before form is load Pin
Rutvik Dave17-Feb-09 6:32
professionalRutvik Dave17-Feb-09 6:32 
QuestionProperty vs Public Variable Pin
Anurag Gandhi17-Feb-09 3:18
professionalAnurag Gandhi17-Feb-09 3:18 
AnswerRe: Property vs Public Variable Pin
Eddy Vluggen17-Feb-09 3:30
professionalEddy Vluggen17-Feb-09 3:30 
GeneralRe: Property vs Public Variable Pin
PIEBALDconsult17-Feb-09 5:30
mvePIEBALDconsult17-Feb-09 5:30 
GeneralRe: Property vs Public Variable Pin
Eddy Vluggen17-Feb-09 6:29
professionalEddy Vluggen17-Feb-09 6:29 
GeneralRe: Property vs Public Variable Pin
PIEBALDconsult17-Feb-09 6:36
mvePIEBALDconsult17-Feb-09 6:36 
AnswerRe: Property vs Public Variable Pin
EliottA17-Feb-09 3:39
EliottA17-Feb-09 3: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.