I have a bunch of xsd files I _have_ imported into a dataset. I want to
create a sql ce (3.0) database with the same schema.
What are my options?
- Should I use DataAdapters and Update() the schema to the database? Is this
even possible?
- Is it better to load the schema into the database directly from the
xsd-files?
- Should I create each table using a SqlCeCommand with commandtext taken
from the dataset structure?
- BulkCopy?
Re: Decouple SQL queries from class in OOP design ... If the data is owned by the application, embedding SQL might be ... - It couples the application to the database schema.... - The "validate employee ID" functionality is likely to be used ... (comp.object)
RE: SQL Adapter ... Did you add the SQL schema with the 'Add Generated Items - Add Adapter' wizard. ...Target namespace and Request and Response root element name. ... > have to be inserted in an SQL Database.... (microsoft.public.biztalk.general)
Re: Java is becoming the new Cobol ... In the Unisys 2200 environment using their Network Database Server, you get a schema work area depending on how you invoke the schema. ... However, it not only copies the schema area into the program, but the "DMCA" (Database Management Communication Area - basically, the block of information that holds your connection state) is copied in too. ... So, you're left with working-storage, which makes it visible to your program only, or common-storage, which makes it visible to programs linked in. ... (comp.lang.cobol)
RE: from XML to SqlCE ... you can load the XML into a data set and then into SQL CE. ... as there is no way for the dataset to create the database schema on the fly. ... (microsoft.public.sqlserver.ce)
Re: getting order position ... Step away from the database before you hurt yourself and others:) ... In chapter one of the SQL book you never read, ... Language" -- it controls access to the data and the schema.... And what does it represent in the reality from ... (microsoft.public.sqlserver.programming)
