2010-04-06 14:22:27 +00:00
|
|
|
|
<?xml version="1.0" encoding="utf-8"?>
|
|
|
|
|
|
<xs:schema id="DataSet1" targetNamespace="http://tempuri.org/DataSet1.xsd" xmlns:mstns="http://tempuri.org/DataSet1.xsd" xmlns="http://tempuri.org/DataSet1.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
|
|
|
|
|
|
<xs:annotation>
|
|
|
|
|
|
<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
|
|
|
|
|
|
<DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
|
|
|
|
|
|
<Connections>
|
|
|
|
|
|
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="CUEPlayerConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CUEPlayerConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.CUEPlayer.Properties.Settings.GlobalReference.Default.CUEPlayerConnectionString" Provider="Microsoft.SqlServerCe.Client.3.5" />
|
|
|
|
|
|
</Connections>
|
|
|
|
|
|
<Tables>
|
|
|
|
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PlaylistTableAdapter" GeneratorDataComponentClassName="PlaylistTableAdapter" Name="Playlist" UserDataComponentName="PlaylistTableAdapter">
|
|
|
|
|
|
<MainSource>
|
|
|
|
|
|
<DbSource ConnectionRef="CUEPlayerConnectionString (Settings)" DbObjectName="Playlist" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|
|
|
|
|
<DeleteCommand>
|
|
|
|
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
|
|
|
|
<CommandText>DELETE FROM [Playlist] WHERE (([id] = @p1))</CommandText>
|
|
|
|
|
|
<Parameters>
|
|
|
|
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
|
|
|
|
</Parameters>
|
|
|
|
|
|
</DbCommand>
|
|
|
|
|
|
</DeleteCommand>
|
|
|
|
|
|
<InsertCommand>
|
|
|
|
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
|
|
|
|
<CommandText>INSERT INTO [Playlist] ([path], [artist], [title], [album], [length], [track]) VALUES (@p1, @p2, @p3, @p4, @p5, @p6)</CommandText>
|
|
|
|
|
|
<Parameters>
|
|
|
|
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="path" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
|
|
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="artist" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
|
|
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
|
|
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="album" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
|
|
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="length" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
|
|
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="track" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
|
|
|
|
</Parameters>
|
|
|
|
|
|
</DbCommand>
|
|
|
|
|
|
</InsertCommand>
|
|
|
|
|
|
<SelectCommand>
|
2010-04-16 04:30:51 +00:00
|
|
|
|
<DbCommand CommandType="Text" ModifiedByUser="true">
|
2010-04-06 14:22:27 +00:00
|
|
|
|
<CommandText>SELECT [id], [path], [artist], [title], [album], [length], [track] FROM [Playlist]</CommandText>
|
|
|
|
|
|
<Parameters />
|
|
|
|
|
|
</DbCommand>
|
|
|
|
|
|
</SelectCommand>
|
|
|
|
|
|
<UpdateCommand>
|
|
|
|
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|
|
|
|
|
<CommandText>UPDATE [Playlist] SET [path] = @p1, [artist] = @p2, [title] = @p3, [album] = @p4, [length] = @p5, [track] = @p6 WHERE (([id] = @p7))</CommandText>
|
|
|
|
|
|
<Parameters>
|
|
|
|
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="path" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
|
|
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="artist" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
|
|
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
|
|
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="album" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
|
|
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="length" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
|
|
|
|
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p6" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="track" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
|
|
|
|
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p7" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
|
|
|
|
|
|
</Parameters>
|
|
|
|
|
|
</DbCommand>
|
|
|
|
|
|
</UpdateCommand>
|
|
|
|
|
|
</DbSource>
|
|
|
|
|
|
</MainSource>
|
|
|
|
|
|
<Mappings>
|
|
|
|
|
|
<Mapping SourceColumn="id" DataSetColumn="id" />
|
|
|
|
|
|
<Mapping SourceColumn="path" DataSetColumn="path" />
|
|
|
|
|
|
<Mapping SourceColumn="artist" DataSetColumn="artist" />
|
|
|
|
|
|
<Mapping SourceColumn="title" DataSetColumn="title" />
|
|
|
|
|
|
<Mapping SourceColumn="album" DataSetColumn="album" />
|
|
|
|
|
|
<Mapping SourceColumn="length" DataSetColumn="length" />
|
|
|
|
|
|
<Mapping SourceColumn="track" DataSetColumn="track" />
|
|
|
|
|
|
</Mappings>
|
|
|
|
|
|
<Sources />
|
|
|
|
|
|
</TableAdapter>
|
|
|
|
|
|
</Tables>
|
|
|
|
|
|
<Sources />
|
|
|
|
|
|
</DataSource>
|
|
|
|
|
|
</xs:appinfo>
|
|
|
|
|
|
</xs:annotation>
|
2010-04-16 04:30:51 +00:00
|
|
|
|
<xs:element name="DataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DataSet1" msprop:Generator_DataSetName="DataSet1" msprop:EnableTableAdapterManager="true">
|
2010-04-06 14:22:27 +00:00
|
|
|
|
<xs:complexType>
|
|
|
|
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
2010-04-16 04:30:51 +00:00
|
|
|
|
<xs:element name="Playlist" msprop:Generator_UserTableName="Playlist" msprop:Generator_RowDeletedName="PlaylistRowDeleted" msprop:Generator_RowChangedName="PlaylistRowChanged" msprop:Generator_RowClassName="PlaylistRow" msprop:Generator_RowChangingName="PlaylistRowChanging" msprop:Generator_RowEvArgName="PlaylistRowChangeEvent" msprop:Generator_RowEvHandlerName="PlaylistRowChangeEventHandler" msprop:Generator_TableClassName="PlaylistDataTable" msprop:Generator_TableVarName="tablePlaylist" msprop:Generator_RowDeletingName="PlaylistRowDeleting" msprop:Generator_TablePropName="Playlist">
|
2010-04-06 14:22:27 +00:00
|
|
|
|
<xs:complexType>
|
|
|
|
|
|
<xs:sequence>
|
2010-04-16 04:30:51 +00:00
|
|
|
|
<xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" type="xs:int" />
|
|
|
|
|
|
<xs:element name="path" msprop:Generator_UserColumnName="path" msprop:Generator_ColumnVarNameInTable="columnpath" msprop:Generator_ColumnPropNameInRow="path" msprop:Generator_ColumnPropNameInTable="pathColumn">
|
2010-04-06 14:22:27 +00:00
|
|
|
|
<xs:simpleType>
|
|
|
|
|
|
<xs:restriction base="xs:string">
|
2010-04-16 04:30:51 +00:00
|
|
|
|
<xs:maxLength value="255" />
|
2010-04-06 14:22:27 +00:00
|
|
|
|
</xs:restriction>
|
|
|
|
|
|
</xs:simpleType>
|
|
|
|
|
|
</xs:element>
|
2010-04-16 04:30:51 +00:00
|
|
|
|
<xs:element name="artist" msprop:Generator_UserColumnName="artist" msprop:Generator_ColumnVarNameInTable="columnartist" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="artist" msprop:Generator_ColumnPropNameInTable="artistColumn" minOccurs="0">
|
2010-04-06 14:22:27 +00:00
|
|
|
|
<xs:simpleType>
|
|
|
|
|
|
<xs:restriction base="xs:string">
|
2010-04-16 04:30:51 +00:00
|
|
|
|
<xs:maxLength value="255" />
|
2010-04-06 14:22:27 +00:00
|
|
|
|
</xs:restriction>
|
|
|
|
|
|
</xs:simpleType>
|
|
|
|
|
|
</xs:element>
|
2010-04-16 04:30:51 +00:00
|
|
|
|
<xs:element name="title" msprop:Generator_UserColumnName="title" msprop:Generator_ColumnVarNameInTable="columntitle" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="title" msprop:Generator_ColumnPropNameInTable="titleColumn" minOccurs="0">
|
2010-04-06 14:22:27 +00:00
|
|
|
|
<xs:simpleType>
|
|
|
|
|
|
<xs:restriction base="xs:string">
|
2010-04-16 04:30:51 +00:00
|
|
|
|
<xs:maxLength value="255" />
|
2010-04-06 14:22:27 +00:00
|
|
|
|
</xs:restriction>
|
|
|
|
|
|
</xs:simpleType>
|
|
|
|
|
|
</xs:element>
|
2010-04-16 04:30:51 +00:00
|
|
|
|
<xs:element name="album" msprop:Generator_UserColumnName="album" msprop:Generator_ColumnVarNameInTable="columnalbum" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="album" msprop:Generator_ColumnPropNameInTable="albumColumn" minOccurs="0">
|
2010-04-06 14:22:27 +00:00
|
|
|
|
<xs:simpleType>
|
|
|
|
|
|
<xs:restriction base="xs:string">
|
2010-04-16 04:30:51 +00:00
|
|
|
|
<xs:maxLength value="255" />
|
2010-04-06 14:22:27 +00:00
|
|
|
|
</xs:restriction>
|
|
|
|
|
|
</xs:simpleType>
|
|
|
|
|
|
</xs:element>
|
2010-04-16 04:30:51 +00:00
|
|
|
|
<xs:element name="length" msprop:Generator_UserColumnName="length" msprop:Generator_ColumnVarNameInTable="columnlength" msprop:Generator_ColumnPropNameInRow="length" msprop:Generator_ColumnPropNameInTable="lengthColumn" type="xs:int" minOccurs="0" />
|
|
|
|
|
|
<xs:element name="track" msprop:Generator_UserColumnName="track" msprop:Generator_ColumnVarNameInTable="columntrack" msprop:Generator_ColumnPropNameInRow="track" msprop:Generator_ColumnPropNameInTable="trackColumn" type="xs:int" minOccurs="0" />
|
2010-04-06 14:22:27 +00:00
|
|
|
|
</xs:sequence>
|
|
|
|
|
|
</xs:complexType>
|
|
|
|
|
|
</xs:element>
|
|
|
|
|
|
</xs:choice>
|
|
|
|
|
|
</xs:complexType>
|
|
|
|
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|
|
|
|
|
<xs:selector xpath=".//mstns:Playlist" />
|
|
|
|
|
|
<xs:field xpath="mstns:id" />
|
|
|
|
|
|
</xs:unique>
|
|
|
|
|
|
</xs:element>
|
|
|
|
|
|
</xs:schema>
|
