RE: from XML to SqlCE

From: Jon Heide (jonhp_at_online.microsoft.com)
Date: 04/07/04

  • Next message: Prasanna Sampath [MSFT]: "Re: Working Sample for EVC++ 4 and SQL CE" 
    Date: Wed, 07 Apr 2004 17:23:53 GMT

    Hi Enrico,

    Yes, you can load the XML into a data set and then into SQL CE. Unfortunately, you will have to create the schema in the database prior to
    loading the dataset, as there is no way for the dataset to create the database schema on the fly. You will need to parse your XML schema,
    create the corresponding database, and load the dataset. For more information on datasets see the books online at:
    http://www.microsoft.com/sql/ce/techinfo/20bol.asp

    Thanks,
    Jon Heide
    (jonhp@microsoft.com)
    SQL Server CE Team
    Microsoft

    ----------------------------------------------------------------------------

    Everything you need to know about SQL Server CE:

    http://www.microsoft.com/sql/ce/techinfo/default.asp

    ----------------------------------------------------------------------------

    This posting is provided "AS IS" with no warranties, and confers no rights.

    Use of included script samples are subject to the terms specified at

    http://www.microsoft.com/info/cpyright.htm.

    ----------------------------------------------------------------------------

  • Next message: Prasanna Sampath [MSFT]: "Re: Working Sample for EVC++ 4 and SQL CE"

    Relevant Pages

    • Re: Another idea from pick goes mainstream...
      ... A relational database has nothing to do ... SQL is one of the ... is now considered THE language for any dbms implementing the relational ... Then, XML came out. ...
      (comp.databases.pick)
    • Split messages
      ... This is based off the northwind database. ... Create document schema: ... Select the SQL entry, make sure that we are pointing to the SQL ... For the item select a receive pipeline and name it EmpSplitPipe.btp. ...
      (microsoft.public.biztalk.general)
    • Re: Deviation from object-relational mapping (pySQLFace)
      ... Its goal to separate relational database stuff from algorythmic ... file (XML). ... It provides callable command objects for each sql query. ...
      (comp.lang.python)
    • 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: Data Insertion
      ... Ilya ... fix for loading XML into the DataSet. ... > Are there any benchmarks for data insertion with SQL CE and ADO.net? ... Load ~1 MB XML file into the DataSet with schema preloaded (3 nested ...
      (microsoft.public.dotnet.framework.compactframework)