System.Data.SQLite
Check-in [c08310dd7d]
Not logged in

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Enhanced design-time support
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | sourceforge
Files: files | file ages | folders
SHA1: c08310dd7dabf4aedd081cd554214f3a1c57f306
User & Date: rmsimpson 2005-08-25 05:42:06
Context
2005-08-25
05:42
Enhanced schema support and bugfixes check-in: bc941432db user: rmsimpson tags: sourceforge
05:42
Enhanced design-time support check-in: c08310dd7d user: rmsimpson tags: sourceforge
03:26
Fixed registry path check-in: 14a35970e7 user: rmsimpson tags: sourceforge
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to bin/Designer/SQLiteDataObjectSupport.xml.

   107    107   		</Type>
   108    108   
   109    109   		<!--
   110    110   			Defines a type that represents a table column.
   111    111   		-->
   112    112   		<Type name="TableColumn" defaultSort="Database, Schema, Table, Ordinal">
   113    113   			<Concepts>
   114         -				<Concept name="TableColumn" restrictions="{Catalog}, null,{Table}, {Name}"/>
          114  +				<Concept name="TableColumn" restrictions="{Catalog}, null, {Table}, {Name}"/>
   115    115   			</Concepts>
   116    116   			<Identifier>
   117    117   				<Part name="Database" itemName="table_catalog">
   118    118   					<Concepts>
   119    119   						<Concept name="Identifier0"/>
   120    120   					</Concepts>
   121    121   				</Part>
................................................................................
   402    402   								</Parameter>
   403    403   							</Parameter>
   404    404   						</Parameter>
   405    405   					</Parameter>
   406    406   				</Action>
   407    407   			</Actions>
   408    408   		</Type>
   409         -	</Types>
          409  +    <!--
          410  +			Defines a type that represents an index.
          411  +		-->
          412  +    <Type name="Index" defaultSort="Database, Schema, Table, Name">
          413  +      <Concepts>
          414  +        <!--
          415  +					In SQL Server all unique keys are described as indexes, so we can map
          416  +					this type to the TableUniqueKey concept.  However not all indexes are
          417  +					unique keys, so we must filter the objects based on the IsUnique
          418  +					property.
          419  +				-->
          420  +        <Concept name="TableUniqueKey" restrictions="{Catalog},{Schema},{Table},{Name}" filter="IsUnique = true"/>
          421  +      </Concepts>
          422  +      <Identifier>
          423  +        <Part name="Database" itemName="table_catalog">
          424  +          <Concepts>
          425  +            <Concept name="Identifier0"/>
          426  +          </Concepts>
          427  +        </Part>
          428  +        <Part name="Schema" itemName="table_schema">
          429  +          <Concepts>
          430  +            <Concept name="Identifier1"/>
          431  +          </Concepts>
          432  +        </Part>
          433  +        <Part name="Table" itemName="table_name">
          434  +          <Concepts>
          435  +            <Concept name="Identifier2"/>
          436  +          </Concepts>
          437  +        </Part>
          438  +        <Part name="Name" itemName="index_name">
          439  +          <Concepts>
          440  +            <Concept name="Identifier3"/>
          441  +          </Concepts>
          442  +        </Part>
          443  +      </Identifier>
          444  +      <Properties>
          445  +        <Property name="Name" type="System.String" itemName="index_name"/>
          446  +        <Property name="IsUnique" type="System.Boolean" itemName="UNIQUE"/>
          447  +        <Property name="IsPrimary" type="System.Boolean" itemName="PRIMARY_KEY">
          448  +          <Concepts>
          449  +            <Concept name="IsPrimary"/>
          450  +          </Concepts>
          451  +        </Property>
          452  +      </Properties>
          453  +      <Actions>
          454  +        <Action name="Enumerate" guid="61CC0372-384D-42e5-9707-6D7C8DC5287A" handler="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectEnumerator">
          455  +          <Parameter value="Indexes"/>
          456  +        </Action>
          457  +        <Action name="BuildDSRef" guid="7C030900-E8DD-471b-8F18-D83DA7036144" handler="Microsoft.VisualStudio.Data.DSRefBuilder">
          458  +          <Parameter>
          459  +            <Parameter value="{2}"/>
          460  +            <Parameter value="{1}"/>
          461  +            <Parameter value="Table"/>
          462  +            <Parameter/>
          463  +            <Parameter>
          464  +              <!-- GUID_DSRefProperty_Qualifier -->
          465  +              <Parameter value="4656BAEA-F397-11ce-BFE1-00AA0057B34E">
          466  +                <Parameter value="{0}"/>
          467  +              </Parameter>
          468  +              <!-- GUID_DSRefProperty_PreciseType -->
          469  +              <Parameter value="39A5A7E7-513F-44a4-B79D-7652CD8962D9">
          470  +                <Parameter value="101" type="System.Int32"/>
          471  +                <!-- Table -->
          472  +              </Parameter>
          473  +            </Parameter>
          474  +            <Parameter>
          475  +              <Parameter>
          476  +                <Parameter value="{3}"/>
          477  +                <Parameter/>
          478  +                <Parameter value="Index"/>
          479  +              </Parameter>
          480  +            </Parameter>
          481  +          </Parameter>
          482  +        </Action>
          483  +      </Actions>
          484  +    </Type>
          485  +
          486  +    <!--
          487  +			Defines a type that represents an index column.
          488  +		-->
          489  +    <Type name="IndexColumn" defaultSort="Database, Schema, Table, Index, Ordinal">
          490  +      <Concepts>
          491  +        <Concept name="TableUniqueKeyColumn" restrictions="{Catalog},{Schema},{Table},{TableUniqueKey},{Name}"/>
          492  +      </Concepts>
          493  +      <Identifier>
          494  +        <Part name="Database" itemName="table_catalog">
          495  +          <Concepts>
          496  +            <Concept name="Identifier0"/>
          497  +          </Concepts>
          498  +        </Part>
          499  +        <Part name="Schema" itemName="table_schema">
          500  +          <Concepts>
          501  +            <Concept name="Identifier1"/>
          502  +          </Concepts>
          503  +        </Part>
          504  +        <Part name="Table" itemName="table_name">
          505  +          <Concepts>
          506  +            <Concept name="Identifier2"/>
          507  +          </Concepts>
          508  +        </Part>
          509  +        <Part name="Index" itemName="index_name">
          510  +          <Concepts>
          511  +            <Concept name="Identifier3"/>
          512  +          </Concepts>
          513  +        </Part>
          514  +        <Part name="Name" itemName="column_name">
          515  +          <Concepts>
          516  +            <Concept name="Identifier4"/>
          517  +          </Concepts>
          518  +        </Part>
          519  +      </Identifier>
          520  +      <Properties>
          521  +        <Property name="Name" type="System.String" itemName="column_name"/>
          522  +        <Property name="Ordinal" type="System.Byte" itemName="ordinal_position">
          523  +          <Concepts>
          524  +            <Concept name="Ordinal">
          525  +              <Conversion>
          526  +                <ChangeType type="System.Int32"/>
          527  +              </Conversion>
          528  +            </Concept>
          529  +          </Concepts>
          530  +        </Property>
          531  +      </Properties>
          532  +      <Actions>
          533  +        <Action name="Enumerate" guid="61CC0372-384D-42e5-9707-6D7C8DC5287A" handler="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectEnumerator">
          534  +          <Parameter value="IndexColumns"/>
          535  +        </Action>
          536  +        <Action name="BuildDSRef" guid="7C030900-E8DD-471b-8F18-D83DA7036144" handler="Microsoft.VisualStudio.Data.DSRefBuilder">
          537  +          <Parameter>
          538  +            <Parameter value="{2}"/>
          539  +            <Parameter value="{1}"/>
          540  +            <Parameter value="Table"/>
          541  +            <Parameter/>
          542  +            <Parameter>
          543  +              <!-- GUID_DSRefProperty_Qualifier -->
          544  +              <Parameter value="4656BAEA-F397-11ce-BFE1-00AA0057B34E">
          545  +                <Parameter value="{0}"/>
          546  +              </Parameter>
          547  +              <!-- GUID_DSRefProperty_PreciseType -->
          548  +              <Parameter value="39A5A7E7-513F-44a4-B79D-7652CD8962D9">
          549  +                <Parameter value="101" type="System.Int32"/>
          550  +                <!-- Table -->
          551  +              </Parameter>
          552  +            </Parameter>
          553  +            <Parameter>
          554  +              <Parameter>
          555  +                <Parameter value="{3}"/>
          556  +                <Parameter/>
          557  +                <Parameter value="Index"/>
          558  +                <Parameter/>
          559  +                <Parameter/>
          560  +                <Parameter>
          561  +                  <Parameter>
          562  +                    <Parameter value="{4}"/>
          563  +                    <Parameter/>
          564  +                    <Parameter value="Field"/>
          565  +                  </Parameter>
          566  +                </Parameter>
          567  +              </Parameter>
          568  +            </Parameter>
          569  +          </Parameter>
          570  +        </Action>
          571  +      </Actions>
          572  +    </Type>
          573  +
          574  +    <!--
          575  +			Defines a type that represents a foreign key.
          576  +		-->
          577  +    <Type name="ForeignKey" defaultSort="Database, Schema, Table, Name">
          578  +      <Concepts>
          579  +        <Concept name="TableForeignKey" restrictions="{Catalog},{Schema},{Table},{Name}"/>
          580  +      </Concepts>
          581  +      <Identifier>
          582  +        <Part name="Database" itemName="table_catalog">
          583  +          <Concepts>
          584  +            <Concept name="Identifier0"/>
          585  +          </Concepts>
          586  +        </Part>
          587  +        <Part name="Schema" itemName="table_schema">
          588  +          <Concepts>
          589  +            <Concept name="Identifier1"/>
          590  +          </Concepts>
          591  +        </Part>
          592  +        <Part name="Table" itemName="table_name">
          593  +          <Concepts>
          594  +            <Concept name="Identifier2"/>
          595  +          </Concepts>
          596  +        </Part>
          597  +        <Part name="Name" itemName="constraint_name">
          598  +          <Concepts>
          599  +            <Concept name="Identifier3"/>
          600  +          </Concepts>
          601  +        </Part>
          602  +      </Identifier>
          603  +      <Properties>
          604  +        <Property name="Name" type="System.String" itemName="constraint_name"/>
          605  +        <Property name="ReferencedTableDatabase" type="System.String" itemName="fkey_to_catalog">
          606  +          <Concepts>
          607  +            <Concept name="ReferencedTableId0"/>
          608  +          </Concepts>
          609  +        </Property>
          610  +        <Property name="ReferencedTableSchema" type="System.String" itemName="fkey_to_schema">
          611  +          <Concepts>
          612  +            <!--
          613  +							The ForeignKey type concept specifies that there should be property
          614  +							concepts that fully identify the referenced table.  These concepts
          615  +							are defined similar to the identifier concepts.  If a reference
          616  +							concept is missing (e.g. ReferencedTableId0) it is assumed to be the
          617  +							same as the main object identifier part.
          618  +						-->
          619  +            <Concept name="ReferencedTableId1"/>
          620  +          </Concepts>
          621  +        </Property>
          622  +        <Property name="ReferencedTableName" type="System.String" itemName="fkey_to_table">
          623  +          <Concepts>
          624  +            <Concept name="ReferencedTableId2"/>
          625  +          </Concepts>
          626  +        </Property>
          627  +      </Properties>
          628  +      <Actions>
          629  +        <Action name="Enumerate" guid="61CC0372-384D-42e5-9707-6D7C8DC5287A" handler="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectEnumerator">
          630  +          <Parameter value="ForeignKeys"/>
          631  +        </Action>
          632  +      </Actions>
          633  +    </Type>
          634  +
          635  +    <!--
          636  +			Defines a type that represents a foreign key column.
          637  +		-->
          638  +    <Type name="ForeignKeyColumn" defaultSort="Database, Schema, Table, ForeignKey, Ordinal">
          639  +      <Concepts>
          640  +        <Concept name="TableForeignKeyColumn" restrictions="{Catalog},{Schema},{Table},{TableForeignKey},{Name}"/>
          641  +      </Concepts>
          642  +      <Identifier>
          643  +        <Part name="Database" itemName="table_catalog">
          644  +          <Concepts>
          645  +            <Concept name="Identifier0"/>
          646  +          </Concepts>
          647  +        </Part>
          648  +        <Part name="Schema" itemName="table_schema">
          649  +          <Concepts>
          650  +            <Concept name="Identifier1"/>
          651  +          </Concepts>
          652  +        </Part>
          653  +        <Part name="Table" itemName="table_name">
          654  +          <Concepts>
          655  +            <Concept name="Identifier2"/>
          656  +          </Concepts>
          657  +        </Part>
          658  +        <Part name="ForeignKey" itemName="constraint_name">
          659  +          <Concepts>
          660  +            <Concept name="Identifier3"/>
          661  +          </Concepts>
          662  +        </Part>
          663  +        <Part name="Name" itemName="fkey_from_column">
          664  +          <Concepts>
          665  +            <Concept name="Identifier4"/>
          666  +          </Concepts>
          667  +        </Part>
          668  +      </Identifier>
          669  +      <Properties>
          670  +        <Property name="Name" type="System.String" itemName="fkey_from_column"/>
          671  +        <Property name="Ordinal" type="System.Int32" itemName="fkey_from_ordinal_position">
          672  +          <Concepts>
          673  +            <Concept name="Ordinal"/>
          674  +          </Concepts>
          675  +        </Property>
          676  +        <Property name="ReferencedColumnName" type="System.String" itemName="fkey_to_column">
          677  +          <Concepts>
          678  +            <!--
          679  +							The ForeignKeyColumn type concept specifies that there should be
          680  +							a property concept that gives the name of the referenced column
          681  +							in the referenced table.
          682  +						-->
          683  +            <Concept name="ReferencedTableColumn"/>
          684  +          </Concepts>
          685  +        </Property>
          686  +      </Properties>
          687  +      <Actions>
          688  +        <Action name="Enumerate" guid="61CC0372-384D-42e5-9707-6D7C8DC5287A" handler="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectEnumerator">
          689  +          <Parameter value="ForeignKeys"/>
          690  +        </Action>
          691  +      </Actions>
          692  +    </Type>
          693  +  </Types>
   410    694   </VSDataObjectSupport>

Changes to bin/Designer/SQLiteDesigner.reg.

     7      7   "Technology"="{77AB9A9D-78B9-4ba7-91AC-873F5338F1D2}"
     8      8   
     9      9   [HKEY_LOCAL_MACHINE\%REGROOT%\DataProviders\{0EBAAB6E-CA80-4b4a-8DDF-CBE6BF058C70}\SupportedObjects]
    10     10   
    11     11   [HKEY_LOCAL_MACHINE\%REGROOT%\DataProviders\{0EBAAB6E-CA80-4b4a-8DDF-CBE6BF058C70}\SupportedObjects\DataConnectionProperties]
    12     12   
    13     13   [HKEY_LOCAL_MACHINE\%REGROOT%\DataProviders\{0EBAAB6E-CA80-4b4a-8DDF-CBE6BF058C70}\SupportedObjects\DataConnectionSupport]
           14  +
           15  +[HKEY_LOCAL_MACHINE\%REGROOT%\DataProviders\{0EBAAB6E-CA80-4b4a-8DDF-CBE6BF058C70}\SupportedObjects\DataObjectEnumerator]
    14     16   
    15     17   [HKEY_LOCAL_MACHINE\%REGROOT%\DataProviders\{0EBAAB6E-CA80-4b4a-8DDF-CBE6BF058C70}\SupportedObjects\DataObjectSupport]
    16     18   @="SQLiteDataObjectSupport.xml"
    17     19   "Path"="%XMLPATH%"
    18     20   
    19     21   [HKEY_LOCAL_MACHINE\%REGROOT%\DataProviders\{0EBAAB6E-CA80-4b4a-8DDF-CBE6BF058C70}\SupportedObjects\DataViewSupport]
    20     22   @="SQLiteDataViewSupport.xml"