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

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

Overview
Comment:no message
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | sourceforge
Files: files | file ages | folders
SHA1: bc0a931347d4d3ce9c7d750aec3c8852a2139da0
User & Date: rmsimpson 2006-01-31 05:29:47
Context
2006-01-31
19:11
1.0.25.0 check-in: c0022ffcbd user: rmsimpson tags: sourceforge
05:29
no message check-in: bc0a931347 user: rmsimpson tags: sourceforge
2006-01-30
23:22
Updates in progress check-in: d55e8be2bc user: rmsimpson tags: sourceforge
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to SQLite.Designer/SQLite.Designer.csproj.

    29     29       <Optimize>true</Optimize>
    30     30       <OutputPath>..\bin\Designer\</OutputPath>
    31     31       <DefineConstants>
    32     32       </DefineConstants>
    33     33       <ErrorReport>prompt</ErrorReport>
    34     34       <WarningLevel>4</WarningLevel>
    35     35       <NoWarn>1701;1702;1699</NoWarn>
           36  +    <FileAlignment>512</FileAlignment>
    36     37     </PropertyGroup>
    37     38     <ItemGroup>
    38     39       <Reference Include="Microsoft.VisualStudio.Data, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL">
    39     40         <SpecificVersion>False</SpecificVersion>
    40     41         <HintPath>..\..\..\VSNET2005\Common7\IDE\Microsoft.VisualStudio.Data.dll</HintPath>
           42  +      <Private>False</Private>
    41     43       </Reference>
    42     44       <Reference Include="Microsoft.VisualStudio.OLE.Interop, Version=7.1.40304.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
    43     45         <SpecificVersion>False</SpecificVersion>
    44     46       </Reference>
    45     47       <Reference Include="System" />
    46     48       <Reference Include="System.Data" />
    47     49       <Reference Include="System.Drawing" />

Changes to SQLite.Designer/SQLiteConnectionUIControl.Designer.cs.

   118    118         // 
   119    119         // encodingGroup
   120    120         // 
   121    121         encodingGroup.Controls.Add(this.utf16RadioButton);
   122    122         encodingGroup.Controls.Add(this.utf8RadioButton);
   123    123         encodingGroup.Location = new System.Drawing.Point(12, 191);
   124    124         encodingGroup.Name = "encodingGroup";
   125         -      encodingGroup.Size = new System.Drawing.Size(81, 98);
          125  +      encodingGroup.Size = new System.Drawing.Size(75, 98);
   126    126         encodingGroup.TabIndex = 7;
   127    127         encodingGroup.TabStop = false;
   128    128         encodingGroup.Text = "Encoding";
   129    129         // 
   130    130         // utf16RadioButton
   131    131         // 
   132    132         this.utf16RadioButton.AutoSize = true;
................................................................................
   150    150         this.utf8RadioButton.Text = "UTF-8";
   151    151         this.utf8RadioButton.UseVisualStyleBackColor = true;
   152    152         // 
   153    153         // dateTimeGroup
   154    154         // 
   155    155         dateTimeGroup.Controls.Add(this.ticksRadioButton);
   156    156         dateTimeGroup.Controls.Add(this.iso8601RadioButton);
   157         -      dateTimeGroup.Location = new System.Drawing.Point(99, 191);
          157  +      dateTimeGroup.Location = new System.Drawing.Point(93, 191);
   158    158         dateTimeGroup.Name = "dateTimeGroup";
   159         -      dateTimeGroup.Size = new System.Drawing.Size(107, 98);
          159  +      dateTimeGroup.Size = new System.Drawing.Size(113, 98);
   160    160         dateTimeGroup.TabIndex = 8;
   161    161         dateTimeGroup.TabStop = false;
   162    162         dateTimeGroup.Text = "Date/Time Format";
   163    163         // 
   164    164         // ticksRadioButton
   165    165         // 
   166    166         this.ticksRadioButton.AutoSize = true;
................................................................................
   245    245         // 
   246    246         this.browseButton.Location = new System.Drawing.Point(6, 47);
   247    247         this.browseButton.Name = "browseButton";
   248    248         this.browseButton.Size = new System.Drawing.Size(75, 23);
   249    249         this.browseButton.TabIndex = 1;
   250    250         this.browseButton.Text = "&Browse ...";
   251    251         this.browseButton.UseVisualStyleBackColor = true;
          252  +      this.browseButton.Click += new System.EventHandler(this.browseButton_Click);
   252    253         // 
   253    254         // newDatabase
   254    255         // 
   255    256         this.newDatabase.Location = new System.Drawing.Point(87, 47);
   256    257         this.newDatabase.Name = "newDatabase";
   257    258         this.newDatabase.Size = new System.Drawing.Size(75, 23);
   258    259         this.newDatabase.TabIndex = 2;
   259    260         this.newDatabase.Text = "&New ...";
   260    261         this.newDatabase.UseVisualStyleBackColor = true;
          262  +      this.newDatabase.Click += new System.EventHandler(this.newDatabase_Click);
   261    263         // 
   262    264         // syncGroup
   263    265         // 
   264    266         syncGroup.Controls.Add(this.offRadioButton);
   265    267         syncGroup.Controls.Add(this.normalRadioButton);
   266    268         syncGroup.Controls.Add(this.fullRadioButton);
   267    269         syncGroup.Location = new System.Drawing.Point(213, 191);

Changes to SQLite.Designer/SQLiteConnectionUIControl.cs.

     9      9   namespace SQLite.Designer
    10     10   {
    11     11     public partial class SQLiteConnectionUIControl : Form
    12     12     {
    13     13       public SQLiteConnectionUIControl()
    14     14       {
    15     15         InitializeComponent();
           16  +    }
           17  +
           18  +    private void browseButton_Click(object sender, EventArgs e)
           19  +    {
           20  +
           21  +    }
           22  +
           23  +    private void newDatabase_Click(object sender, EventArgs e)
           24  +    {
           25  +
    16     26       }
    17     27     }
    18     28   }

Changes to SQLite.Designer/SQLiteConnectionUIControl.resx.

   118    118       <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
   119    119     </resheader>
   120    120     <metadata name="labelPassword.GenerateMember" type="System.Boolean, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
   121    121       <value>False</value>
   122    122     </metadata>
   123    123     <metadata name="securityGroup.GenerateMember" type="System.Boolean, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
   124    124       <value>False</value>
          125  +  </metadata>
          126  +  <metadata name="labelConfirm.GenerateMember" type="System.Boolean, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
          127  +    <value>False</value>
   125    128     </metadata>
   126    129     <metadata name="labelConfirm.GenerateMember" type="System.Boolean, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
   127    130       <value>False</value>
   128    131     </metadata>
   129    132     <metadata name="encodingGroup.GenerateMember" type="System.Boolean, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
   130    133       <value>False</value>
   131    134     </metadata>

Changes to SQLite.Designer/SQLiteDataConnectionSupport.cs.

    12     12     using System.Text;
    13     13     using Microsoft.VisualStudio.Data;
    14     14     using Microsoft.VisualStudio.OLE.Interop;
    15     15     using Microsoft.VisualStudio.Data.AdoDotNet;
    16     16   
    17     17     internal class SQLiteDataConnectionSupport : AdoDotNetConnectionSupport
    18     18     {
           19  +    private SQLiteDataViewSupport _dataViewSupport;
           20  +    private SQLiteDataObjectSupport _dataObjectSupport;
           21  +    private SQLiteDataObjectIdentifierResolver _dataObjectIdentifierResolver;
           22  +
    19     23       public SQLiteDataConnectionSupport()
    20     24         : base("System.Data.SQLite")
    21     25       {
    22     26       }
    23     27   
    24     28       protected override DataSourceInformation CreateDataSourceInformation()
    25     29       {
    26         -      return base.CreateDataSourceInformation();
    27         -    }
    28         -
    29         -    public override int CompareVersions(string versionA, string versionB)
    30         -    {
    31         -      return base.CompareVersions(versionA, versionB);
           30  +      return new SQLiteDataSourceInformation(Site as DataConnection);
    32     31       }
    33     32   
    34     33       protected override object GetServiceImpl(Type serviceType)
    35     34       {
    36     35         if (serviceType == typeof(DataViewSupport))
    37         -        return new SQLiteDataViewSupport();
           36  +      {
           37  +        if (_dataViewSupport == null) _dataViewSupport = new SQLiteDataViewSupport();
           38  +        return _dataViewSupport;
           39  +      }
    38     40   
    39     41         if (serviceType == typeof(DataObjectSupport))
    40         -        return new SQLiteDataObjectSupport();
           42  +      {
           43  +        if (_dataObjectSupport == null) _dataObjectSupport = new SQLiteDataObjectSupport();
           44  +        return _dataObjectSupport;
           45  +      }
           46  +
           47  +      if (serviceType == typeof(DataObjectIdentifierResolver))
           48  +      {
           49  +        if (_dataObjectIdentifierResolver == null) _dataObjectIdentifierResolver = new SQLiteDataObjectIdentifierResolver(Site);
           50  +        return _dataObjectIdentifierResolver;
           51  +      }
    41     52   
    42     53         return base.GetServiceImpl(serviceType);
    43     54       }
    44         -
    45         -    public override void Initialize(object providerObj)
    46         -    {
    47         -      base.Initialize(providerObj);
    48         -    }
    49         -
    50         -    public override object ProviderObject
    51         -    {
    52         -      get
    53         -      {
    54         -        return base.ProviderObject;
    55         -      }
    56         -    }
    57     55     }
    58     56   }

Changes to SQLite.Designer/SQLiteDataObjectIdentifierResolver.cs.

    16     16     internal class SQLiteDataObjectIdentifierResolver : DataObjectIdentifierResolver, IObjectWithSite
    17     17     {
    18     18       private DataConnection _connection;
    19     19   
    20     20       public SQLiteDataObjectIdentifierResolver()
    21     21       {
    22     22       }
           23  +
           24  +    internal SQLiteDataObjectIdentifierResolver(object site)
           25  +    {
           26  +      _connection = site as DataConnection;
           27  +    }
    23     28   
    24     29       protected override object[] QuickExpandIdentifier(string typeName, object[] partialIdentifier)
    25     30       {
    26     31         if (typeName == null)
    27     32         {
    28     33           throw new ArgumentNullException("typeName");
    29     34         }

Changes to bin/Designer/Install.cmd.

     1      1   @ECHO OFF
     2      2   
     3      3   SETLOCAL
     4      4   
     5      5   SET MYDIR=%~dp0
     6      6   SET REGROOT=SOFTWARE\Microsoft\VisualStudio\8.0
     7         -SET XMLPATH=%MYDIR%
     8      7   
     9      8   :ParseCmdLine
    10      9   
    11     10   IF "%1"=="" GOTO Main
    12     11   IF "%1"=="/regroot" IF NOT "%~2"=="" SET REGROOT=%~2& SHIFT & GOTO NextCmdLine
    13     12   IF "%1"=="/xmlpath" IF NOT "%~2"=="" SET XMLPATH=%~f2& SHIFT & GOTO NextCmdLine
    14     13   IF "%1"=="/?" GOTO Help
................................................................................
    19     18   SHIFT
    20     19   GOTO ParseCmdLine
    21     20   
    22     21   :Main
    23     22   
    24     23   ECHO Installing DDEX Data Provider for SQLite
    25     24   ECHO   VS Registry Root: %REGROOT%
    26         -ECHO   XML File Path:    %XMLPATH%
    27     25   ECHO   SQLite.DLL Path:  %MYDIR%..\
    28     26   
    29         -IF NOT EXIST "%XMLPATH%\SQLiteDataViewSupport.xml" ECHO The data view support XML file was not found.& GOTO End
    30         -IF NOT EXIST "%XMLPATH%\SQLiteDataObjectSupport.xml" ECHO The data object support XML file was not found.& GOTO End
    31     27   IF NOT EXIST "..\System.Data.SQLite.DLL" ECHO The ..\System.Data.SQLite.DLL could not be found.& GOTO End
    32     28   
    33         -CScript //D "%MYDIR%\Install.vbs" //NoLogo "%REGROOT%" "%XMLPATH%"
           29  +CScript //D "%MYDIR%\Install.vbs" //NoLogo "%REGROOT%" "%MYDIR%"
    34     30   
    35     31   GOTO End
    36     32   
    37     33   :Help
    38     34   
    39     35   ECHO DDEX Data Provider for SQLite Installation
    40         -ECHO   Usage: install [/?] [/regroot ^<regroot^>] [/xmlpath ^<xmlpath^>]
           36  +ECHO   Usage: install [/?] [/regroot ^<regroot^>]
    41     37   
    42     38   :End
    43     39   
    44     40   ECHO Done!
    45     41   
    46     42   ENDLOCAL

Deleted bin/Designer/SQLiteDataObjectSupport.xml.

     1         -<?xml version="1.0" encoding="utf-8"?> 
     2         -
     3         -<!--
     4         -/********************************************************
     5         - * ADO.NET 2.0 Data Provider for SQLite Version 3.X
     6         - * Written by Robert Simpson (robert@blackcastlesoft.com)
     7         - * 
     8         - * Released to the public domain, use at your own risk!
     9         - ********************************************************/
    10         --->
    11         -
    12         -<VSDataObjectSupport xmlns="http://tempuri.org/VSDataObjectSupport.xsd">
    13         -	<Types>
    14         -		<RootType>
    15         -			<Properties>
    16         -        <Property name="Server" type="System.String" itemName="DataSource"/>
    17         -        <Property name="Database" type="System.String" itemName="Database"/>
    18         -      </Properties>
    19         -			<Actions>
    20         -				<Action name="Enumerate" guid="61CC0372-384D-42e5-9707-6D7C8DC5287A" handler="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetRootObjectEnumerator"/>
    21         -			</Actions>
    22         -		</RootType>
    23         -
    24         -		<Type name="Table" defaultSort="Database,Schema,Name">
    25         -			<Concepts>
    26         -				<Concept name="Table" restrictions="{Catalog},null,{Name},TABLE"/>
    27         -			</Concepts>
    28         -			<Identifier>
    29         -				<Part name="Database" itemName="table_catalog">
    30         -					<Concepts>
    31         -						<Concept name="Identifier0"/>
    32         -					</Concepts>
    33         -				</Part>
    34         -				<Part name="Schema" itemName="table_schema">
    35         -					<Concepts>
    36         -						<Concept name="Identifier1"/>
    37         -					</Concepts>
    38         -				</Part>
    39         -				<Part name="Name" itemName="table_name">
    40         -					<Concepts>
    41         -						<Concept name="Identifier2"/>
    42         -					</Concepts>
    43         -				</Part>
    44         -			</Identifier>
    45         -			<Restrictions>
    46         -				<Restriction name="Database"/>
    47         -				<Restriction name="Schema"/>
    48         -				<Restriction name="Name"/>
    49         -				<Restriction name="Type"/>
    50         -			</Restrictions>
    51         -			<Properties>
    52         -				<Property name="Name" type="System.String" itemName="table_name"/>
    53         -				<Property name="Schema" type="System.String" itemName="table_schema"/>
    54         -				<Property name="Type" type="System.String" itemName="table_type"/>
    55         -			</Properties>
    56         -			<Actions>
    57         -				<Action name="Enumerate" guid="61CC0372-384D-42e5-9707-6D7C8DC5287A" handler="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectEnumerator">
    58         -					<Parameter value="Tables"/>
    59         -				</Action>
    60         -				<Action name="BuildDSRef" guid="7C030900-E8DD-471b-8F18-D83DA7036144" handler="Microsoft.VisualStudio.Data.DSRefBuilder">
    61         -					<Parameter>
    62         -						<Parameter value="{2}"/>
    63         -						<Parameter value="{1}"/>
    64         -						<Parameter value="Table"/>
    65         -						<Parameter/>
    66         -						<Parameter>
    67         -							<!-- GUID_DSRefProperty_PreciseType -->
    68         -							<Parameter value="39A5A7E7-513F-44a4-B79D-7652CD8962D9">
    69         -								<Parameter value="101" type="System.Int32"/> <!-- Table -->
    70         -							</Parameter>
    71         -						</Parameter>
    72         -					</Parameter>
    73         -				</Action>
    74         -			</Actions>
    75         -		</Type>
    76         -
    77         -		<Type name="TableColumn" defaultSort="Database,Schema,Table,Ordinal">
    78         -			<Concepts>
    79         -				<Concept name="TableColumn" restrictions="{Catalog},null,{Table},{Name}"/>
    80         -			</Concepts>
    81         -			<Identifier>
    82         -				<Part name="Database" itemName="table_catalog">
    83         -					<Concepts>
    84         -						<Concept name="Identifier0"/>
    85         -					</Concepts>
    86         -				</Part>
    87         -				<Part name="Schema" itemName="table_schema">
    88         -					<Concepts>
    89         -						<Concept name="Identifier1"/>
    90         -					</Concepts>
    91         -				</Part>
    92         -				<Part name="Table" itemName="table_name">
    93         -					<Concepts>
    94         -						<Concept name="Identifier2"/>
    95         -					</Concepts>
    96         -				</Part>
    97         -				<Part name="Name" itemName="column_name">
    98         -					<Concepts>
    99         -						<Concept name="Identifier3"/>
   100         -					</Concepts>
   101         -				</Part>
   102         -			</Identifier>
   103         -			<Properties>
   104         -				<Property name="Name" type="System.String" itemName="column_name"/>
   105         -				<Property name="Ordinal" type="System.Int32" itemName="ordinal_position">
   106         -					<Concepts>
   107         -						<Concept name="Ordinal">
   108         -						</Concept>
   109         -					</Concepts>
   110         -				</Property>
   111         -				<Property name="SystemType" type="System.String" itemName="data_type">
   112         -					<Concepts>
   113         -						<Concept name="UserDataType"/>
   114         -						<Concept name="NativeDataType"/>
   115         -						<Concept name="ProviderDataType">
   116         -							<Conversion mapper="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectConceptMapper"/>
   117         -						</Concept>
   118         -						<Concept name="ProviderDbType">
   119         -							<Conversion mapper="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectConceptMapper"/>
   120         -						</Concept>
   121         -						<Concept name="FrameworkDataType">
   122         -							<Conversion mapper="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectConceptMapper"/>
   123         -						</Concept>
   124         -					</Concepts>
   125         -				</Property>
   126         -				<Property name="Length" type="System.Int32" itemName='character_maximum_length'>
   127         -					<Concepts>
   128         -						<Concept name="Length"/>
   129         -					</Concepts>
   130         -				</Property>
   131         -				<Property name="Precision" type="System.Int32" itemName="numeric_precision">
   132         -					<Concepts>
   133         -						<Concept name="Precision">
   134         -						</Concept>
   135         -					</Concepts>
   136         -				</Property>
   137         -				<Property name="Scale" type="System.Int32" itemName="numeric_scale">
   138         -					<Concepts>
   139         -						<Concept name="Scale"/>
   140         -					</Concepts>
   141         -				</Property>
   142         -				<Property name="Nullable" type="System.Boolean" itemName="is_nullable">
   143         -					<Concepts>
   144         -						<Concept name="Nullable">
   145         -						</Concept>
   146         -					</Concepts>
   147         -				</Property>
   148         -				<Property name="Default" type="System.String" itemName="column_default">
   149         -					<Concepts>
   150         -						<Concept name="Default"/>
   151         -					</Concepts>
   152         -				</Property>
   153         -			</Properties>
   154         -			<Actions>
   155         -				<Action name="Enumerate" guid="61CC0372-384D-42e5-9707-6D7C8DC5287A" handler="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectEnumerator">
   156         -					<Parameter value="Columns"/>
   157         -				</Action>
   158         -				<Action name="BuildDSRef" guid="7C030900-E8DD-471b-8F18-D83DA7036144" handler="Microsoft.VisualStudio.Data.DSRefBuilder">
   159         -					<Parameter>
   160         -						<Parameter value="{2}"/>
   161         -						<Parameter value="{1}"/>
   162         -						<Parameter value="Table"/>
   163         -						<Parameter/>
   164         -						<Parameter>
   165         -							<!-- GUID_DSRefProperty_PreciseType -->
   166         -							<Parameter value="39A5A7E7-513F-44a4-B79D-7652CD8962D9">
   167         -								<Parameter value="101" type="System.Int32"/> <!-- Table -->
   168         -							</Parameter>
   169         -						</Parameter>
   170         -						<Parameter>
   171         -							<Parameter>
   172         -								<Parameter value="{3}"/>
   173         -								<Parameter/>
   174         -								<Parameter value="Field"/>
   175         -								<Parameter/>
   176         -								<Parameter>
   177         -									<!-- GUID_DSRefProperty_PreciseType -->
   178         -									<Parameter value="39A5A7E7-513F-44a4-B79D-7652CD8962D9">
   179         -										<Parameter value="102" type="System.Int32"/> <!-- Table_Column -->
   180         -									</Parameter>
   181         -								</Parameter>
   182         -							</Parameter>
   183         -						</Parameter>
   184         -					</Parameter>
   185         -				</Action>
   186         -			</Actions>
   187         -		</Type>
   188         -
   189         -		<Type name="View" defaultSort="Database, Schema, Name">
   190         -			<Concepts>
   191         -				<Concept name="View" restrictions="{Catalog}, null, {Name}"/>
   192         -			</Concepts>
   193         -			<Identifier>
   194         -				<Part name="Database" itemName="table_catalog">
   195         -					<Concepts>
   196         -						<Concept name="Identifier0"/>
   197         -					</Concepts>
   198         -				</Part>
   199         -				<Part name="Schema" itemName="table_schema">
   200         -					<Concepts>
   201         -						<Concept name="Identifier1"/>
   202         -					</Concepts>
   203         -				</Part>
   204         -				<Part name="Name" itemName="table_name">
   205         -					<Concepts>
   206         -						<Concept name="Identifier2"/>
   207         -					</Concepts>
   208         -				</Part>
   209         -			</Identifier>
   210         -			<Properties>
   211         -				<Property name="Name" type="System.String" itemName="table_name"/>
   212         -				<Property name="Schema" type="System.String" itemName="table_schema">
   213         -					<Concepts>
   214         -						<Concept name="Schema"/>
   215         -					</Concepts>
   216         -				</Property>
   217         -				<Property name="CheckOption" type="System.Boolean" itemName="check_option"/>
   218         -				<Property name="IsUpdatable" type="System.Boolean" itemName="is_updatable"/>
   219         -			</Properties>
   220         -			<Actions>
   221         -				<Action name="Enumerate" guid="61CC0372-384D-42e5-9707-6D7C8DC5287A" handler="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectEnumerator">
   222         -					<Parameter value="Views"/>
   223         -				</Action>
   224         -				<Action name="BuildDSRef" guid="7C030900-E8DD-471b-8F18-D83DA7036144" handler="Microsoft.VisualStudio.Data.DSRefBuilder">
   225         -					<Parameter>
   226         -						<Parameter value="{2}"/>
   227         -						<Parameter value="{1}"/>
   228         -						<Parameter value="View"/>
   229         -						<Parameter/>
   230         -						<Parameter>
   231         -							<!-- GUID_DSRefProperty_PreciseType -->
   232         -							<Parameter value="39A5A7E7-513F-44a4-B79D-7652CD8962D9">
   233         -								<Parameter value="301" type="System.Int32"/> <!-- View -->
   234         -							</Parameter>
   235         -						</Parameter>
   236         -					</Parameter>
   237         -				</Action>
   238         -			</Actions>
   239         -		</Type>
   240         -
   241         -		<!--
   242         -			Defines a type that represents a view column.
   243         -		-->
   244         -		<Type name="ViewColumn" defaultSort="Database,Schema,View,Ordinal">
   245         -			<Concepts>
   246         -				<Concept name="ViewColumn" restrictions="{Catalog},null,{View},{Name}"/>
   247         -			</Concepts>
   248         -			<Identifier>
   249         -				<Part name="Database" itemName="table_catalog">
   250         -					<Concepts>
   251         -						<Concept name="Identifier0"/>
   252         -					</Concepts>
   253         -				</Part>
   254         -				<Part name="Schema" itemName="table_schema">
   255         -					<Concepts>
   256         -						<Concept name="Identifier1"/>
   257         -					</Concepts>
   258         -				</Part>
   259         -				<Part name="View" itemName="table_name">
   260         -					<Concepts>
   261         -						<Concept name="Identifier2"/>
   262         -					</Concepts>
   263         -				</Part>
   264         -				<Part name="Name" itemName="column_name">
   265         -					<Concepts>
   266         -						<Concept name="Identifier3"/>
   267         -					</Concepts>
   268         -				</Part>
   269         -			</Identifier>
   270         -			<Properties>
   271         -				<Property name="Name" type="System.String" itemName="column_name"/>
   272         -				<Property name="Ordinal" type="System.Int32" itemName="ordinal_position">
   273         -					<Concepts>
   274         -						<Concept name="Ordinal">
   275         -						</Concept>
   276         -					</Concepts>
   277         -				</Property>
   278         -				<Property name="SystemType" type="System.String" itemName="data_type">
   279         -					<Concepts>
   280         -						<Concept name="UserDataType"/>
   281         -						<Concept name="NativeDataType"/>
   282         -						<Concept name="ProviderDataType">
   283         -							<Conversion mapper="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectConceptMapper"/>
   284         -						</Concept>
   285         -						<Concept name="ProviderDbType">
   286         -							<Conversion mapper="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectConceptMapper"/>
   287         -						</Concept>
   288         -						<Concept name="FrameworkDataType">
   289         -							<Conversion mapper="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectConceptMapper"/>
   290         -						</Concept>
   291         -					</Concepts>
   292         -				</Property>
   293         -				<Property name="Length" type="System.Int32" itemName='character_maximum_length'>
   294         -					<Concepts>
   295         -						<Concept name="Length"/>
   296         -					</Concepts>
   297         -				</Property>
   298         -				<Property name="Precision" type="System.Int32" itemName="numeric_precision">
   299         -					<Concepts>
   300         -						<Concept name="Precision">
   301         -						</Concept>
   302         -					</Concepts>
   303         -				</Property>
   304         -				<Property name="Scale" type="System.Int32" itemName="numeric_scale">
   305         -					<Concepts>
   306         -						<Concept name="Scale"/>
   307         -					</Concepts>
   308         -				</Property>
   309         -				<Property name="Nullable" type="System.Boolean" itemName="is_nullable">
   310         -					<Concepts>
   311         -						<Concept name="Nullable">
   312         -						</Concept>
   313         -					</Concepts>
   314         -				</Property>
   315         -				<Property name="Default" type="System.String" itemName="column_default">
   316         -					<Concepts>
   317         -						<Concept name="Default"/>
   318         -					</Concepts>
   319         -				</Property>
   320         -			</Properties>
   321         -			<Actions>
   322         -				<Action name="Enumerate" guid="61CC0372-384D-42e5-9707-6D7C8DC5287A" handler="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectEnumerator">
   323         -					<Parameter value="Columns"/>
   324         -				</Action>
   325         -				<Action name="BuildDSRef" guid="7C030900-E8DD-471b-8F18-D83DA7036144" handler="Microsoft.VisualStudio.Data.DSRefBuilder">
   326         -					<Parameter>
   327         -						<Parameter value="{2}"/>
   328         -						<Parameter value="{1}"/>
   329         -						<Parameter value="View"/>
   330         -						<Parameter/>
   331         -						<Parameter>
   332         -							<!-- GUID_DSRefProperty_PreciseType -->
   333         -							<Parameter value="39A5A7E7-513F-44a4-B79D-7652CD8962D9">
   334         -								<Parameter value="301" type="System.Int32"/> <!-- View -->
   335         -							</Parameter>
   336         -						</Parameter>
   337         -						<Parameter>
   338         -							<Parameter>
   339         -								<Parameter value="{3}"/>
   340         -								<Parameter/>
   341         -								<Parameter value="Field"/>
   342         -								<Parameter/>
   343         -								<Parameter>
   344         -									<!-- GUID_DSRefProperty_PreciseType -->
   345         -									<Parameter value="39A5A7E7-513F-44a4-B79D-7652CD8962D9">
   346         -										<Parameter value="302" type="System.Int32"/> <!-- View_Column -->
   347         -									</Parameter>
   348         -								</Parameter>
   349         -							</Parameter>
   350         -						</Parameter>
   351         -					</Parameter>
   352         -				</Action>
   353         -			</Actions>
   354         -		</Type>
   355         -    <!--
   356         -			Defines a type that represents an index.
   357         -		-->
   358         -    <Type name="Index" defaultSort="Database,Schema,Table,Name">
   359         -      <Concepts>
   360         -        <Concept name="TableUniqueKey" restrictions="{Catalog},null,{Table},{Name}" filter="IsUnique = true"/>
   361         -      </Concepts>
   362         -      <Identifier>
   363         -        <Part name="Database" itemName="table_catalog">
   364         -          <Concepts>
   365         -            <Concept name="Identifier0"/>
   366         -          </Concepts>
   367         -        </Part>
   368         -        <Part name="Schema" itemName="table_schema">
   369         -          <Concepts>
   370         -            <Concept name="Identifier1"/>
   371         -          </Concepts>
   372         -        </Part>
   373         -        <Part name="Table" itemName="table_name">
   374         -          <Concepts>
   375         -            <Concept name="Identifier2"/>
   376         -          </Concepts>
   377         -        </Part>
   378         -        <Part name="Name" itemName="index_name">
   379         -          <Concepts>
   380         -            <Concept name="Identifier3"/>
   381         -          </Concepts>
   382         -        </Part>
   383         -      </Identifier>
   384         -      <Properties>
   385         -        <Property name="Name" type="System.String" itemName="index_name"/>
   386         -        <Property name="IsUnique" type="System.Boolean" itemName="UNIQUE"/>
   387         -        <Property name="IsPrimary" type="System.Boolean" itemName="PRIMARY_KEY">
   388         -          <Concepts>
   389         -            <Concept name="IsPrimary"/>
   390         -          </Concepts>
   391         -        </Property>
   392         -      </Properties>
   393         -      <Actions>
   394         -        <Action name="Enumerate" guid="61CC0372-384D-42e5-9707-6D7C8DC5287A" handler="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectEnumerator">
   395         -          <Parameter value="Indexes"/>
   396         -        </Action>
   397         -        <Action name="BuildDSRef" guid="7C030900-E8DD-471b-8F18-D83DA7036144" handler="Microsoft.VisualStudio.Data.DSRefBuilder">
   398         -          <Parameter>
   399         -            <Parameter value="{2}"/>
   400         -            <Parameter value="{1}"/>
   401         -            <Parameter value="Table"/>
   402         -            <Parameter/>
   403         -            <Parameter>
   404         -              <!-- GUID_DSRefProperty_Qualifier -->
   405         -              <Parameter value="4656BAEA-F397-11ce-BFE1-00AA0057B34E">
   406         -                <Parameter value="{0}"/>
   407         -              </Parameter>
   408         -              <!-- GUID_DSRefProperty_PreciseType -->
   409         -              <Parameter value="39A5A7E7-513F-44a4-B79D-7652CD8962D9">
   410         -                <Parameter value="101" type="System.Int32"/>
   411         -                <!-- Table -->
   412         -              </Parameter>
   413         -            </Parameter>
   414         -            <Parameter>
   415         -              <Parameter>
   416         -                <Parameter value="{3}"/>
   417         -                <Parameter/>
   418         -                <Parameter value="Index"/>
   419         -              </Parameter>
   420         -            </Parameter>
   421         -          </Parameter>
   422         -        </Action>
   423         -      </Actions>
   424         -    </Type>
   425         -
   426         -    <Type name="IndexColumn" defaultSort="Database,Schema,Table,Index,Ordinal">
   427         -      <Concepts>
   428         -        <Concept name="TableUniqueKeyColumn" restrictions="{Catalog},null,{Table},{TableUniqueKey},{Name}"/>
   429         -      </Concepts>
   430         -      <Identifier>
   431         -        <Part name="Database" itemName="table_catalog">
   432         -          <Concepts>
   433         -            <Concept name="Identifier0"/>
   434         -          </Concepts>
   435         -        </Part>
   436         -        <Part name="Schema" itemName="table_schema">
   437         -          <Concepts>
   438         -            <Concept name="Identifier1"/>
   439         -          </Concepts>
   440         -        </Part>
   441         -        <Part name="Table" itemName="table_name">
   442         -          <Concepts>
   443         -            <Concept name="Identifier2"/>
   444         -          </Concepts>
   445         -        </Part>
   446         -        <Part name="Index" itemName="index_name">
   447         -          <Concepts>
   448         -            <Concept name="Identifier3"/>
   449         -          </Concepts>
   450         -        </Part>
   451         -        <Part name="Name" itemName="column_name">
   452         -          <Concepts>
   453         -            <Concept name="Identifier4"/>
   454         -          </Concepts>
   455         -        </Part>
   456         -      </Identifier>
   457         -      <Properties>
   458         -        <Property name="Name" type="System.String" itemName="column_name"/>
   459         -        <Property name="Ordinal" type="System.Byte" itemName="ordinal_position">
   460         -          <Concepts>
   461         -            <Concept name="Ordinal">
   462         -              <Conversion>
   463         -                <ChangeType type="System.Int32"/>
   464         -              </Conversion>
   465         -            </Concept>
   466         -          </Concepts>
   467         -        </Property>
   468         -      </Properties>
   469         -      <Actions>
   470         -        <Action name="Enumerate" guid="61CC0372-384D-42e5-9707-6D7C8DC5287A" handler="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectEnumerator">
   471         -          <Parameter value="IndexColumns"/>
   472         -        </Action>
   473         -        <Action name="BuildDSRef" guid="7C030900-E8DD-471b-8F18-D83DA7036144" handler="Microsoft.VisualStudio.Data.DSRefBuilder">
   474         -          <Parameter>
   475         -            <Parameter value="{2}"/>
   476         -            <Parameter value="{1}"/>
   477         -            <Parameter value="Table"/>
   478         -            <Parameter/>
   479         -            <Parameter>
   480         -              <!-- GUID_DSRefProperty_Qualifier -->
   481         -              <Parameter value="4656BAEA-F397-11ce-BFE1-00AA0057B34E">
   482         -                <Parameter value="{0}"/>
   483         -              </Parameter>
   484         -              <!-- GUID_DSRefProperty_PreciseType -->
   485         -              <Parameter value="39A5A7E7-513F-44a4-B79D-7652CD8962D9">
   486         -                <Parameter value="101" type="System.Int32"/>
   487         -                <!-- Table -->
   488         -              </Parameter>
   489         -            </Parameter>
   490         -            <Parameter>
   491         -              <Parameter>
   492         -                <Parameter value="{3}"/>
   493         -                <Parameter/>
   494         -                <Parameter value="Index"/>
   495         -                <Parameter/>
   496         -                <Parameter/>
   497         -                <Parameter>
   498         -                  <Parameter>
   499         -                    <Parameter value="{4}"/>
   500         -                    <Parameter/>
   501         -                    <Parameter value="Field"/>
   502         -                  </Parameter>
   503         -                </Parameter>
   504         -              </Parameter>
   505         -            </Parameter>
   506         -          </Parameter>
   507         -        </Action>
   508         -      </Actions>
   509         -    </Type>
   510         -
   511         -    <Type name="ForeignKey" defaultSort="Database,Schema,Table,Name">
   512         -      <Concepts>
   513         -        <Concept name="TableForeignKey" restrictions="{Catalog},null,{Table},{Name}"/>
   514         -      </Concepts>
   515         -      <Identifier>
   516         -        <Part name="Database" itemName="table_catalog">
   517         -          <Concepts>
   518         -            <Concept name="Identifier0"/>
   519         -          </Concepts>
   520         -        </Part>
   521         -        <Part name="Schema" itemName="table_schema">
   522         -          <Concepts>
   523         -            <Concept name="Identifier1"/>
   524         -          </Concepts>
   525         -        </Part>
   526         -        <Part name="Table" itemName="table_name">
   527         -          <Concepts>
   528         -            <Concept name="Identifier2"/>
   529         -          </Concepts>
   530         -        </Part>
   531         -        <Part name="Name" itemName="constraint_name">
   532         -          <Concepts>
   533         -            <Concept name="Identifier3"/>
   534         -          </Concepts>
   535         -        </Part>
   536         -      </Identifier>
   537         -      <Properties>
   538         -        <Property name="Name" type="System.String" itemName="constraint_name"/>
   539         -        <Property name="ReferencedTableDatabase" type="System.String" itemName="fkey_to_catalog">
   540         -          <Concepts>
   541         -            <Concept name="ReferencedTableId0"/>
   542         -          </Concepts>
   543         -        </Property>
   544         -        <Property name="ReferencedTableSchema" type="System.String" itemName="fkey_to_schema">
   545         -          <Concepts>
   546         -            <Concept name="ReferencedTableId1"/>
   547         -          </Concepts>
   548         -        </Property>
   549         -        <Property name="ReferencedTableName" type="System.String" itemName="fkey_to_table">
   550         -          <Concepts>
   551         -            <Concept name="ReferencedTableId2"/>
   552         -          </Concepts>
   553         -        </Property>
   554         -      </Properties>
   555         -      <Actions>
   556         -        <Action name="Enumerate" guid="61CC0372-384D-42e5-9707-6D7C8DC5287A" handler="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectEnumerator">
   557         -          <Parameter value="ForeignKeys"/>
   558         -        </Action>
   559         -      </Actions>
   560         -    </Type>
   561         -
   562         -    <Type name="ForeignKeyColumn" defaultSort="Database,Schema,Table,ForeignKey,Ordinal">
   563         -      <Concepts>
   564         -        <Concept name="TableForeignKeyColumn" restrictions="{Catalog},null,{Table},{TableForeignKey},{Name}"/>
   565         -      </Concepts>
   566         -      <Identifier>
   567         -        <Part name="Database" itemName="table_catalog">
   568         -          <Concepts>
   569         -            <Concept name="Identifier0"/>
   570         -          </Concepts>
   571         -        </Part>
   572         -        <Part name="Schema" itemName="table_schema">
   573         -          <Concepts>
   574         -            <Concept name="Identifier1"/>
   575         -          </Concepts>
   576         -        </Part>
   577         -        <Part name="Table" itemName="table_name">
   578         -          <Concepts>
   579         -            <Concept name="Identifier2"/>
   580         -          </Concepts>
   581         -        </Part>
   582         -        <Part name="ForeignKey" itemName="constraint_name">
   583         -          <Concepts>
   584         -            <Concept name="Identifier3"/>
   585         -          </Concepts>
   586         -        </Part>
   587         -        <Part name="Name" itemName="fkey_from_column">
   588         -          <Concepts>
   589         -            <Concept name="Identifier4"/>
   590         -          </Concepts>
   591         -        </Part>
   592         -      </Identifier>
   593         -      <Properties>
   594         -        <Property name="Name" type="System.String" itemName="fkey_from_column"/>
   595         -        <Property name="Ordinal" type="System.Int32" itemName="fkey_from_ordinal_position">
   596         -          <Concepts>
   597         -            <Concept name="Ordinal"/>
   598         -          </Concepts>
   599         -        </Property>
   600         -        <Property name="ReferencedColumnName" type="System.String" itemName="fkey_to_column">
   601         -          <Concepts>
   602         -            <Concept name="ReferencedTableColumn"/>
   603         -          </Concepts>
   604         -        </Property>
   605         -      </Properties>
   606         -      <Actions>
   607         -        <Action name="Enumerate" guid="61CC0372-384D-42e5-9707-6D7C8DC5287A" handler="Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetObjectEnumerator">
   608         -          <Parameter value="ForeignKeys"/>
   609         -        </Action>
   610         -      </Actions>
   611         -    </Type>
   612         -  </Types>
   613         -</VSDataObjectSupport>

Deleted bin/Designer/SQLiteDataViewSupport.xml.

     1         -<?xml version="1.0" encoding="utf-8"?>
     2         -
     3         -<!--
     4         -/********************************************************
     5         - * ADO.NET 2.0 Data Provider for SQLite Version 3.X
     6         - * Written by Robert Simpson (robert@blackcastlesoft.com)
     7         - * 
     8         - * Released to the public domain, use at your own risk!
     9         - ********************************************************/
    10         --->
    11         -
    12         -<VSDataViewSupport xmlns="http://tempuri.org/VSDataViewSupport.xsd">
    13         -	<DataViews>
    14         -		<!-- This sample defines a single data view -->
    15         -		<DataView name="SQLite">
    16         -      <DisplayName>SQLite</DisplayName>
    17         -			<!-- The connection node is static, i.e. has no underlying object -->
    18         -			<StaticConnectionNode>
    19         -				<!-- We can always specify data from the root object -->
    20         -				<InitialDisplayName>{Root.Server}</InitialDisplayName>
    21         -				<CommandBindings>
    22         -					<!--
    23         -						This command binding hooks up a command that launches the built-
    24         -						in Visual Studio query designer.
    25         -					-->
    26         -					<CommandBinding name="NewQuery" guid="501822E1-B5AF-11d0-B4DC-00A0C91506EF" cmdid="13608" handler="884DD964-5327-461f-9F06-6484DD540F8F"/>
    27         -				</CommandBindings>
    28         -				<Children>
    29         -					<StaticNode nid="Tables">
    30         -            <DisplayName>User Tables</DisplayName>
    31         -						<CommandBindings>
    32         -							<CommandBinding name="NewQuery" guid="501822E1-B5AF-11d0-B4DC-00A0C91506EF" cmdid="13608" handler="884DD964-5327-461f-9F06-6484DD540F8F"/>
    33         -						</CommandBindings>
    34         -						<Children>
    35         -							<!--
    36         -								To show a set of objects from the data source we issue a
    37         -								selection, specifying type, restrictions and filter.
    38         -							-->
    39         -							<Selection type="Table" restrictions="null,null,null,TABLE">
    40         -								<!--
    41         -									The selection node indicates how to represent each object
    42         -									in the selection.
    43         -								-->
    44         -								<SelectionNode nid="Table">
    45         -                  <DisplayName>{Table.Name}</DisplayName>
    46         -									<Icon name="Table"/>
    47         -									<Children>
    48         -										<Selection type="TableColumn" restrictions="{Table.Database},null,{Table.Name}">
    49         -											<SelectionNode>
    50         -												<Icon name="Column"/>
    51         -											</SelectionNode>
    52         -										</Selection>
    53         -									</Children>
    54         -								</SelectionNode>
    55         -							</Selection>
    56         -						</Children>
    57         -					</StaticNode>
    58         -					<StaticNode nid="Views">
    59         -            <DisplayName>User Views</DisplayName>
    60         -						<CommandBindings>
    61         -							<CommandBinding name="NewQuery" guid="501822E1-B5AF-11d0-B4DC-00A0C91506EF" cmdid="13608" handler="884DD964-5327-461f-9F06-6484DD540F8F"/>
    62         -						</CommandBindings>
    63         -						<Children>
    64         -							<Selection type="View">
    65         -								<SelectionNode nid="View">
    66         -                  <DisplayName>{View.Name}</DisplayName>
    67         -									<Icon name="View"/>
    68         -									<Children>
    69         -										<Selection type="ViewColumn" restrictions="{View.Database},null,{View.Name}">
    70         -											<SelectionNode>
    71         -												<Icon name="Column"/>
    72         -											</SelectionNode>
    73         -										</Selection>
    74         -									</Children>
    75         -								</SelectionNode>
    76         -							</Selection>
    77         -						</Children>
    78         -					</StaticNode>
    79         -				</Children>
    80         -			</StaticConnectionNode>
    81         -		</DataView>
    82         -	</DataViews>
    83         -</VSDataViewSupport>

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  +@="SQLite.Designer.SQLiteDataConnectionSupport"
    16     15   
    17     16   [HKEY_LOCAL_MACHINE\%REGROOT%\DataProviders\{0EBAAB6E-CA80-4b4a-8DDF-CBE6BF058C70}\SupportedObjects\DataObjectSupport]
    18         -@="SQLiteDataObjectSupport.xml"
    19         -"Path"="%XMLPATH%"
    20     17   
    21     18   [HKEY_LOCAL_MACHINE\%REGROOT%\DataProviders\{0EBAAB6E-CA80-4b4a-8DDF-CBE6BF058C70}\SupportedObjects\DataViewSupport]
    22         -@="SQLiteDataViewSupport.xml"
    23         -"Path"="%XMLPATH%"
    24         -
    25         -[HKEY_LOCAL_MACHINE\%REGROOT%\DataProviders\{0EBAAB6E-CA80-4b4a-8DDF-CBE6BF058C70}\SupportedObjects\DataSourceInformation]
    26         -@="SQLite.Designer.SQLiteDataSourceInformation"
    27         -
    28         -[HKEY_LOCAL_MACHINE\%REGROOT%\DataProviders\{0EBAAB6E-CA80-4b4a-8DDF-CBE6BF058C70}\SupportedObjects\DataObjectIdentifierResolver]
    29         -@="SQLite.Designer.SQLiteDataObjectIdentifierResolver"
    30     19   
    31     20   [HKEY_LOCAL_MACHINE\%REGROOT%\DataSources\{0EBAAB6E-CA80-4b4a-8DDF-CBE6BF058C71}]
    32     21   @="SQLite Database File"
    33     22   
    34     23   [HKEY_LOCAL_MACHINE\%REGROOT%\DataSources\{0EBAAB6E-CA80-4b4a-8DDF-CBE6BF058C71}\SupportingProviders]
    35     24   
    36     25   [HKEY_LOCAL_MACHINE\%REGROOT%\DataSources\{0EBAAB6E-CA80-4b4a-8DDF-CBE6BF058C71}\SupportingProviders\{0EBAAB6E-CA80-4b4a-8DDF-CBE6BF058C70}]
    37     26