Edit C:\Program Files\Reference Assemblies\Microsoft\Framework\v3.5\fr\System.Data.Entity.Resources.dll
MZ? ÿÿ ¸ @ ? º ´ Í!¸LÍ!This program cannot be run in DOS mode. $ PE L 0[ëQ à ! ~+ @ @ ? ?? @ 0+ K @ ? ` H .text ? `.rsrc ? @ @ @.reloc ` 0 @ B `+ H ð' @ P p' ? ? <?xml version="1.0" encoding="utf-8"?> <!-- #################################################################################################################### BE AWARE THAT THE ORDER IN WHICH TYPES ARE DESCRIBED IN THE PROVIDER MANIFEST IS RELEVANT AND HAVE IMPACT IN LOOKUP PROCESS #################################################################################################################### --> <ProviderManifest Namespace="SqlServer" xmlns="http://schemas.microsoft.com/ado/2006/04/edm/providermanifest"> <Types> <Type Name="tinyint" PrimitiveTypeKind="Byte"> </Type> <Type Name="smallint" PrimitiveTypeKind="Int16"> </Type> <Type Name="int" PrimitiveTypeKind="Int32"> </Type> <Type Name="bigint" PrimitiveTypeKind="Int64"> </Type> <Type Name="float" PrimitiveTypeKind="Double"> </Type> <Type Name="real" PrimitiveTypeKind="Single"> </Type> <Type Name="decimal" PrimitiveTypeKind="Decimal"> <FacetDescriptions> <Precision Minimum="1" Maximum="38" DefaultValue="18" Constant="false"/> <Scale Minimum="0" Maximum="38" DefaultValue="0" Constant="false"/> </FacetDescriptions> </Type> <Type Name="numeric" PrimitiveTypeKind="Decimal"> <FacetDescriptions> <Precision Minimum="1" Maximum="38" DefaultValue="18" Constant="false"/> <Scale Minimum="0" Maximum="38" DefaultValue="0" Constant="false"/> </FacetDescriptions> </Type> <Type Name="smallmoney" PrimitiveTypeKind="Decimal"> <FacetDescriptions> <Precision DefaultValue="10" Constant="true"/> <Scale DefaultValue="4" Constant="true"/> </FacetDescriptions> </Type> <Type Name="money" PrimitiveTypeKind="Decimal"> <FacetDescriptions> <Precision DefaultValue="19" Constant="true"/> <Scale DefaultValue="4" Constant="true"/> </FacetDescriptions> </Type> <Type Name="binary" PrimitiveTypeKind="Binary"> <FacetDescriptions> <MaxLength Minimum="1" Maximum="8000" DefaultValue="8000" Constant="false"/> <FixedLength DefaultValue="true" Constant="true"/> </FacetDescriptions> </Type> <Type Name="varbinary" PrimitiveTypeKind="Binary"> <FacetDescriptions> <MaxLength Minimum="1" Maximum="8000" DefaultValue="8000" Constant="false"/> <FixedLength DefaultValue="false" Constant="true"/> </FacetDescriptions> </Type> <Type Name="varbinary(max)" PrimitiveTypeKind="Binary"> <FacetDescriptions> <MaxLength DefaultValue="2147483647" Constant="true"/> <FixedLength DefaultValue="false" Constant="true"/> </FacetDescriptions> </Type> <Type Name="image" PrimitiveTypeKind="Binary"> <FacetDescriptions> <MaxLength DefaultValue="2147483647" Constant="true"/> <FixedLength DefaultValue="false" Constant="true"/> </FacetDescriptions> </Type> <Type Name="timestamp" PrimitiveTypeKind="Binary"> <FacetDescriptions> <MaxLength DefaultValue="8" Constant="true"/> <FixedLength DefaultValue="true" Constant="true"/> </FacetDescriptions> </Type> <Type Name="rowversion" PrimitiveTypeKind="Binary"> <FacetDescriptions> <MaxLength DefaultValue="8" Constant="true"/> <FixedLength DefaultValue="true" Constant="true"/> </FacetDescriptions> </Type> <Type Name="bit" PrimitiveTypeKind="Boolean"> </Type> <Type Name="smalldatetime" PrimitiveTypeKind="DateTime"> <FacetDescriptions> <Precision DefaultValue="0" Constant="true"/> </FacetDescriptions> </Type> <Type Name="datetime" PrimitiveTypeKind="DateTime"> <FacetDescriptions> <Precision DefaultValue="3" Constant="true"/> </FacetDescriptions> </Type> <Type Name="datetime2" PrimitiveTypeKind="DateTime"> <FacetDescriptions> <Precision Minimum="0" Maximum="7" DefaultValue="7" Constant="false"/> </FacetDescriptions> </Type> <Type Name="date" PrimitiveTypeKind="DateTime"> <FacetDescriptions> <Precision DefaultValue="0" Constant="true"/> </FacetDescriptions> </Type> <Type Name="time" PrimitiveTypeKind="Time"> <FacetDescriptions> <Precision Minimum="0" Maximum="7" DefaultValue="7" Constant="false"/> </FacetDescriptions> </Type> <Type Name="datetimeoffset" PrimitiveTypeKind="DateTimeOffset"> <FacetDescriptions> <Precision Minimum="0" Maximum="7" DefaultValue="7" Constant="false"/> </FacetDescriptions> </Type> <Type Name="nvarchar" PrimitiveTypeKind="String"> <FacetDescriptions> <MaxLength Minimum="1" Maximum="4000" DefaultValue="4000" Constant="false"/> <Unicode DefaultValue="true" Constant="true"/> <FixedLength DefaultValue="false" Constant="true"/> </FacetDescriptions> </Type> <Type Name="varchar" PrimitiveTypeKind="String"> <FacetDescriptions> <MaxLength Minimum="1" Maximum="8000" DefaultValue="8000" Constant="false"/> <Unicode DefaultValue="false" Constant="true"/> <FixedLength DefaultValue="false" Constant="true"/> </FacetDescriptions> </Type> <Type Name="char" PrimitiveTypeKind="String"> <FacetDescriptions> <MaxLength Minimum="1" Maximum="8000" DefaultValue="8000" Constant="false"/> <Unicode DefaultValue="false" Constant="true"/> <FixedLength DefaultValue="true" Constant="true"/> </FacetDescriptions> </Type> <Type Name="nchar" PrimitiveTypeKind="String"> <FacetDescriptions> <MaxLength Minimum="1" Maximum="4000" DefaultValue="4000" Constant="false"/> <Unicode DefaultValue="true" Constant="true"/> <FixedLength DefaultValue="true" Constant="true"/> </FacetDescriptions> </Type> <Type Name="varchar(max)" PrimitiveTypeKind="String"> <FacetDescriptions> <MaxLength DefaultValue="2147483647" Constant="true"/> <Unicode DefaultValue="false" Constant="true"/> <FixedLength DefaultValue="false" Constant="true"/> </FacetDescriptions> </Type> <Type Name="nvarchar(max)" PrimitiveTypeKind="String"> <FacetDescriptions> <MaxLength DefaultValue="1073741823" Constant="true"/> <Unicode DefaultValue="true" Constant="true"/> <FixedLength DefaultValue="false" Constant="true"/> </FacetDescriptions> </Type> <Type Name="ntext" PrimitiveTypeKind="String"> <FacetDescriptions> <MaxLength DefaultValue="1073741823" Constant="true"/> <Unicode DefaultValue="true" Constant="true"/> <FixedLength DefaultValue="false" Constant="true"/> </FacetDescriptions> </Type> <Type Name="text" PrimitiveTypeKind="String"> <FacetDescriptions> <MaxLength DefaultValue="2147483647" Constant="true"/> <Unicode DefaultValue="false" Constant="true"/> <FixedLength DefaultValue="false" Constant="true"/> </FacetDescriptions> </Type> <Type Name="uniqueidentifier" PrimitiveTypeKind="Guid"> </Type> <Type Name="xml" PrimitiveTypeKind="String"> <FacetDescriptions> <MaxLength DefaultValue="1073741823" Constant="true"/> <Unicode DefaultValue="true" Constant="true"/> <FixedLength DefaultValue="false" Constant="true"/> </FacetDescriptions> </Type> </Types> <Functions> <!-- BEGIN AGGREGATES ############################################# --> <!-- AVG --> <Function Name="AVG" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="Collection(Int32)" Mode="In"/> </Function> <Function Name="AVG" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int64"/> <Parameter Name="arg" Type="Collection(Int64)" Mode="In"/> </Function> <Function Name="AVG" Aggregate="true" BuiltIn="true"> <ReturnType Type="Decimal"/> <Parameter Name="arg" Type="Collection(Decimal)" Mode="In"/> </Function> <Function Name="AVG" Aggregate="true" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Collection(Double)" Mode="In"/> </Function> <!-- CHECKSUM_AGG --> <Function Name="CHECKSUM_AGG" Aggregate="true" BuiltIn="true" ParameterTypeSemantics="ExactMatchOnly"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="Collection(Int32)" Mode="In"/> </Function> <!-- COUNT --> <Function Name="COUNT" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="Collection(Boolean)" Mode="In"/> </Function> <Function Name="COUNT" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="Collection(Double)" Mode="In"/> </Function> <Function Name="COUNT" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="Collection(Decimal)" Mode="In"/> </Function> <Function Name="COUNT" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="Collection(DateTime)" Mode="In"/> </Function> <Function Name="COUNT" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="Collection(DateTimeOffset)" Mode="In"/> </Function> <Function Name="COUNT" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="Collection(Time)" Mode="In"/> </Function> <Function Name="COUNT" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="Collection(Guid)" Mode="In"/> </Function> <Function Name="COUNT" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="Collection(String)" Mode="In"/> </Function> <Function Name="COUNT" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="Collection(Binary)" Mode="In"/> </Function> <!-- COUNT_BIG --> <Function Name="COUNT_BIG" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int64"/> <Parameter Name="arg" Type="Collection(Boolean)" Mode="In"/> </Function> <Function Name="COUNT_BIG" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int64"/> <Parameter Name="arg" Type="Collection(Double)" Mode="In"/> </Function> <Function Name="COUNT_BIG" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int64"/> <Parameter Name="arg" Type="Collection(Decimal)" Mode="In"/> </Function> <Function Name="COUNT_BIG" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int64"/> <Parameter Name="arg" Type="Collection(DateTime)" Mode="In"/> </Function> <Function Name="COUNT_BIG" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int64"/> <Parameter Name="arg" Type="Collection(DateTimeOffset)" Mode="In"/> </Function> <Function Name="COUNT_BIG" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int64"/> <Parameter Name="arg" Type="Collection(Time)" Mode="In"/> </Function> <Function Name="COUNT_BIG" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int64"/> <Parameter Name="arg" Type="Collection(Guid)" Mode="In"/> </Function> <Function Name="COUNT_BIG" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int64"/> <Parameter Name="arg" Type="Collection(String)" Mode="In"/> </Function> <Function Name="COUNT_BIG" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int64"/> <Parameter Name="arg" Type="Collection(Binary)" Mode="In"/> </Function> <!-- GROUPING !NOT SUPPORTED! --> <!-- MAX --> <Function Name="MAX" Aggregate="true" BuiltIn="true"> <ReturnType Type="Byte"/> <Parameter Name="arg" Type="Collection(Byte)" Mode="In"/> </Function> <Function Name="MAX" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int16"/> <Parameter Name="arg" Type="Collection(Int16)" Mode="In"/> </Function> <Function Name="MAX" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="Collection(Int32)" Mode="In"/> </Function> <Function Name="MAX" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int64"/> <Parameter Name="arg" Type="Collection(Int64)" Mode="In"/> </Function> <Function Name="MAX" Aggregate="true" BuiltIn="true"> <ReturnType Type="Decimal"/> <Parameter Name="arg" Type="Collection(Decimal)" Mode="In"/> </Function> <Function Name="MAX" Aggregate="true" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Collection(Double)" Mode="In"/> </Function> <Function Name="MAX" Aggregate="true" BuiltIn="true"> <ReturnType Type="Single"/> <Parameter Name="arg" Type="Collection(Single)" Mode="In"/> </Function> <Function Name="MAX" Aggregate="true" BuiltIn="true"> <ReturnType Type="DateTime"/> <Parameter Name="arg" Type="Collection(DateTime)" Mode="In"/> </Function> <Function Name="MAX" Aggregate="true" BuiltIn="true"> <ReturnType Type="Time"/> <Parameter Name="arg" Type="Collection(Time)" Mode="In"/> </Function> <Function Name="MAX" Aggregate="true" BuiltIn="true"> <ReturnType Type="DateTimeOffset"/> <Parameter Name="arg" Type="Collection(DateTimeOffset)" Mode="In"/> </Function> <Function Name="MAX" Aggregate="true" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="arg" Type="Collection(String)" Mode="In"/> </Function> <Function Name="MAX" Aggregate="true" BuiltIn="true"> <ReturnType Type="Binary"/> <Parameter Name="arg" Type="Collection(Binary)" Mode="In"/> </Function> <!-- MIN --> <Function Name="MIN" Aggregate="true" BuiltIn="true"> <ReturnType Type="Byte"/> <Parameter Name="arg" Type="Collection(Byte)" Mode="In"/> </Function> <Function Name="MIN" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int16"/> <Parameter Name="arg" Type="Collection(Int16)" Mode="In"/> </Function> <Function Name="MIN" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="Collection(Int32)" Mode="In"/> </Function> <Function Name="MIN" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int64"/> <Parameter Name="arg" Type="Collection(Int64)" Mode="In"/> </Function> <Function Name="MIN" Aggregate="true" BuiltIn="true"> <ReturnType Type="Decimal"/> <Parameter Name="arg" Type="Collection(Decimal)" Mode="In"/> </Function> <Function Name="MIN" Aggregate="true" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Collection(Double)" Mode="In"/> </Function> <Function Name="MIN" Aggregate="true" BuiltIn="true"> <ReturnType Type="Single"/> <Parameter Name="arg" Type="Collection(Single)" Mode="In"/> </Function> <Function Name="MIN" Aggregate="true" BuiltIn="true"> <ReturnType Type="DateTime"/> <Parameter Name="arg" Type="Collection(DateTime)" Mode="In"/> </Function> <Function Name="MIN" Aggregate="true" BuiltIn="true"> <ReturnType Type="Time"/> <Parameter Name="arg" Type="Collection(Time)" Mode="In"/> </Function> <Function Name="MIN" Aggregate="true" BuiltIn="true"> <ReturnType Type="DateTimeOffset"/> <Parameter Name="arg" Type="Collection(DateTimeOffset)" Mode="In"/> </Function> <Function Name="MIN" Aggregate="true" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="arg" Type="Collection(String)" Mode="In"/> </Function> <Function Name="MIN" Aggregate="true" BuiltIn="true"> <ReturnType Type="Binary"/> <Parameter Name="arg" Type="Collection(Binary)" Mode="In"/> </Function> <!-- SUM --> <Function Name="SUM" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="Collection(Int32)" Mode="In"/> </Function> <Function Name="SUM" Aggregate="true" BuiltIn="true"> <ReturnType Type="Int64"/> <Parameter Name="arg" Type="Collection(Int64)" Mode="In"/> </Function> <Function Name="SUM" Aggregate="true" BuiltIn="true"> <ReturnType Type="Decimal"/> <Parameter Name="arg" Type="Collection(Decimal)" Mode="In"/> </Function> <Function Name="SUM" Aggregate="true" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Collection(Double)" Mode="In"/> </Function> <!-- STDEV --> <Function Name="STDEV" Aggregate="true" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Collection(Double)" Mode="In"/> </Function> <Function Name="STDEV" Aggregate="true" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Collection(Decimal)" Mode="In"/> </Function> <!-- STDEVP --> <Function Name="STDEVP" Aggregate="true" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Collection(Double)" Mode="In"/> </Function> <Function Name="STDEVP" Aggregate="true" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Collection(Decimal)" Mode="In"/> </Function> <!-- VAR --> <Function Name="VAR" Aggregate="true" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Collection(Double)" Mode="In"/> </Function> <Function Name="VAR" Aggregate="true" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Collection(Decimal)" Mode="In"/> </Function> <!-- VARP --> <Function Name="VARP" Aggregate="true" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Collection(Double)" Mode="In"/> </Function> <Function Name="VARP" Aggregate="true" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Collection(Decimal)" Mode="In"/> </Function> <!-- END AGGREGATES ############################################# --> <!-- BEGIN STRING FUNCTIONS ##################################### --> <!-- ASCII( arg ) arg1: char, varchar (nvarchar is allowed by SQL server) returns: int --> <Function Name="ASCII" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="String" Mode="In"/> </Function> <!-- CHAR( arg ) arg: tinyint, *smallint, *int, *bigint returns: char(1) --> <Function Name="CHAR" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="arg" Type="Int32" Mode="In"/> </Function> <!-- CHARINDEX( strSearch, strTarget [, startLocation ] ) strSearch: character expression strTarget: character expression startLocation: tinyint, smallint, int, bigint returns: int, bigint --> <Function Name="CHARINDEX" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="strSearch" Type="String" Mode="In"/> <Parameter Name="strTarget" Type="String" Mode="In"/> </Function> <Function Name="CHARINDEX" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="strSearch" Type="Binary" Mode="In"/> <Parameter Name="strTarget" Type="Binary" Mode="In"/> </Function> <Function Name="CHARINDEX" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="strSearch" Type="String" Mode="In"/> <Parameter Name="strTarget" Type="String" Mode="In"/> <Parameter Name="startLocation" Type="Int32" Mode="In"/> </Function> <Function Name="CHARINDEX" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="strSearch" Type="Binary" Mode="In"/> <Parameter Name="strTarget" Type="Binary" Mode="In"/> <Parameter Name="startLocation" Type="Int32" Mode="In"/> </Function> <Function Name="CHARINDEX" BuiltIn="true"> <ReturnType Type="Int64"/> <Parameter Name="strSearch" Type="String" Mode="In"/> <Parameter Name="strTarget" Type="String" Mode="In"/> <Parameter Name="startLocation" Type="Int64" Mode="In"/> </Function> <Function Name="CHARINDEX" BuiltIn="true"> <ReturnType Type="Int64"/> <Parameter Name="strSearch" Type="Binary" Mode="In"/> <Parameter Name="strTarget" Type="Binary" Mode="In"/> <Parameter Name="startLocation" Type="Int64" Mode="In"/> </Function> <!-- DIFFERENCE( str1, str2 ) str1: varchar str2: varchar returns: int --> <Function Name="DIFFERENCE" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="str1" Type="String" Mode="In"/> <Parameter Name="str2" Type="String" Mode="In"/> </Function> <!-- LEFT( str, count ) str: char, nchar, varchar, nvarchar, varchar(max), nvarchar(max) count: tinyint, smallint, int, bigint returns: varchar, nvarchar --> <Function Name="LEFT" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="str" Type="String" Mode="In"/> <Parameter Name="count" Type="Int64" Mode="In"/> </Function> <!-- LEN( string_expression ) string_expression: char, nchar, varchar, nvarchar, varchar(max), nvarchar(max) returns: int, bigint --> <Function Name="LEN" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="string_expression" Type="String" Mode="In"/> </Function> <Function Name="LEN" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="string_expression" Type="Binary" Mode="In"/> </Function> <!-- LOWER( str ) str: char, nchar, varchar, nvarchar, varchar(max), nvarchar(max) returns: varchar, nvarchar --> <Function Name="LOWER" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="str" Type="String" Mode="In"/> </Function> <!-- LTRIM( str ) str: char, nchar, varchar, nvarchar, varchar(max), nvarchar(max) returns: varchar, nvarchar --> <Function Name="LTRIM" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="str" Type="String" Mode="In"/> </Function> <!-- nchar( ncharCode ) ncharCode: tinyint, smallint, int, bigint returns: nchar(1) --> <Function Name="NCHAR" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="arg" Type="Int32" Mode="In"/> </Function> <!-- PATINDEX( strPattern, strTarget ) strPattern: char, nchar, varchar, nvarchar strTarget: char, nchar, varchar, nvarchar, varchar(max), nvarchar(max) returns: int, bigint --> <Function Name="PATINDEX" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="strPattern" Type="String" Mode="In"/> <Parameter Name="strTarget" Type="String" Mode="In"/> </Function> <!-- QUOTENAME( character_string [,quote_character] ) character_string: nchar, nvarchar, nvarchar(max) quote_character: nchar, char, varchar, nvarchar returns: nvarchar --> <Function Name="QUOTENAME" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="character_string" Type="String" Mode="In"/> </Function> <Function Name="QUOTENAME" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="character_string" Type="String" Mode="In"/> <Parameter Name="quote_character" Type="String" Mode="In"/> </Function> <!-- REPLACE( strTarget, strSearch, strReplacement ) strTarget: char, nchar, varchar, nvarchar, varchar(max), nvarchar(max) strSearch: char, nchar, varchar, nvarchar, varchar(max), nvarchar(max) strReplacement: char, nchar, varchar, nvarchar, varchar(max), nvarchar(max) returns: varchar, nvarchar --> <Function Name="REPLACE" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="strTarget" Type="String" Mode="In"/> <Parameter Name="strSearch" Type="String" Mode="In"/> <Parameter Name="strReplacement" Type="String" Mode="In"/> </Function> <!-- REPLICATE( strSource, count ) strSource: varchar, nvarchar count: tinyint, smallint, int returns: varchar, nvarchar --> <Function Name="REPLICATE" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="strTarget" Type="String" Mode="In"/> <Parameter Name="count" Type="Int32" Mode="In"/> </Function> <!-- REVERSE( arg ) arg: char, nchar, varchar, nvarchar, varchar(max), nvarchar(max) returns: varchar, nvarchar --> <Function Name="REVERSE" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="arg" Type="String" Mode="In"/> </Function> <!-- RIGHT( atr, count ) str: char, nchar, varchar, nvarchar, varchar(max), nvarchar(max) count: tinyint, smallint, int, bigint returns: varchar, nvarchar --> <Function Name="RIGHT" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="str" Type="String" Mode="In"/> <Parameter Name="count" Type="Int64" Mode="In"/> </Function> <!-- RTRIM( arg1 ) str: char, nchar, varchar, nvarchar, varchar(max), nvarchar(max) returns: varchar, nvarchar --> <Function Name="RTRIM" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="str" Type="String" Mode="In"/> </Function> <!-- SOUNDEX( arg ) arg: char, nchar, varchar, nvarchar, varchar(max), nvarchar(max) returns: varchar --> <Function Name="SOUNDEX" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="arg" Type="String" Mode="In"/> </Function> <!-- SPACE( arg ) arg: tinyint, smallint, int returns: char --> <Function Name="SPACE" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="arg1" Type="Int32" Mode="In"/> </Function> <!-- STR( number [,length [,decimal]] ) number: float length: int decimal: int returns: char --> <Function Name="STR" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="number" Type="Double" Mode="In"/> </Function> <Function Name="STR" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="number" Type="Decimal" Mode="In"/> </Function> <Function Name="STR" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="number" Type="Double" Mode="In"/> <Parameter Name="length" Type="Int32" Mode="In"/> </Function> <Function Name="STR" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="number" Type="Decimal" Mode="In"/> <Parameter Name="length" Type="Int32" Mode="In"/> </Function> <Function Name="STR" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="number" Type="Double" Mode="In"/> <Parameter Name="length" Type="Int32" Mode="In"/> <Parameter Name="decimal" Type="Int32" Mode="In"/> </Function> <Function Name="STR" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="number" Type="Decimal" Mode="In"/> <Parameter Name="length" Type="Int32" Mode="In"/> <Parameter Name="decimal" Type="Int32" Mode="In"/> </Function> <!-- STUFF( strInput, start, length, strReplacement ) strInput: varchar, nvarchar start: int legth: int strReplacement: varchar, nvarchar returns: int, bigint --> <Function Name="STUFF" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="strInput" Type="String" Mode="In"/> <Parameter Name="start" Type="Int32" Mode="In"/> <Parameter Name="length" Type="Int32" Mode="In"/> <Parameter Name="strReplacement" Type="String" Mode="In"/> </Function> <!-- SUBSTRING( str, start, length ) str: char, nchar, varchar, nvarchar, varchar(max), nvarchar(max) start: tinyint, smallint, int, bigint length: tinyint, smallint, int, bigint returns: varchar, nvarchar --> <Function Name="SUBSTRING" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="str" Type="String" Mode="In"/> <Parameter Name="start" Type="Int64" Mode="In"/> <Parameter Name="length" Type="Int64" Mode="In"/> </Function> <Function Name="SUBSTRING" BuiltIn="true"> <ReturnType Type="Binary"/> <Parameter Name="str" Type="Binary" Mode="In"/> <Parameter Name="start" Type="Int64" Mode="In"/> <Parameter Name="length" Type="Int64" Mode="In"/> </Function> <!-- UNICODE( arg ) arg: nchar, nvarchar returns: int --> <Function Name="UNICODE" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="String" Mode="In"/> </Function> <!-- UPPER( arg ) str: char, nchar, varchar, nvarchar, varchar(max), nvarchar(max) returns: varchar, nvarchar --> <Function Name="UPPER" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="str" Type="String" Mode="In"/> </Function> <!-- END STRING FUNCTIONS ####################################### --> <!-- BEGIN MATH FUNCTIONS ####################################### --> <!-- ABS( arg ) arg: tinyint, smallint, int, bigint, numeric, decimal, smallmoney, money, real, float returns: tinyint, smallint, int, bigint, numeric, decimal, smallmoney, money, real, float --> <Function Name="ABS" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="Int32" Mode="In"/> </Function> <Function Name="ABS" BuiltIn="true"> <ReturnType Type="Int64"/> <Parameter Name="arg" Type="Int64" Mode="In"/> </Function> <Function Name="ABS" BuiltIn="true"> <ReturnType Type="Decimal"/> <Parameter Name="arg" Type="Decimal" Mode="In"/> </Function> <Function Name="ABS" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Double" Mode="In"/> </Function> <!-- ACOS( arg ) arg: float returns: float --> <Function Name="ACOS" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg1" Type="Double" Mode="In"/> </Function> <Function Name="ACOS" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg1" Type="Decimal" Mode="In"/> </Function> <!-- ASIN( arg ) arg: float returns: float --> <Function Name="ASIN" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Double" Mode="In"/> </Function> <Function Name="ASIN" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Decimal" Mode="In"/> </Function> <!-- ATAN( arg ) arg: float returns: float --> <Function Name="ATAN" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Double" Mode="In"/> </Function> <Function Name="ATAN" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Decimal" Mode="In"/> </Function> <!-- ATN2( arg1, arg2 ) arg1: float arg2: float returns: float --> <Function Name="ATN2" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg1" Type="Double" Mode="In"/> <Parameter Name="arg2" Type="Double" Mode="In"/> </Function> <Function Name="ATN2" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg1" Type="Decimal" Mode="In"/> <Parameter Name="arg2" Type="Decimal" Mode="In"/> </Function> <!-- CEILING( arg ) arg: smalldatetime, datetime returns: int --> <Function Name="CEILING" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="Int32" Mode="In"/> </Function> <Function Name="CEILING" BuiltIn="true"> <ReturnType Type="Int64"/> <Parameter Name="arg" Type="Int64" Mode="In"/> </Function> <Function Name="CEILING" BuiltIn="true"> <ReturnType Type="Decimal"/> <Parameter Name="arg" Type="Decimal" Mode="In"/> </Function> <Function Name="CEILING" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Double" Mode="In"/> </Function> <!-- COS( arg ) arg: float returns: float --> <Function Name="COS" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Double" Mode="In"/> </Function> <Function Name="COS" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Decimal" Mode="In"/> </Function> <!-- COT( arg ) arg: float returns: float --> <Function Name="COT" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Double" Mode="In"/> </Function> <Function Name="COT" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Decimal" Mode="In"/> </Function> <!-- DEGREES( arg ) arg: tinyint, smallint, int, bigint, numeric, decimal, smallmoney, money, real, float returns: tinyint, smallint, int, bigint, numeric, decimal, smallmoney, money, real, float --> <Function Name="DEGREES" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="Int32" Mode="In"/> </Function> <Function Name="DEGREES" BuiltIn="true"> <ReturnType Type="Int64"/> <Parameter Name="arg1" Type="Int64" Mode="In"/> </Function> <Function Name="DEGREES" BuiltIn="true"> <ReturnType Type="Decimal"/> <Parameter Name="arg1" Type="Decimal" Mode="In"/> </Function> <Function Name="DEGREES" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg1" Type="Double" Mode="In"/> </Function> <!-- EXP( arg ) arg: float returns: float --> <Function Name="EXP" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Double" Mode="In"/> </Function> <Function Name="EXP" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Decimal" Mode="In"/> </Function> <!-- FLOOR( arg ) arg: tinyint, smallint, int, bigint, numeric, decimal, smallmoney, money, real, float returns: tinyint, smallint, int, bigint, numeric, decimal, smallmoney, money, real, float --> <Function Name="FLOOR" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="Int32" Mode="In"/> </Function> <Function Name="FLOOR" BuiltIn="true"> <ReturnType Type="Int64"/> <Parameter Name="arg" Type="Int64" Mode="In"/> </Function> <Function Name="FLOOR" BuiltIn="true"> <ReturnType Type="Decimal"/> <Parameter Name="arg" Type="Decimal" Mode="In"/> </Function> <Function Name="FLOOR" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Double" Mode="In"/> </Function> <!-- LOG( arg ) arg: float returns: float --> <Function Name="LOG" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Double" Mode="In"/> </Function> <Function Name="LOG" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Decimal" Mode="In"/> </Function> <!-- LOG10( arg ) arg: float returns: float --> <Function Name="LOG10" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Double" Mode="In"/> </Function> <Function Name="LOG10" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Decimal" Mode="In"/> </Function> <!-- PI( ) returns: float --> <Function Name="PI" BuiltIn="true"> <ReturnType Type="Double"/> </Function> <!-- POWER( x, y ) x: tinyint, smallint, int, bigint, numeric, decimal, smallmoney, money, real, float y: tinyint, smallint, int, bigint, numeric, decimal, smallmoney, money, real, float returns: tinyint, smallint, int, bigint, numeric, decimal, smallmoney, money, real, float --> <Function Name="POWER" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="x" Type="Int32" Mode="In"/> <Parameter Name="y" Type="Double" Mode="In"/> </Function> <Function Name="POWER" BuiltIn="true"> <ReturnType Type="Int64"/> <Parameter Name="x" Type="Int64" Mode="In"/> <Parameter Name="y" Type="Double" Mode="In"/> </Function> <Function Name="POWER" BuiltIn="true"> <ReturnType Type="Decimal"/> <Parameter Name="x" Type="Decimal" Mode="In"/> <Parameter Name="y" Type="Double" Mode="In"/> </Function> <Function Name="POWER" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="x" Type="Double" Mode="In"/> <Parameter Name="y" Type="Decimal" Mode="In"/> </Function> <Function Name="POWER" BuiltIn="true"> <ReturnType Type="Decimal"/> <Parameter Name="x" Type="Decimal" Mode="In"/> <Parameter Name="y" Type="Decimal" Mode="In"/> </Function> <Function Name="POWER" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="x" Type="Double" Mode="In"/> <Parameter Name="y" Type="Double" Mode="In"/> </Function> <Function Name="POWER" BuiltIn="true"> <ReturnType Type="Int64"/> <Parameter Name="x" Type="Int64" Mode="In"/> <Parameter Name="y" Type="Decimal" Mode="In"/> </Function> <Function Name="POWER" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="x" Type="Int32" Mode="In"/> <Parameter Name="y" Type="Decimal" Mode="In"/> </Function> <!-- RADIANS( arg ) arg: tinyint, smallint, int, bigint, numeric, decimal, smallmoney, money, real, float returns: tinyint, smallint, int, bigint, numeric, decimal, smallmoney, money, real, float --> <Function Name="RADIANS" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="Int32" Mode="In"/> </Function> <Function Name="RADIANS" BuiltIn="true"> <ReturnType Type="Int64"/> <Parameter Name="arg" Type="Int64" Mode="In"/> </Function> <Function Name="RADIANS" BuiltIn="true"> <ReturnType Type="Decimal"/> <Parameter Name="arg" Type="Decimal" Mode="In"/> </Function> <Function Name="RADIANS" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Double" Mode="In"/> </Function> <!-- RAND( [seed] ) seed: tinyint, smallint, int returns: float --> <Function Name="RAND" BuiltIn="true"> <ReturnType Type="Double"/> </Function> <Function Name="RAND" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="seed" Type="Int32" Mode="In"/> </Function> <!-- ROUND( numeric_expression, length [ ,function ] ) numeric_expression: tinyint, smallint, int, bigint, numeric, decimal, smallmoney, money, real, float length: tinyint, smallint, int function: tinyint, smallint, int returns: tinyint, smallint, int, bigint, numeric, decimal, smallmoney, money, real, float --> <Function Name="ROUND" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="numeric_expression" Type="Int32" Mode="In"/> <Parameter Name="length" Type="Int32" Mode="In"/> </Function> <Function Name="ROUND" BuiltIn="true"> <ReturnType Type="Int64"/> <Parameter Name="numeric_expression" Type="Int64" Mode="In"/> <Parameter Name="length" Type="Int32" Mode="In"/> </Function> <Function Name="ROUND" BuiltIn="true"> <ReturnType Type="Decimal"/> <Parameter Name="numeric_expression" Type="Decimal" Mode="In"/> <Parameter Name="length" Type="Int32" Mode="In"/> </Function> <Function Name="ROUND" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="numeric_expression" Type="Double" Mode="In"/> <Parameter Name="length" Type="Int32" Mode="In"/> </Function> <Function Name="ROUND" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="numeric_expression" Type="Int32" Mode="In"/> <Parameter Name="length" Type="Int32" Mode="In"/> <Parameter Name="function" Type="Int32" Mode="In"/> </Function> <Function Name="ROUND" BuiltIn="true"> <ReturnType Type="Int64"/> <Parameter Name="numeric_expression" Type="Int64" Mode="In"/> <Parameter Name="length" Type="Int32" Mode="In"/> <Parameter Name="function" Type="Int32" Mode="In"/> </Function> <Function Name="ROUND" BuiltIn="true"> <ReturnType Type="Decimal"/> <Parameter Name="numeric_expression" Type="Decimal" Mode="In"/> <Parameter Name="length" Type="Int32" Mode="In"/> <Parameter Name="function" Type="Int32" Mode="In"/> </Function> <Function Name="ROUND" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="numeric_expression" Type="Double" Mode="In"/> <Parameter Name="length" Type="Int32" Mode="In"/> <Parameter Name="function" Type="Int32" Mode="In"/> </Function> <!-- SIGN( arg ) arg: tinyint, smallint, int, bigint, numeric, decimal, smallmoney, money, real, float returns: bigint, numeric, decimal, money, float --> <Function Name="SIGN" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="Int32" Mode="In"/> </Function> <Function Name="SIGN" BuiltIn="true"> <ReturnType Type="Int64"/> <Parameter Name="arg" Type="Int64" Mode="In"/> </Function> <Function Name="SIGN" BuiltIn="true"> <ReturnType Type="Decimal"/> <Parameter Name="arg" Type="Decimal" Mode="In"/> </Function> <Function Name="SIGN" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Double" Mode="In"/> </Function> <!-- SIN( arg ) arg: float returns: float --> <Function Name="SIN" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Decimal" Mode="In"/> </Function> <Function Name="SIN" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Double" Mode="In"/> </Function> <!-- SQRT( arg ) arg: float returns: float --> <Function Name="SQRT" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Double" Mode="In"/> </Function> <Function Name="SQRT" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Decimal" Mode="In"/> </Function> <!-- SQUARE( arg ) arg: smalldatetime, datetime returns: int --> <Function Name="SQUARE" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg1" Type="Double" Mode="In"/> </Function> <Function Name="SQUARE" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg1" Type="Decimal" Mode="In"/> </Function> <!-- TAN( arg ) arg: float returns: float --> <Function Name="TAN" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Double" Mode="In"/> </Function> <Function Name="TAN" BuiltIn="true"> <ReturnType Type="Double"/> <Parameter Name="arg" Type="Decimal" Mode="In"/> </Function> <!-- END MATH FUNCTIONS ######################################### --> <!-- BEGIN DATE FUNCTIONS ####################################### --> <!-- DATEADD datepart: nvarchar number: tinyint, smallint, int, bigint, numeric, decimal, real, float date: smalldatetime, datetime, varchar, nvarchar, char, nchar returns: SMALLTIME, datetime --> <Function Name="DATEADD" BuiltIn="true"> <ReturnType Type="DateTime"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="number" Type="Double" Mode="In"/> <Parameter Name="date" Type="DateTime" Mode="In"/> </Function> <Function Name="DATEADD" BuiltIn="true"> <ReturnType Type="Time"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="number" Type="Double" Mode="In"/> <Parameter Name="time" Type="Time" Mode="In"/> </Function> <Function Name="DATEADD" BuiltIn="true"> <ReturnType Type="DateTimeOffset"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="number" Type="Double" Mode="In"/> <Parameter Name="datetimeoffset" Type="DateTimeOffset" Mode="In"/> </Function> <Function Name="DATEADD" BuiltIn="true"> <ReturnType Type="DateTime"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="number" Type="Double" Mode="In"/> <Parameter Name="date" Type="String" Mode="In"/> </Function> <!-- DATEDIFF( datepart, startdate, enddate ) datepart: nvarchar startdate: smalldatetime, datetime, char, nchar, varchar, nvarchar enddate: smalldatetime, datetime, char, nchar, varchar, nvarchar returns: int --> <Function Name="DATEDIFF" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="startdate" Type="DateTime" Mode="In"/> <Parameter Name="enddate" Type="DateTime" Mode="In"/> </Function> <Function Name="DATEDIFF" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="startdate" Type="DateTimeOffset" Mode="In"/> <Parameter Name="enddate" Type="DateTimeOffset" Mode="In"/> </Function> <Function Name="DATEDIFF" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="startdate" Type="Time" Mode="In"/> <Parameter Name="enddate" Type="Time" Mode="In"/> </Function> <Function Name="DATEDIFF" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="startdate" Type="String" Mode="In"/> <Parameter Name="enddate" Type="DateTime" Mode="In"/> </Function> <Function Name="DATEDIFF" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="startdate" Type="String" Mode="In"/> <Parameter Name="enddate" Type="DateTimeOffset" Mode="In"/> </Function> <Function Name="DATEDIFF" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="startdate" Type="String" Mode="In"/> <Parameter Name="enddate" Type="Time" Mode="In"/> </Function> <Function Name="DATEDIFF" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="startdate" Type="Time" Mode="In"/> <Parameter Name="enddate" Type="String" Mode="In"/> </Function> <Function Name="DATEDIFF" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="startdate" Type="DateTime" Mode="In"/> <Parameter Name="enddate" Type="String" Mode="In"/> </Function> <Function Name="DATEDIFF" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="startdate" Type="DateTimeOffset" Mode="In"/> <Parameter Name="enddate" Type="String" Mode="In"/> </Function> <Function Name="DATEDIFF" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="startdate" Type="String" Mode="In"/> <Parameter Name="enddate" Type="String" Mode="In"/> </Function> <Function Name="DATEDIFF" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="startdate" Type="Time" Mode="In"/> <Parameter Name="enddate" Type="DateTime" Mode="In"/> </Function> <Function Name="DATEDIFF" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="startdate" Type="Time" Mode="In"/> <Parameter Name="enddate" Type="DateTimeOffset" Mode="In"/> </Function> <Function Name="DATEDIFF" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="startdate" Type="DateTime" Mode="In"/> <Parameter Name="enddate" Type="Time" Mode="In"/> </Function> <Function Name="DATEDIFF" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="startdate" Type="DateTimeOffset" Mode="In"/> <Parameter Name="enddate" Type="Time" Mode="In"/> </Function> <Function Name="DATEDIFF" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="startdate" Type="DateTime" Mode="In"/> <Parameter Name="enddate" Type="DateTimeOffset" Mode="In"/> </Function> <Function Name="DATEDIFF" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="startdate" Type="DateTimeOffset" Mode="In"/> <Parameter Name="enddate" Type="DateTime" Mode="In"/> </Function> <!-- DATENAME( datepart, date ) datepart: nvarchar date: smalldatetime, datetime, char, nchar, varchar, nvarchar returns: nvarchar --> <Function Name="DATENAME" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="date" Type="DateTime" Mode="In"/> </Function> <Function Name="DATENAME" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="date" Type="String" Mode="In"/> </Function> <Function Name="DATENAME" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="date" Type="Time" Mode="In"/> </Function> <Function Name="DATENAME" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="date" Type="DateTimeOffset" Mode="In"/> </Function> <!-- DATEPART( datepart, date ) datepart: nvarchar date: smalldatetime, datetime, char, nchar, varchar, nvarchar returns: int --> <Function Name="DATEPART" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="date" Type="DateTime" Mode="In"/> </Function> <Function Name="DATEPART" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="date" Type="DateTimeOffset" Mode="In"/> </Function> <Function Name="DATEPART" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="date" Type="String" Mode="In"/> </Function> <Function Name="DATEPART" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="datepart" Type="String" Mode="In"/> <Parameter Name="date" Type="Time" Mode="In"/> </Function> <!-- DAY( date ) date: smalldatetime, datetime returns: int --> <Function Name="DAY" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="date" Type="DateTime" Mode="In"/> </Function> <Function Name="DAY" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="date" Type="DateTimeOffset" Mode="In"/> </Function> <Function Name="DAY" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="date" Type="String" Mode="In"/> </Function> <!-- GETDATE() returns: datetime --> <Function Name="GETDATE" BuiltIn="true"> <ReturnType Type="DateTime"/> </Function> <!-- SYSDATETIME() returns: datetime --> <Function Name="SYSDATETIME" BuiltIn="true"> <ReturnType Type="DateTime"/> </Function> <!-- SYSUTCDATETIME() returns: datetime --> <Function Name="SYSUTCDATETIME" BuiltIn="true"> <ReturnType Type="DateTime"/> </Function> <!-- SYSDATETIMEOFFSET() returns: datetime --> <Function Name="SYSDATETIMEOFFSET" BuiltIn="true"> <ReturnType Type="DateTimeOffset"/> </Function> <!-- GETUTCDATE() returns: datetime --> <Function Name="GETUTCDATE" BuiltIn="true"> <ReturnType Type="DateTime"/> </Function> <!-- MONTH( date ) date: smalldatetime, datetime returns: int --> <Function Name="MONTH" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="date" Type="DateTime" Mode="In"/> </Function> <Function Name="MONTH" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="date" Type="DateTimeOffset" Mode="In"/> </Function> <Function Name="MONTH" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="date" Type="String" Mode="In"/> </Function> <!-- YEAR( date ) date: smalldatetime, datetime returns: int --> <Function Name="YEAR" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="date" Type="DateTime" Mode="In"/> </Function> <Function Name="YEAR" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="date" Type="DateTimeOffset" Mode="In"/> </Function> <Function Name="YEAR" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="date" Type="String" Mode="In"/> </Function> <!-- END DATE FUNCTIONS ######################################### --> <!-- BEGIN SYSTEM FUNCTIONS ##################################### --> <!-- DATALENGTH( arg ) arg: any returns: int, bigint --> <Function Name="DATALENGTH" BuiltIn="true" ParameterTypeSemantics="AllowImplicitPromotion"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="Boolean" Mode="In"/> </Function> <Function Name="DATALENGTH" BuiltIn="true" ParameterTypeSemantics="AllowImplicitPromotion"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="Double" Mode="In"/> </Function> <Function Name="DATALENGTH" BuiltIn="true" ParameterTypeSemantics="AllowImplicitPromotion"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="Decimal" Mode="In"/> </Function> <Function Name="DATALENGTH" BuiltIn="true" ParameterTypeSemantics="AllowImplicitPromotion"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="DateTime" Mode="In"/> </Function> <Function Name="DATALENGTH" BuiltIn="true" ParameterTypeSemantics="AllowImplicitPromotion"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="Time" Mode="In"/> </Function> <Function Name="DATALENGTH" BuiltIn="true" ParameterTypeSemantics="AllowImplicitPromotion"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="DateTimeOffset" Mode="In"/> </Function> <Function Name="DATALENGTH" BuiltIn="true" ParameterTypeSemantics="AllowImplicitPromotion"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="String" Mode="In"/> </Function> <Function Name="DATALENGTH" BuiltIn="true" ParameterTypeSemantics="AllowImplicitPromotion"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="Binary" Mode="In"/> </Function> <Function Name="DATALENGTH" BuiltIn="true" ParameterTypeSemantics="AllowImplicitPromotion"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="Guid" Mode="In"/> </Function> <!-- CHECKSUM --> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="Boolean" Mode="In"/> </Function> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="Double" Mode="In"/> </Function> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="Decimal" Mode="In"/> </Function> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="String" Mode="In"/> </Function> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="DateTime" Mode="In"/> </Function> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="Time" Mode="In"/> </Function> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="DateTimeOffset" Mode="In"/> </Function> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="Binary" Mode="In"/> </Function> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="Guid" Mode="In"/> </Function> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="Boolean" Mode="In"/> <Parameter Name="arg2" Type="Boolean" Mode="In"/> </Function> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="Double" Mode="In"/> <Parameter Name="arg2" Type="Double" Mode="In"/> </Function> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="Decimal" Mode="In"/> <Parameter Name="arg2" Type="Decimal" Mode="In"/> </Function> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="String" Mode="In"/> <Parameter Name="arg2" Type="String" Mode="In"/> </Function> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="DateTime" Mode="In"/> <Parameter Name="arg2" Type="DateTime" Mode="In"/> </Function> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="Time" Mode="In"/> <Parameter Name="arg2" Type="Time" Mode="In"/> </Function> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="DateTimeOffset" Mode="In"/> <Parameter Name="arg2" Type="DateTimeOffset" Mode="In"/> </Function> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="Binary" Mode="In"/> <Parameter Name="arg2" Type="Binary" Mode="In"/> </Function> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="Guid" Mode="In"/> <Parameter Name="arg2" Type="Guid" Mode="In"/> </Function> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="Boolean" Mode="In"/> <Parameter Name="arg2" Type="Boolean" Mode="In"/> <Parameter Name="arg3" Type="Boolean" Mode="In"/> </Function> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="Double" Mode="In"/> <Parameter Name="arg2" Type="Double" Mode="In"/> <Parameter Name="arg3" Type="Double" Mode="In"/> </Function> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="Decimal" Mode="In"/> <Parameter Name="arg2" Type="Decimal" Mode="In"/> <Parameter Name="arg3" Type="Decimal" Mode="In"/> </Function> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="String" Mode="In"/> <Parameter Name="arg2" Type="String" Mode="In"/> <Parameter Name="arg3" Type="String" Mode="In"/> </Function> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="DateTime" Mode="In"/> <Parameter Name="arg2" Type="DateTime" Mode="In"/> <Parameter Name="arg3" Type="DateTime" Mode="In"/> </Function> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="DateTimeOffset" Mode="In"/> <Parameter Name="arg2" Type="DateTimeOffset" Mode="In"/> <Parameter Name="arg3" Type="DateTimeOffset" Mode="In"/> </Function> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="Time" Mode="In"/> <Parameter Name="arg2" Type="Time" Mode="In"/> <Parameter Name="arg3" Type="Time" Mode="In"/> </Function> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="Binary" Mode="In"/> <Parameter Name="arg2" Type="Binary" Mode="In"/> <Parameter Name="arg3" Type="Binary" Mode="In"/> </Function> <Function Name="CHECKSUM" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg1" Type="Guid" Mode="In"/> <Parameter Name="arg2" Type="Guid" Mode="In"/> <Parameter Name="arg3" Type="Guid" Mode="In"/> </Function> <!-- NEWID() --> <Function Name="NEWID" BuiltIn="true"> <ReturnType Type="Guid"/> </Function> <!-- CURRENT_TIMESTAMP --> <Function Name="CURRENT_TIMESTAMP" BuiltIn="true" NiladicFunction="true"> <ReturnType Type="DateTime"/> </Function> <!-- CURRENT_USER --> <Function Name="CURRENT_USER" BuiltIn="true" NiladicFunction="true"> <ReturnType Type="String"/> </Function> <!-- HOST_NAME() --> <Function Name="HOST_NAME" BuiltIn="true"> <ReturnType Type="String"/> </Function> <!-- USER_NAME() --> <Function Name="USER_NAME" BuiltIn="true"> <ReturnType Type="String"/> <Parameter Name="arg" Type="Int32" Mode="In"/> </Function> <Function Name="USER_NAME" BuiltIn="true"> <ReturnType Type="String"/> </Function> <!-- ISNUMERIC( arg ) //implicit conversion --> <Function Name="ISNUMERIC" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="String" Mode="In"/> </Function> <!-- ISDATE( arg ) //implicit conversion --> <Function Name="ISDATE" BuiltIn="true"> <ReturnType Type="Int32"/> <Parameter Name="arg" Type="String" Mode="In"/> </Function> <!-- END SYSTEM FUNCTIONS ####################################### --> </Functions> </ProviderManifest> º <?xml version="1.0" encoding="utf-8"?> <xs:schema elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema" targetNamespace="http://schemas.microsoft.com/ado/2006/04/edm/providermanifest" xmlns:pm="http://schemas.microsoft.com/ado/2006/04/edm/providermanifest"> <xs:element name="ProviderManifest"> <xs:complexType> <xs:sequence> <xs:element name="Types" type="pm:TTypes" minOccurs="1" maxOccurs="1"/> <xs:element name="Functions" type="pm:TFunctions" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:attribute name="Namespace" type="xs:string" use="required"/> </xs:complexType> </xs:element> <xs:complexType name="TVersion"> <xs:attribute name="Major" type="xs:int" use="required"/> <xs:attribute name="Minor" type="xs:int" use="required"/> <xs:attribute name="Build" type="xs:int" use="required"/> <xs:attribute name="Revision" type="xs:int" use="required"/> </xs:complexType> <xs:complexType name="TIntegerFacetDescription"> <xs:attribute name="Minimum" type="xs:int" use="optional"/> <xs:attribute name="Maximum" type="xs:int" use="optional"/> <xs:attribute name="DefaultValue" type="xs:int" use="optional"/> <xs:attribute name="Constant" type="xs:boolean" default="false"/> </xs:complexType> <xs:complexType name="TBooleanFacetDescription"> <xs:attribute name="DefaultValue" type="xs:boolean" use="optional"/> <xs:attribute name="Constant" type="xs:boolean" default="true"/> </xs:complexType> <xs:complexType name="TDateTimeFacetDescription"> <xs:attribute name="Constant" type="xs:boolean" default="false"/> </xs:complexType> <xs:complexType name="TFacetDescriptions"> <xs:choice maxOccurs="unbounded"> <xs:element name="Precision" minOccurs="0" maxOccurs="1" type="pm:TIntegerFacetDescription"/> <xs:element name="Scale" minOccurs="0" maxOccurs="1" type="pm:TIntegerFacetDescription"/> <xs:element name="MaxLength" minOccurs="0" maxOccurs="1" type="pm:TIntegerFacetDescription"/> <xs:element name="Unicode" minOccurs="0" maxOccurs="1" type="pm:TBooleanFacetDescription"/> <xs:element name="FixedLength" minOccurs="0" maxOccurs="1" type="pm:TBooleanFacetDescription"/> </xs:choice> </xs:complexType> <xs:complexType name="TType"> <xs:sequence> <xs:element name="FacetDescriptions" type="pm:TFacetDescriptions" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:attribute name="Name" type="xs:string" use="required"/> <xs:attribute name="PrimitiveTypeKind" type="pm:TPrimitiveTypeKind" use="required"/> </xs:complexType> <xs:complexType name="TTypes"> <xs:sequence> <xs:element name="Type" type="pm:TType" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> </xs:complexType> <xs:attributeGroup name="TFacetAttribute"> <xs:attribute name="Precision" type="xs:int" use="optional"/> <xs:attribute name="Scale" type="xs:int" use="optional"/> <xs:attribute name="MaxLength" type="xs:int" use="optional"/> <xs:attribute name="Unicode" type="xs:boolean" use="optional"/> <xs:attribute name="FixedLength" type="xs:boolean" use="optional"/> </xs:attributeGroup> <xs:complexType name="TFunctionParameter"> <xs:attribute name="Name" type="xs:string" use="required"/> <xs:attribute name="Type" type="xs:string" use="required"/> <xs:attributeGroup ref="pm:TFacetAttribute"/> <xs:attribute name="Mode" type="pm:TParameterDirection" use="required"/> </xs:complexType> <xs:complexType name="TReturnType"> <xs:attribute name="Type" type="xs:string" use="required"/> <xs:attributeGroup ref="pm:TFacetAttribute"/> </xs:complexType> <xs:complexType name="TFunction"> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="ReturnType" type="pm:TReturnType" minOccurs="0" maxOccurs="1"/> <xs:element name="Parameter" type="pm:TFunctionParameter" minOccurs="0" maxOccurs="unbounded"/> </xs:choice> <xs:attribute name="Name" type="xs:string" use="required"/> <xs:attribute name="Aggregate" type="xs:boolean" use="optional"/> <xs:attribute name="BuiltIn" type="xs:boolean" use="optional"/> <xs:attribute name="StoreFunctionName" type="xs:string" use="optional"/> <xs:attribute name="NiladicFunction" type="xs:boolean" use="optional"/> <xs:attribute name="ParameterTypeSemantics" type="pm:TParameterTypeSemantics" use="optional" default="AllowImplicitConversion"/> </xs:complexType> <xs:complexType name="TFunctions"> <xs:sequence> <xs:element name="Function" type="pm:TFunction" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> </xs:complexType> <xs:simpleType name="TPrimitiveTypeKind"> <xs:restriction base="xs:string"> <xs:enumeration value="Binary"/> <xs:enumeration value="Boolean"/> <xs:enumeration value="Byte"/> <xs:enumeration value="Decimal"/> <xs:enumeration value="DateTime"/> <xs:enumeration value="Time"/> <xs:enumeration value="DateTimeOffset"/> <xs:enumeration value="Double"/> <xs:enumeration value="Guid"/> <xs:enumeration value="Single"/> <xs:enumeration value="SByte"/> <xs:enumeration value="Int16"/> <xs:enumeration value="Int32"/> <xs:enumeration value="Int64"/> <xs:enumeration value="String"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="TParameterDirection"> <xs:restriction base="xs:string"> <xs:enumeration value="In"/> <xs:enumeration value="Out"/> <xs:enumeration value="InOut"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="TParameterTypeSemantics"> <xs:restriction base="xs:string"> <xs:enumeration value="ExactMatchOnly"/> <xs:enumeration value="AllowImplicitPromotion"/> <xs:enumeration value="AllowImplicitConversion"/> </xs:restriction> </xs:simpleType> </xs:schema> Ñ <?xml version="1.0" encoding="utf-8"?> <xs:schema elementFormDefault="qualified" attributeFormDefault="unqualified" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:source="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" targetNamespace="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator"> <xs:annotation> <xs:documentation xml:lang="en"> Common Data Model Schema Definition Language. Copyright (c) Microsoft Corp. All rights reserved. </xs:documentation> </xs:annotation> <xs:attribute name="Type" type="source:TSourceType"/> <xs:attribute name="Schema" type="xs:string"/> <xs:attribute name="Name" type="xs:string"/> <xs:simpleType name="TSourceType"> <xs:restriction base="xs:string"> <xs:enumeration value="Tables"/> <xs:enumeration value="Views"/> </xs:restriction> </xs:simpleType> </xs:schema> ³Q <?xml version="1.0" encoding="utf-8"?> <xs:schema elementFormDefault="qualified" attributeFormDefault="unqualified" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:edm="http://schemas.microsoft.com/ado/2006/04/edm/ssdl" xmlns:gen="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" targetNamespace="http://schemas.microsoft.com/ado/2006/04/edm/ssdl"> <xs:annotation> <xs:documentation xml:lang="en"> Common Data Model Schema Definition Language. Copyright (c) Microsoft Corp. All rights reserved. </xs:documentation> </xs:annotation> <xs:import namespace="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" schemaLocation="System.Data.Resources.EntityStoreSchemaGenerator.xsd"/> <xs:element name="Schema" type="edm:TSchema"/> <xs:complexType name="TSchema"> <xs:sequence> <xs:group ref="edm:GSchemaBodyElements" minOccurs="0" maxOccurs="unbounded"/> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:attribute name="Namespace" type="edm:TQualifiedName" use="required"/> <xs:attribute name="Alias" type="edm:TSimpleIdentifier" use="optional"/> <xs:attribute name="Provider" type="edm:TSimpleIdentifier" use="required"/> <xs:attribute name="ProviderManifestToken" type="edm:TSimpleIdentifier" use="required"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:group name="GSchemaBodyElements"> <xs:choice> <xs:element name="Association" type="edm:TAssociation" minOccurs="0" maxOccurs="unbounded"/> <xs:element name="EntityType" type="edm:TEntityType" minOccurs="0" maxOccurs="unbounded"/> <xs:element ref="edm:EntityContainer" minOccurs="1" maxOccurs="1"/> <xs:element name="Function" type="edm:TFunction" minOccurs="0" maxOccurs="unbounded"/> </xs:choice> </xs:group> <xs:simpleType name="TMax"> <xs:restriction base="xs:string"> <xs:enumeration value="Max"/> </xs:restriction> </xs:simpleType> <!-- Facets for Primitive types --> <xs:simpleType name="TMaxLengthFacet"> <xs:union memberTypes="edm:TMax xs:nonNegativeInteger"/> </xs:simpleType> <xs:simpleType name="TIsFixedLengthFacet"> <xs:restriction base="xs:boolean"/> </xs:simpleType> <xs:simpleType name="TKindFacet"> <xs:restriction base="xs:string"> <xs:enumeration value="Utc"/> <xs:enumeration value="Local"/> <xs:enumeration value="Unspecified"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="TPrecisionFacet"> <xs:restriction base="xs:nonNegativeInteger"/> </xs:simpleType> <xs:simpleType name="TScaleFacet"> <xs:restriction base="xs:nonNegativeInteger"/> </xs:simpleType> <xs:simpleType name="TIsUnicodeFacet"> <xs:restriction base="xs:boolean"/> </xs:simpleType> <xs:simpleType name="TCollationFacet"> <xs:restriction base="xs:string"/> </xs:simpleType> <!-- types of the top level elements --> <xs:complexType name="TDocumentation"> <xs:annotation> <xs:documentation>The Documentation element is used to provide documentation of comments on the contents of the XML file. It is valid under Schema, Type, Index and Relationship elements. </xs:documentation> </xs:annotation> <xs:sequence> <xs:element name="Summary" type="edm:TText" minOccurs="0" maxOccurs="1"/> <xs:element name="LongDescription" type="edm:TText" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:anyAttribute processContents="lax" namespace="##other"/> </xs:complexType> <xs:complexType name="TText" mixed="true"> <xs:sequence> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:anyAttribute processContents="lax" namespace="##other"/> </xs:complexType> <xs:complexType name="TUsing"> <xs:sequence> <xs:group ref="edm:GEmptyElementExtensibility" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:attribute name="Namespace" type="edm:TQualifiedName" use="required"/> <xs:attribute name="Alias" type="edm:TSimpleIdentifier" use="required"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:complexType name="TAssociation"> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:element name="End" type="edm:TAssociationEnd" minOccurs="2" maxOccurs="2"/> <xs:element name="ReferentialConstraint" type="edm:TConstraint" minOccurs="0" maxOccurs="1"/> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:attribute name="Name" type="edm:TUndottedIdentifier" use="required"/> <!--<xs:attribute name="Identifying" type="xs:boolean" use="optional" default="false" />--> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:complexType name="TConstraint"> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:element name="Principal" type="edm:TReferentialConstraintRoleElement" minOccurs="1" maxOccurs="1"/> <xs:element name="Dependent" type="edm:TReferentialConstraintRoleElement" minOccurs="1" maxOccurs="1"/> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:complexType name="TNavigationProperty"> <xs:sequence> <xs:group ref="edm:GEmptyElementExtensibility" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:attribute name="Name" type="edm:TSimpleIdentifier" use="required"/> <xs:attribute name="Relationship" type="edm:TQualifiedName" use="required"/> <xs:attribute name="ToRole" type="edm:TSimpleIdentifier" use="required"/> <xs:attribute name="FromRole" type="edm:TSimpleIdentifier" use="required"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:complexType name="TReferentialConstraintRoleElement"> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:element name="PropertyRef" type="edm:TPropertyRef" minOccurs="1" maxOccurs="unbounded"/> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:attribute name="Role" type="edm:TSimpleIdentifier" use="required"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:complexType name="TEntityType"> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:element name="Key" type="edm:TEntityKeyElement" minOccurs="0" maxOccurs="1"/> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="Property" type="edm:TEntityProperty" minOccurs="0" maxOccurs="unbounded"/> <xs:element name="NavigationProperty" type="edm:TNavigationProperty" minOccurs="0" maxOccurs="unbounded"/> </xs:choice> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:attribute name="Name" type="edm:TUndottedIdentifier" use="required"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:complexType name="TEntityKeyElement"> <xs:sequence> <xs:element name="PropertyRef" type="edm:TPropertyRef" minOccurs="1" maxOccurs="unbounded"/> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> </xs:complexType> <xs:complexType name="TPropertyRef"> <xs:sequence> <xs:group ref="edm:GEmptyElementExtensibility" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:attribute name="Name" type="edm:TSimpleIdentifier" use="required"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:group name="GEmptyElementExtensibility"> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> </xs:group> <!-- base types --> <xs:complexType name="TAssociationEnd"> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:group ref="edm:TOperations" minOccurs="0" maxOccurs="unbounded"/> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:attribute name="Type" type="edm:TQualifiedName" use="required"/> <xs:attribute name="Role" type="edm:TSimpleIdentifier" use="optional"/> <xs:attribute name="Multiplicity" type="edm:TMultiplicity" use="required"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:group name="TOperations"> <xs:choice> <xs:element name="OnDelete" type="edm:TOnAction" maxOccurs="1" minOccurs="0"/> </xs:choice> </xs:group> <xs:complexType name="TOnAction"> <xs:sequence> <xs:group ref="edm:GEmptyElementExtensibility" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:attribute name="Action" type="edm:TAction" use="required"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:complexType name="TEntityProperty"> <xs:sequence> <xs:group ref="edm:GEmptyElementExtensibility" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:attributeGroup ref="edm:TCommonPropertyAttributes"/> <xs:attribute name="StoreGeneratedPattern" type="edm:TStoreGeneratedPattern" use="optional"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:attributeGroup name="TCommonPropertyAttributes"> <xs:attribute name="Name" type="edm:TSimpleIdentifier" use="required"/> <xs:attribute name="Type" type="edm:TPropertyType" use="required"/> <xs:attribute name="Nullable" type="xs:boolean" default="true" use="optional"/> <xs:attribute name="DefaultValue" type="xs:string" use="optional"/> <!-- Start Facets --> <xs:attribute name="MaxLength" type="edm:TMaxLengthFacet" use="optional"/> <xs:attribute name="FixedLength" type="edm:TIsFixedLengthFacet" use="optional"/> <xs:attribute name="Precision" type="edm:TPrecisionFacet" use="optional"/> <xs:attribute name="Scale" type="edm:TScaleFacet" use="optional"/> <xs:attribute name="Unicode" type="edm:TIsUnicodeFacet" use="optional"/> <xs:attribute name="Collation" type="edm:TCollationFacet" use="optional"/> <!--End Facets --> </xs:attributeGroup> <xs:element name="EntityContainer"> <xs:complexType> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="EntitySet"> <xs:complexType> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:element name="DefiningQuery" type="edm:TCommandText" minOccurs="0" maxOccurs="1"/> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:attribute name="Name" type="edm:TUndottedIdentifier" use="required"/> <xs:attribute name="EntityType" type="edm:TQualifiedName" use="required"/> <xs:attribute name="Schema" type="edm:TSimpleIdentifier" use="optional"/> <xs:attribute name="Table" type="edm:TSimpleIdentifier" use="optional"/> <xs:attribute ref="gen:Type" use="optional"/> <xs:attribute ref="gen:Schema" use="optional"/> <xs:attribute ref="gen:Name" use="optional"/> <xs:anyAttribute processContents="lax" namespace="##other"/> </xs:complexType> </xs:element> <xs:element name="AssociationSet"> <xs:complexType> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:element name="End" minOccurs="0" maxOccurs="2"> <!-- 1. The number of Ends has to match with ones defined in AssociationType 2. Value for attribute Name should match the defined ones and EntitySet should be of the defined Entity Type in AssociationType --> <xs:complexType> <xs:sequence> <xs:group ref="edm:GEmptyElementExtensibility" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:attribute name="Role" type="edm:TSimpleIdentifier" use="optional"/> <xs:attribute name="EntitySet" type="edm:TSimpleIdentifier" use="required"/> </xs:complexType> </xs:element> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:attribute name="Name" type="edm:TUndottedIdentifier" use="required"/> <xs:attribute name="Association" type="edm:TQualifiedName" use="required"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> </xs:element> </xs:choice> </xs:sequence> <xs:attribute name="Name" type="edm:TUndottedIdentifier" use="required"/> </xs:complexType> </xs:element> <xs:complexType name="TFunction"> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:element name="CommandText" type="edm:TCommandText" minOccurs="0" maxOccurs="1"/> <xs:element name="Parameter" type="edm:TParameter" minOccurs="0" maxOccurs="unbounded"/> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:attribute name="Name" type="edm:TUndottedIdentifier" use="required"/> <xs:attribute name="ReturnType" type="edm:TFunctionType" use="optional"/> <xs:attribute name="Aggregate" type="xs:boolean" use="optional"/> <xs:attribute name="BuiltIn" type="xs:boolean" use="optional"/> <xs:attribute name="StoreFunctionName" type="xs:string" use="optional"/> <xs:attribute name="NiladicFunction" type="xs:boolean" use="optional"/> <xs:attribute name="IsComposable" type="xs:boolean" use="optional" default="true"/> <xs:attribute name="ParameterTypeSemantics" type="edm:TParameterTypeSemantics" use="optional" default="AllowImplicitConversion"/> <xs:attribute name="Schema" type="edm:TSimpleIdentifier" use="optional"/> <xs:attribute ref="gen:Schema" use="optional"/> <xs:attribute ref="gen:Name" use="optional"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:complexType name="TParameter"> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:attribute name="Name" type="xs:string" use="required"/> <xs:attribute name="Type" type="edm:TFunctionType" use="required"/> <xs:attribute name="Mode" type="edm:TParameterMode" use="optional"/> <!-- Start Facets --> <xs:attribute name="MaxLength" type="edm:TMaxLengthFacet" use="optional"/> <xs:attribute name="Precision" type="edm:TPrecisionFacet" use="optional"/> <xs:attribute name="Scale" type="edm:TScaleFacet" use="optional"/> <!--End Facets --> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <!-- general (more or less) purpose simple types --> <xs:simpleType name="TCommandText"> <xs:restriction base="xs:string"> <xs:whiteSpace value="preserve"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="TQualifiedName"> <xs:restriction base="xs:string"/> </xs:simpleType> <xs:simpleType name="TUndottedIdentifier"> <xs:restriction base="xs:string"> <!-- no periods --> <xs:pattern value="[^.]{1,}"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="TSimpleIdentifier"> <xs:restriction base="xs:string"/> </xs:simpleType> <xs:simpleType name="TPropertyType"> <xs:union memberTypes="edm:TQualifiedName"> <xs:simpleType> <xs:restriction base="xs:token"> <!-- The below pattern represents the allowed identifiers in ECMA specification plus the '.' for namespace qualification --> <xs:pattern value="[\p{L}\p{Nl}][\p{L}\p{Nl}\p{Nd}\p{Mn}\p{Mc}\p{Pc}\p{Cf}]{0,}(\.[\p{L}\p{Nl}][\p{L}\p{Nl}\p{Nd}\p{Mn}\p{Mc}\p{Pc}\p{Cf}]{0,}){0,}"/> </xs:restriction> </xs:simpleType> </xs:union> </xs:simpleType> <xs:simpleType name="TAction"> <xs:restriction base="xs:token"> <xs:enumeration value="Cascade"/> <xs:enumeration value="Restrict"/> <xs:enumeration value="None"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="TMultiplicity"> <xs:restriction base="xs:token"> <xs:enumeration value="0..1"/> <xs:enumeration value="1"/> <xs:enumeration value="*"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="TStoreGeneratedPattern"> <xs:restriction base="xs:token"> <xs:enumeration value="None"/> <xs:enumeration value="Identity"/> <xs:enumeration value="Computed"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="TParameterMode"> <xs:restriction base="xs:token"> <xs:enumeration value="In"/> <xs:enumeration value="Out"/> <xs:enumeration value="InOut"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="TFunctionType"> <xs:union memberTypes="edm:TQualifiedName "> <xs:simpleType> <xs:restriction base="xs:token"> <xs:pattern value="Collection\([^ \t]{1,}(\.[^ \t]{1,}){0,}\)"/> </xs:restriction> </xs:simpleType> </xs:union> </xs:simpleType> <xs:simpleType name="TParameterTypeSemantics"> <xs:restriction base="xs:token"> <xs:enumeration value="ExactMatchOnly"/> <xs:enumeration value="AllowImplicitPromotion"/> <xs:enumeration value="AllowImplicitConversion"/> </xs:restriction> </xs:simpleType> </xs:schema> ]P <?xml version="1.0" encoding="utf-8"?> <xs:schema elementFormDefault="qualified" attributeFormDefault="unqualified" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:cg="http://schemas.microsoft.com/ado/2006/04/codegeneration" xmlns:edm="http://schemas.microsoft.com/ado/2007/05/edm" targetNamespace="http://schemas.microsoft.com/ado/2007/05/edm"> <xs:annotation> <xs:documentation xml:lang="en"> Common Data Model Schema Definition Language. Copyright (c) Microsoft Corp. All rights reserved. </xs:documentation> </xs:annotation> <xs:import namespace="http://schemas.microsoft.com/ado/2006/04/codegeneration" schemaLocation="System.Data.Resources.CodeGenerationSchema.xsd"/> <xs:element name="Schema" type="edm:TSchema"/> <xs:complexType name="TSchema"> <xs:sequence> <xs:group ref="edm:GSchemaBodyElements" minOccurs="0" maxOccurs="unbounded"/> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:attribute name="Namespace" type="edm:TNamespaceName" use="required"/> <xs:attribute name="Alias" type="edm:TSimpleIdentifier" use="optional"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:group name="GSchemaBodyElements"> <xs:choice> <xs:element name="Using" type="edm:TUsing" minOccurs="0" maxOccurs="unbounded"/> <xs:element name="Association" type="edm:TAssociation" minOccurs="0" maxOccurs="unbounded"/> <xs:element name="ComplexType" type="edm:TComplexType" minOccurs="0" maxOccurs="unbounded"/> <xs:element name="EntityType" type="edm:TEntityType" minOccurs="0" maxOccurs="unbounded"/> <xs:element ref="edm:EntityContainer" minOccurs="1" maxOccurs="1"/> </xs:choice> </xs:group> <!-- EDM SimpleType instances for use by EDM Instance documents--> <xs:simpleType name="EDMSimpleType"> <xs:restriction base="xs:string"> <xs:enumeration value="Binary"/> <xs:enumeration value="Boolean"/> <xs:enumeration value="Byte"/> <xs:enumeration value="DateTime"/> <xs:enumeration value="DateTimeOffset"/> <xs:enumeration value="Time"/> <xs:enumeration value="Decimal"/> <xs:enumeration value="Double"/> <xs:enumeration value="Single"/> <xs:enumeration value="Guid"/> <xs:enumeration value="Int16"/> <xs:enumeration value="Int32"/> <xs:enumeration value="Int64"/> <xs:enumeration value="String"/> <xs:enumeration value="SByte"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="TMax"> <xs:restriction base="xs:string"> <xs:enumeration value="Max"/> </xs:restriction> </xs:simpleType> <!-- Facets for Primitive types --> <xs:simpleType name="TMaxLengthFacet"> <xs:union memberTypes="edm:TMax xs:nonNegativeInteger "/> </xs:simpleType> <xs:simpleType name="TIsFixedLengthFacet"> <xs:restriction base="xs:boolean"/> </xs:simpleType> <xs:simpleType name="TPrecisionFacet"> <xs:restriction base="xs:nonNegativeInteger"/> </xs:simpleType> <xs:simpleType name="TScaleFacet"> <xs:restriction base="xs:nonNegativeInteger"/> </xs:simpleType> <xs:simpleType name="TIsUnicodeFacet"> <xs:restriction base="xs:boolean"/> </xs:simpleType> <xs:simpleType name="TCollationFacet"> <xs:restriction base="xs:string"/> </xs:simpleType> <!-- types at all levels --> <xs:complexType name="TDocumentation"> <xs:annotation> <xs:documentation>The Documentation element is used to provide documentation of comments on the contents of the XML file. It is valid under Schema, Type, Index and Relationship elements.</xs:documentation> </xs:annotation> <xs:sequence> <xs:element name="Summary" type="edm:TText" minOccurs="0" maxOccurs="1"/> <xs:element name="LongDescription" type="edm:TText" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:anyAttribute processContents="lax" namespace="##other"/> </xs:complexType> <xs:complexType name="TText" mixed="true"> <xs:sequence> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:anyAttribute processContents="lax" namespace="##other"/> </xs:complexType> <xs:complexType name="TXmlOrText" mixed="true"> <xs:annotation> <xs:documentation>This type allows pretty much any content</xs:documentation> </xs:annotation> <xs:sequence> <xs:any namespace="##any" processContents="skip" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:anyAttribute processContents="skip" namespace="##any"/> </xs:complexType> <!-- types of the top level elements --> <xs:complexType name="TUsing"> <xs:sequence> <xs:group ref="edm:GEmptyElementExtensibility" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:attribute name="Namespace" type="edm:TNamespaceName" use="required"/> <xs:attribute name="Alias" type="edm:TSimpleIdentifier" use="required"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:complexType name="TAssociation"> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:element name="End" type="edm:TAssociationEnd" minOccurs="2" maxOccurs="2"/> <xs:element name="ReferentialConstraint" type="edm:TConstraint" minOccurs="0" maxOccurs="1"/> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:attribute name="Name" type="edm:TSimpleIdentifier" use="required"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:complexType name="TComplexType"> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:element name="Property" type="edm:TComplexTypeProperty" minOccurs="0" maxOccurs="unbounded"/> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:attributeGroup ref="edm:TDerivableTypeAttributes"/> <xs:attribute ref="cg:TypeAccess" use="optional"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:complexType name="TConstraint"> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:element name="Principal" type="edm:TReferentialConstraintRoleElement" minOccurs="1" maxOccurs="1"/> <xs:element name="Dependent" type="edm:TReferentialConstraintRoleElement" minOccurs="1" maxOccurs="1"/> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:complexType name="TReferentialConstraintRoleElement"> <xs:sequence> <xs:element name="PropertyRef" type="edm:TPropertyRef" minOccurs="1" maxOccurs="unbounded"/> </xs:sequence> <xs:attribute name="Role" type="edm:TSimpleIdentifier" use="required"/> </xs:complexType> <xs:complexType name="TNavigationProperty"> <xs:sequence> <xs:group ref="edm:GEmptyElementExtensibility" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:attribute name="Name" type="edm:TSimpleIdentifier" use="required"/> <xs:attribute name="Relationship" type="edm:TQualifiedName" use="required"/> <xs:attribute name="ToRole" type="edm:TSimpleIdentifier" use="required"/> <xs:attribute name="FromRole" type="edm:TSimpleIdentifier" use="required"/> <xs:attribute ref="cg:GetterAccess" use="optional"/> <xs:attribute ref="cg:SetterAccess" use="optional"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:complexType name="TEntityType"> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:element name="Key" type="edm:TEntityKeyElement" minOccurs="0" maxOccurs="1"/> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="Property" type="edm:TEntityProperty" minOccurs="0" maxOccurs="unbounded"/> <xs:element name="NavigationProperty" type="edm:TNavigationProperty" minOccurs="0" maxOccurs="unbounded"/> </xs:choice> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:attributeGroup ref="edm:TDerivableTypeAttributes"/> <xs:attribute ref="cg:TypeAccess" use="optional"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:complexType name="TEntityKeyElement"> <xs:sequence> <xs:element name="PropertyRef" type="edm:TPropertyRef" minOccurs="1" maxOccurs="unbounded"/> </xs:sequence> </xs:complexType> <xs:complexType name="TPropertyRef"> <xs:attribute name="Name" type="edm:TSimpleIdentifier" use="required"/> </xs:complexType> <xs:group name="GEmptyElementExtensibility"> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> </xs:group> <!-- base types --> <xs:complexType name="TAssociationEnd"> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:group ref="edm:TOperations" minOccurs="0" maxOccurs="unbounded"/> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:attribute name="Type" type="edm:TQualifiedName" use="required"/> <xs:attribute name="Role" type="edm:TSimpleIdentifier" use="optional"/> <xs:attribute name="Multiplicity" type="edm:TMultiplicity" use="required"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:group name="TOperations"> <xs:choice> <xs:element name="OnDelete" type="edm:TOnAction" maxOccurs="1" minOccurs="0"/> </xs:choice> </xs:group> <xs:complexType name="TOnAction"> <xs:sequence> <xs:group ref="edm:GEmptyElementExtensibility" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:attribute name="Action" type="edm:TAction" use="required"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:complexType name="TEntityProperty"> <xs:sequence> <xs:group ref="edm:GEmptyElementExtensibility" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:attributeGroup ref="edm:TCommonPropertyAttributes"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:complexType name="TComplexTypeProperty"> <xs:sequence> <xs:group ref="edm:GEmptyElementExtensibility" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:attributeGroup ref="edm:TCommonPropertyAttributes"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:complexType name="TFunctionImportParameter"> <xs:sequence> <xs:group ref="edm:GEmptyElementExtensibility" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:attributeGroup ref="edm:TFunctionImportParameterAttributes"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:attributeGroup name="TCommonPropertyAttributes"> <xs:attribute name="Name" type="edm:TSimpleIdentifier" use="required"/> <xs:attribute name="Type" type="edm:TPropertyType" use="required"/> <xs:attribute name="Nullable" type="xs:boolean" default="true" use="optional"/> <xs:attribute name="DefaultValue" type="xs:string" use="optional"/> <xs:attribute name="CollectionKind" type="edm:TPropertyCollectionKind" use="optional"/> <!-- Start Facets --> <xs:attribute name="MaxLength" type="edm:TMaxLengthFacet" use="optional"/> <xs:attribute name="FixedLength" type="edm:TIsFixedLengthFacet" use="optional"/> <xs:attribute name="Precision" type="edm:TPrecisionFacet" use="optional"/> <xs:attribute name="Scale" type="edm:TScaleFacet" use="optional"/> <xs:attribute name="Unicode" type="edm:TIsUnicodeFacet" use="optional"/> <xs:attribute name="Collation" type="edm:TCollationFacet" use="optional"/> <!--End Facets --> <xs:attribute name="ConcurrencyMode" type="edm:TConcurrencyMode" use="optional"/> <xs:attribute ref="cg:SetterAccess" use="optional"/> <xs:attribute ref="cg:GetterAccess" use="optional"/> </xs:attributeGroup> <xs:attributeGroup name="TFunctionImportParameterAttributes"> <xs:attribute name="Name" type="edm:TSimpleIdentifier" use="required"/> <xs:attribute name="Type" type="edm:TPropertyType" use="required"/> <xs:attribute name="Mode" type="edm:TParameterMode" use="optional"/> <xs:attribute name="MaxLength" type="edm:TMaxLengthFacet" use="optional"/> <xs:attribute name="Precision" type="edm:TPrecisionFacet" use="optional"/> <xs:attribute name="Scale" type="edm:TScaleFacet" use="optional"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:attributeGroup> <xs:attributeGroup name="TFunctionImportAttributes"> <xs:attribute name="Name" type="edm:TSimpleIdentifier" use="required"/> <xs:attribute name="ReturnType" type="edm:TFunctionType" use="optional"/> <xs:attribute name="EntitySet" type="edm:TSimpleIdentifier" use="optional"/> <xs:attribute ref="cg:MethodAccess" use="optional"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:attributeGroup> <xs:attributeGroup name="TTypeAttributes"> <xs:attribute name="Name" type="edm:TSimpleIdentifier" use="required"/> </xs:attributeGroup> <xs:attributeGroup name="TDerivableTypeAttributes"> <xs:attributeGroup ref="edm:TTypeAttributes"/> <xs:attribute name="BaseType" type="edm:TQualifiedName" use="optional"/> <xs:attribute name="Abstract" type="xs:boolean" use="optional" default="false"/> </xs:attributeGroup> <xs:attributeGroup name="TEntitySetAttributes"> <xs:attribute name="Name" type="edm:TSimpleIdentifier" use="required"/> <xs:attribute name="EntityType" type="edm:TQualifiedName" use="required"/> <xs:attribute ref="cg:GetterAccess" use="optional"/> </xs:attributeGroup> <xs:element name="EntityContainer"> <xs:complexType> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="FunctionImport"> <xs:complexType> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:element name="Parameter" type="edm:TFunctionImportParameter" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:attributeGroup ref="edm:TFunctionImportAttributes"/> </xs:complexType> </xs:element> <xs:element name="EntitySet"> <xs:complexType> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:attributeGroup ref="edm:TEntitySetAttributes"/> <xs:anyAttribute processContents="lax" namespace="##other"/> </xs:complexType> </xs:element> <xs:element name="AssociationSet"> <xs:complexType> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:element name="End" minOccurs="0" maxOccurs="2"> <!-- 1. The number of Ends has to match with ones defined in AssociationType 2. Value for attribute Name should match the defined ones and EntitySet should be of the defined Entity Type in AssociationType --> <xs:complexType> <xs:sequence> <xs:group ref="edm:GEmptyElementExtensibility" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:attribute name="Role" type="edm:TSimpleIdentifier" use="optional"/> <xs:attribute name="EntitySet" type="edm:TSimpleIdentifier" use="required"/> </xs:complexType> </xs:element> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:attribute name="Name" type="edm:TSimpleIdentifier" use="required"/> <xs:attribute name="Association" type="edm:TQualifiedName" use="required"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> </xs:element> </xs:choice> </xs:sequence> <xs:attribute name="Name" type="edm:TSimpleIdentifier" use="required"/> <xs:attribute name="Extends" type="edm:TSimpleIdentifier" use="optional"/> </xs:complexType> </xs:element> <!-- general (more or less) purpose simple types --> <xs:simpleType name="TParameterMode"> <xs:restriction base="xs:token"> <xs:enumeration value="In"/> <xs:enumeration value="Out"/> <xs:enumeration value="InOut"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="TPropertyCollectionKind"> <xs:restriction base="xs:token"> <xs:enumeration value="None"/> <xs:enumeration value="List"/> <xs:enumeration value="Bag"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="TNamespaceName"> <xs:restriction base="edm:TQualifiedName"> <xs:maxLength value="512"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="TQualifiedName"> <xs:restriction base="xs:string"> <!-- The below pattern represents the allowed identifiers in ECMA specification plus the '.' for namespace qualification --> <xs:pattern value="[\p{L}\p{Nl}][\p{L}\p{Nl}\p{Nd}\p{Mn}\p{Mc}\p{Pc}\p{Cf}]{0,}(\.[\p{L}\p{Nl}][\p{L}\p{Nl}\p{Nd}\p{Mn}\p{Mc}\p{Pc}\p{Cf}]{0,}){0,}"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="TSimpleIdentifier"> <xs:restriction base="xs:string"> <xs:maxLength value="480"/> <!-- The below pattern represents the allowed identifiers in ECMA specification --> <xs:pattern value="[\p{L}\p{Nl}][\p{L}\p{Nl}\p{Nd}\p{Mn}\p{Mc}\p{Pc}\p{Cf}]{0,}"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="TPropertyType"> <xs:union memberTypes="edm:EDMSimpleType edm:TQualifiedName "> <xs:simpleType> <xs:restriction base="xs:token"> <!-- The below pattern represents the allowed identifiers in ECMA specification plus the '.' for namespace qualification --> <xs:pattern value="[\p{L}\p{Nl}][\p{L}\p{Nl}\p{Nd}\p{Mn}\p{Mc}\p{Pc}\p{Cf}]{0,}(\.[\p{L}\p{Nl}][\p{L}\p{Nl}\p{Nd}\p{Mn}\p{Mc}\p{Pc}\p{Cf}]{0,}){0,}"/> </xs:restriction> </xs:simpleType> </xs:union> </xs:simpleType> <xs:simpleType name="TFunctionType"> <xs:union memberTypes="edm:TQualifiedName "> <xs:simpleType> <xs:restriction base="xs:token"> <xs:pattern value="Collection\([^ \t]{1,}(\.[^ \t]{1,}){0,}\)"/> </xs:restriction> </xs:simpleType> </xs:union> </xs:simpleType> <xs:simpleType name="TAction"> <xs:restriction base="xs:token"> <xs:enumeration value="Cascade"/> <xs:enumeration value="None"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="TMultiplicity"> <xs:restriction base="xs:token"> <xs:enumeration value="0..1"/> <xs:enumeration value="1"/> <xs:enumeration value="*"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="TConcurrencyMode"> <xs:restriction base="xs:token"> <xs:enumeration value="None"/> <xs:enumeration value="Fixed"/> </xs:restriction> </xs:simpleType> </xs:schema> O <?xml version="1.0" encoding="utf-8"?> <xs:schema elementFormDefault="qualified" attributeFormDefault="unqualified" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:cg="http://schemas.microsoft.com/ado/2006/04/codegeneration" xmlns:edm="http://schemas.microsoft.com/ado/2006/04/edm" targetNamespace="http://schemas.microsoft.com/ado/2006/04/edm"> <xs:annotation> <xs:documentation xml:lang="en"> Common Data Model Schema Definition Language. Copyright (c) Microsoft Corp. All rights reserved. </xs:documentation> </xs:annotation> <xs:import namespace="http://schemas.microsoft.com/ado/2006/04/codegeneration" schemaLocation="System.Data.Resources.CodeGenerationSchema.xsd"/> <xs:element name="Schema" type="edm:TSchema"/> <xs:complexType name="TSchema"> <xs:sequence> <xs:group ref="edm:GSchemaBodyElements" minOccurs="0" maxOccurs="unbounded"/> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:attribute name="Namespace" type="edm:TNamespaceName" use="required"/> <xs:attribute name="Alias" type="edm:TSimpleIdentifier" use="optional"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:group name="GSchemaBodyElements"> <xs:choice> <xs:element name="Using" type="edm:TUsing" minOccurs="0" maxOccurs="unbounded"/> <xs:element name="Association" type="edm:TAssociation" minOccurs="0" maxOccurs="unbounded"/> <xs:element name="ComplexType" type="edm:TComplexType" minOccurs="0" maxOccurs="unbounded"/> <xs:element name="EntityType" type="edm:TEntityType" minOccurs="0" maxOccurs="unbounded"/> <xs:element ref="edm:EntityContainer" minOccurs="1" maxOccurs="1"/> </xs:choice> </xs:group> <!-- EDM SimpleType instances for use by EDM Instance documents--> <xs:simpleType name="EDMSimpleType"> <xs:restriction base="xs:string"> <xs:enumeration value="Binary"/> <xs:enumeration value="Boolean"/> <xs:enumeration value="Byte"/> <xs:enumeration value="DateTime"/> <xs:enumeration value="DateTimeOffset"/> <xs:enumeration value="Time"/> <xs:enumeration value="Decimal"/> <xs:enumeration value="Double"/> <xs:enumeration value="Single"/> <xs:enumeration value="Guid"/> <xs:enumeration value="Int16"/> <xs:enumeration value="Int32"/> <xs:enumeration value="Int64"/> <xs:enumeration value="String"/> <xs:enumeration value="SByte"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="TMax"> <xs:restriction base="xs:string"> <xs:enumeration value="Max"/> </xs:restriction> </xs:simpleType> <!-- Facets for Primitive types --> <xs:simpleType name="TMaxLengthFacet"> <xs:union memberTypes="edm:TMax xs:nonNegativeInteger "/> </xs:simpleType> <xs:simpleType name="TIsFixedLengthFacet"> <xs:restriction base="xs:boolean"/> </xs:simpleType> <xs:simpleType name="TPrecisionFacet"> <xs:restriction base="xs:nonNegativeInteger"/> </xs:simpleType> <xs:simpleType name="TScaleFacet"> <xs:restriction base="xs:nonNegativeInteger"/> </xs:simpleType> <xs:simpleType name="TIsUnicodeFacet"> <xs:restriction base="xs:boolean"/> </xs:simpleType> <xs:simpleType name="TCollationFacet"> <xs:restriction base="xs:string"/> </xs:simpleType> <!-- types at all levels --> <xs:complexType name="TDocumentation"> <xs:annotation> <xs:documentation>The Documentation element is used to provide documentation of comments on the contents of the XML file. It is valid under Schema, Type, Index and Relationship elements.</xs:documentation> </xs:annotation> <xs:sequence> <xs:element name="Summary" type="edm:TText" minOccurs="0" maxOccurs="1"/> <xs:element name="LongDescription" type="edm:TText" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:anyAttribute processContents="lax" namespace="##other"/> </xs:complexType> <xs:complexType name="TText" mixed="true"> <xs:sequence> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:anyAttribute processContents="lax" namespace="##other"/> </xs:complexType> <xs:complexType name="TXmlOrText" mixed="true"> <xs:annotation> <xs:documentation>This type allows pretty much any content</xs:documentation> </xs:annotation> <xs:sequence> <xs:any namespace="##any" processContents="skip" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:anyAttribute processContents="skip" namespace="##any"/> </xs:complexType> <!-- types of the top level elements --> <xs:complexType name="TUsing"> <xs:sequence> <xs:group ref="edm:GEmptyElementExtensibility" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:attribute name="Namespace" type="edm:TNamespaceName" use="required"/> <xs:attribute name="Alias" type="edm:TSimpleIdentifier" use="required"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:complexType name="TAssociation"> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:element name="End" type="edm:TAssociationEnd" minOccurs="2" maxOccurs="2"/> <xs:element name="ReferentialConstraint" type="edm:TConstraint" minOccurs="0" maxOccurs="1"/> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:attribute name="Name" type="edm:TSimpleIdentifier" use="required"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:complexType name="TComplexType"> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:element name="Property" type="edm:TComplexTypeProperty" minOccurs="0" maxOccurs="unbounded"/> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:attributeGroup ref="edm:TTypeAttributes"/> <xs:attribute ref="cg:TypeAccess" use="optional"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:complexType name="TConstraint"> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:element name="Principal" type="edm:TReferentialConstraintRoleElement" minOccurs="1" maxOccurs="1"/> <xs:element name="Dependent" type="edm:TReferentialConstraintRoleElement" minOccurs="1" maxOccurs="1"/> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:complexType name="TReferentialConstraintRoleElement"> <xs:sequence> <xs:element name="PropertyRef" type="edm:TPropertyRef" minOccurs="1" maxOccurs="unbounded"/> </xs:sequence> <xs:attribute name="Role" type="edm:TSimpleIdentifier" use="required"/> </xs:complexType> <xs:complexType name="TNavigationProperty"> <xs:sequence> <xs:group ref="edm:GEmptyElementExtensibility" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:attribute name="Name" type="edm:TSimpleIdentifier" use="required"/> <xs:attribute name="Relationship" type="edm:TQualifiedName" use="required"/> <xs:attribute name="ToRole" type="edm:TSimpleIdentifier" use="required"/> <xs:attribute name="FromRole" type="edm:TSimpleIdentifier" use="required"/> <xs:attribute ref="cg:GetterAccess" use="optional"/> <xs:attribute ref="cg:SetterAccess" use="optional"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:complexType name="TEntityType"> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:element name="Key" type="edm:TEntityKeyElement" minOccurs="0" maxOccurs="1"/> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="Property" type="edm:TEntityProperty" minOccurs="0" maxOccurs="unbounded"/> <xs:element name="NavigationProperty" type="edm:TNavigationProperty" minOccurs="0" maxOccurs="unbounded"/> </xs:choice> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:attributeGroup ref="edm:TDerivableTypeAttributes"/> <xs:attribute ref="cg:TypeAccess" use="optional"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:complexType name="TEntityKeyElement"> <xs:sequence> <xs:element name="PropertyRef" type="edm:TPropertyRef" minOccurs="1" maxOccurs="unbounded"/> </xs:sequence> </xs:complexType> <xs:complexType name="TPropertyRef"> <xs:attribute name="Name" type="edm:TSimpleIdentifier" use="required"/> </xs:complexType> <xs:group name="GEmptyElementExtensibility"> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> </xs:group> <!-- base types --> <xs:complexType name="TAssociationEnd"> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:group ref="edm:TOperations" minOccurs="0" maxOccurs="unbounded"/> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:attribute name="Type" type="edm:TQualifiedName" use="required"/> <xs:attribute name="Role" type="edm:TSimpleIdentifier" use="optional"/> <xs:attribute name="Multiplicity" type="edm:TMultiplicity" use="required"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:group name="TOperations"> <xs:choice> <xs:element name="OnDelete" type="edm:TOnAction" maxOccurs="1" minOccurs="0"/> </xs:choice> </xs:group> <xs:complexType name="TOnAction"> <xs:sequence> <xs:group ref="edm:GEmptyElementExtensibility" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:attribute name="Action" type="edm:TAction" use="required"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:complexType name="TEntityProperty"> <xs:sequence> <xs:group ref="edm:GEmptyElementExtensibility" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:attributeGroup ref="edm:TCommonPropertyAttributes"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:complexType name="TComplexTypeProperty"> <xs:sequence> <xs:group ref="edm:GEmptyElementExtensibility" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:attributeGroup ref="edm:TCommonPropertyAttributes"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:complexType name="TFunctionImportParameter"> <xs:sequence> <xs:group ref="edm:GEmptyElementExtensibility" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:attributeGroup ref="edm:TFunctionImportParameterAttributes"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> <xs:attributeGroup name="TCommonPropertyAttributes"> <xs:attribute name="Name" type="edm:TSimpleIdentifier" use="required"/> <xs:attribute name="Type" type="edm:TPropertyType" use="required"/> <xs:attribute name="Nullable" type="xs:boolean" default="true" use="optional"/> <xs:attribute name="DefaultValue" type="xs:string" use="optional"/> <!-- Start Facets --> <xs:attribute name="MaxLength" type="edm:TMaxLengthFacet" use="optional"/> <xs:attribute name="FixedLength" type="edm:TIsFixedLengthFacet" use="optional"/> <xs:attribute name="Precision" type="edm:TPrecisionFacet" use="optional"/> <xs:attribute name="Scale" type="edm:TScaleFacet" use="optional"/> <xs:attribute name="Unicode" type="edm:TIsUnicodeFacet" use="optional"/> <xs:attribute name="Collation" type="edm:TCollationFacet" use="optional"/> <!--End Facets --> <xs:attribute name="ConcurrencyMode" type="edm:TConcurrencyMode" use="optional"/> <xs:attribute ref="cg:SetterAccess" use="optional"/> <xs:attribute ref="cg:GetterAccess" use="optional"/> </xs:attributeGroup> <xs:attributeGroup name="TFunctionImportParameterAttributes"> <xs:attribute name="Name" type="edm:TSimpleIdentifier" use="required"/> <xs:attribute name="Type" type="edm:TPropertyType" use="required"/> <xs:attribute name="Mode" type="edm:TParameterMode" use="optional"/> <xs:attribute name="MaxLength" type="edm:TMaxLengthFacet" use="optional"/> <xs:attribute name="Precision" type="edm:TPrecisionFacet" use="optional"/> <xs:attribute name="Scale" type="edm:TScaleFacet" use="optional"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:attributeGroup> <xs:attributeGroup name="TFunctionImportAttributes"> <xs:attribute name="Name" type="edm:TSimpleIdentifier" use="required"/> <xs:attribute name="ReturnType" type="edm:TFunctionType" use="optional"/> <xs:attribute name="EntitySet" type="edm:TSimpleIdentifier" use="optional"/> <xs:attribute ref="cg:MethodAccess" use="optional"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:attributeGroup> <xs:attributeGroup name="TTypeAttributes"> <xs:attribute name="Name" type="edm:TSimpleIdentifier" use="required"/> </xs:attributeGroup> <xs:attributeGroup name="TDerivableTypeAttributes"> <xs:attributeGroup ref="edm:TTypeAttributes"/> <xs:attribute name="BaseType" type="edm:TQualifiedName" use="optional"/> <xs:attribute name="Abstract" type="xs:boolean" use="optional" default="false"/> </xs:attributeGroup> <xs:attributeGroup name="TEntitySetAttributes"> <xs:attribute name="Name" type="edm:TSimpleIdentifier" use="required"/> <xs:attribute name="EntityType" type="edm:TQualifiedName" use="required"/> <xs:attribute ref="cg:GetterAccess" use="optional"/> </xs:attributeGroup> <xs:element name="EntityContainer"> <xs:complexType> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="FunctionImport"> <xs:complexType> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:element name="Parameter" type="edm:TFunctionImportParameter" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:attributeGroup ref="edm:TFunctionImportAttributes"/> </xs:complexType> </xs:element> <xs:element name="EntitySet"> <xs:complexType> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:attributeGroup ref="edm:TEntitySetAttributes"/> <xs:anyAttribute processContents="lax" namespace="##other"/> </xs:complexType> </xs:element> <xs:element name="AssociationSet"> <xs:complexType> <xs:sequence> <xs:element name="Documentation" type="edm:TDocumentation" minOccurs="0" maxOccurs="1"/> <xs:element name="End" minOccurs="0" maxOccurs="2"> <!-- 1. The number of Ends has to match with ones defined in AssociationType 2. Value for attribute Name should match the defined ones and EntitySet should be of the defined Entity Type in AssociationType --> <xs:complexType> <xs:sequence> <xs:group ref="edm:GEmptyElementExtensibility" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:attribute name="Role" type="edm:TSimpleIdentifier" use="optional"/> <xs:attribute name="EntitySet" type="edm:TSimpleIdentifier" use="required"/> </xs:complexType> </xs:element> <xs:any namespace="##other" processContents="lax" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:attribute name="Name" type="edm:TSimpleIdentifier" use="required"/> <xs:attribute name="Association" type="edm:TQualifiedName" use="required"/> <xs:anyAttribute namespace="##other" processContents="lax"/> </xs:complexType> </xs:element> </xs:choice> </xs:sequence> <xs:attribute name="Name" type="edm:TSimpleIdentifier" use="required"/> <xs:attribute name="Extends" type="edm:TSimpleIdentifier" use="optional"/> </xs:complexType> </xs:element> <!-- general (more or less) purpose simple types --> <xs:simpleType name="TParameterMode"> <xs:restriction base="xs:token"> <xs:enumeration value="In"/> <xs:enumeration value="Out"/> <xs:enumeration value="InOut"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="TNamespaceName"> <xs:restriction base="edm:TQualifiedName"> <xs:maxLength value="512"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="TQualifiedName"> <xs:restriction base="xs:string"> <!-- The below pattern represents the allowed identifiers in ECMA specification plus the '.' for namespace qualification --> <xs:pattern value="[\p{L}\p{Nl}][\p{L}\p{Nl}\p{Nd}\p{Mn}\p{Mc}\p{Pc}\p{Cf}]{0,}(\.[\p{L}\p{Nl}][\p{L}\p{Nl}\p{Nd}\p{Mn}\p{Mc}\p{Pc}\p{Cf}]{0,}){0,}"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="TSimpleIdentifier"> <xs:restriction base="xs:string"> <xs:maxLength value="480"/> <!-- The below pattern represents the allowed identifiers in ECMA specification --> <xs:pattern value="[\p{L}\p{Nl}][\p{L}\p{Nl}\p{Nd}\p{Mn}\p{Mc}\p{Pc}\p{Cf}]{0,}"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="TPropertyType"> <xs:union memberTypes="edm:EDMSimpleType edm:TQualifiedName "> <xs:simpleType> <xs:restriction base="xs:token"> <!-- The below pattern represents the allowed identifiers in ECMA specification plus the '.' for namespace qualification --> <xs:pattern value="[\p{L}\p{Nl}][\p{L}\p{Nl}\p{Nd}\p{Mn}\p{Mc}\p{Pc}\p{Cf}]{0,}(\.[\p{L}\p{Nl}][\p{L}\p{Nl}\p{Nd}\p{Mn}\p{Mc}\p{Pc}\p{Cf}]{0,}){0,}"/> </xs:restriction> </xs:simpleType> </xs:union> </xs:simpleType> <xs:simpleType name="TFunctionType"> <xs:union memberTypes="edm:TQualifiedName "> <xs:simpleType> <xs:restriction base="xs:token"> <xs:pattern value="Collection\([^ \t]{1,}(\.[^ \t]{1,}){0,}\)"/> </xs:restriction> </xs:simpleType> </xs:union> </xs:simpleType> <xs:simpleType name="TAction"> <xs:restriction base="xs:token"> <xs:enumeration value="Cascade"/> <xs:enumeration value="None"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="TMultiplicity"> <xs:restriction base="xs:token"> <xs:enumeration value="0..1"/> <xs:enumeration value="1"/> <xs:enumeration value="*"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="TConcurrencyMode"> <xs:restriction base="xs:token"> <xs:enumeration value="None"/> <xs:enumeration value="Fixed"/> </xs:restriction> </xs:simpleType> </xs:schema> U <?xml version="1.0" encoding="utf-8"?> <xs:schema id="CodeGenerationSchema" targetNamespace="http://schemas.microsoft.com/ado/2006/04/codegeneration" elementFormDefault="unqualified" xmlns="http://schemas.microsoft.com/ado/2006/04/codegeneration" xmlns:xs="http://www.w3.org/2001/XMLSchema"> <xs:attribute name="SetterAccess" type="TAccess"/> <xs:attribute name="GetterAccess" type="TAccess"/> <xs:attribute name="TypeAccess" type="TPublicOrInternalAccess"/> <xs:attribute name="MethodAccess" type="TAccess"/> <xs:simpleType name="TAccess"> <xs:restriction base="xs:string"> <xs:enumeration value="Public"/> <xs:enumeration value="Internal"/> <xs:enumeration value="Protected"/> <xs:enumeration value="Private"/> </xs:restriction> </xs:simpleType> <xs:simpleType name="TPublicOrInternalAccess"> <xs:restriction base="TAccess"> <xs:enumeration value="Public"/> <xs:enumeration value="Internal"/> </xs:restriction> </xs:simpleType> </xs:schema> @B <?xml version="1.0"?> <!-- XSD for CS( CDM <-> Storage ) space mapping. --> <xs:schema xmlns:tns="urn:schemas-microsoft-com:windows:storage:mapping:CS" attributeFormDefault="unqualified" elementFormDefault="qualified" targetNamespace="urn:schemas-microsoft-com:windows:storage:mapping:CS" xmlns:csmsl="urn:schemas-microsoft-com:windows:storage:mapping:CS" xmlns:xs="http://www.w3.org/2001/XMLSchema"> <xs:annotation> <xs:documentation xml:lang="en"> Common Data Model Schema Definition Language. Copyright (c) Microsoft Corp. All rights reserved. </xs:documentation> </xs:annotation> <!-- Root Level element for CS Mapping --> <xs:element name="Mapping" type="csmsl:TMapping"/> <!-- Type of Root level mapping elements--> <xs:complexType name="TMapping"> <!-- Top level Mapping element can have Alias elements followed by EntityContainer Mapping element--> <xs:sequence> <xs:element minOccurs="0" maxOccurs="unbounded" name="Alias" type="csmsl:TAlias"/> <!-- For now we will allow only one EntityContainerMapping to be mapped per MSL File.--> <xs:element name="EntityContainerMapping" type="csmsl:TEntityContainerMapping"/> </xs:sequence> <!-- Space represents the space that the mapping occurs. For CS Mapping it always has to be "C-S"--> <xs:attribute name="Space" type="csmsl:TSpace" use="required" fixed="C-S"/> </xs:complexType> <!-- Type for QueryView Element --> <xs:complexType name="TQueryView"> <xs:simpleContent> <xs:extension base="xs:string"> <xs:attribute name="TypeName" type="xs:string" use="optional"/> </xs:extension> </xs:simpleContent> </xs:complexType> <!-- Type for Alias Element--> <xs:complexType name="TAlias"> <xs:attribute name="Key" type="csmsl:TSimpleIdentifier" use="required"/> <xs:attribute name="Value" type="xs:string" use="required"/> </xs:complexType> <!-- Type for EntityContainerMapping Element--> <xs:complexType name="TEntityContainerMapping"> <xs:sequence> <xs:choice maxOccurs="unbounded"> <xs:element minOccurs="0" name="EntitySetMapping" type="csmsl:TEntitySetMapping"/> <xs:element minOccurs="0" name="AssociationSetMapping" type="csmsl:TAssociationSetMapping"/> <xs:element minOccurs="0" name="FunctionImportMapping" type="csmsl:TFunctionImportMapping"/> </xs:choice> </xs:sequence> <xs:attribute name="CdmEntityContainer" type="csmsl:TSimpleIdentifier" use="required"/> <xs:attribute name="StorageEntityContainer" type="xs:string" use="required"/> </xs:complexType> <!-- Type for FunctionImport Mapping element --> <xs:complexType name="TFunctionImportMapping"> <xs:sequence> <xs:element minOccurs="0" maxOccurs="1" name="ResultMapping" type="csmsl:TFunctionImportMappingResultMapping"/> </xs:sequence> <xs:attribute name="FunctionName" type="xs:string" use="required"/> <xs:attribute name="FunctionImportName" type="csmsl:TSimpleIdentifier" use="required"/> </xs:complexType> <!-- Type for FunctionImport/ResultMapping element --> <xs:complexType name="TFunctionImportMappingResultMapping"> <xs:sequence> <xs:element minOccurs="0" maxOccurs="unbounded" name="EntityTypeMapping" type="csmsl:TFunctionImportEntityTypeMapping"/> </xs:sequence> </xs:complexType> <!-- Type for EntitySet Mapping element--> <xs:complexType name="TEntitySetMapping"> <xs:choice> <xs:choice> <xs:sequence> <xs:element name="QueryView" type="csmsl:TQueryView" minOccurs="0" maxOccurs="unbounded"/> <xs:element name="EntityTypeMapping" type="csmsl:TEntityTypeMapping" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> <xs:sequence> <xs:element name="MappingFragment" type="csmsl:TMappingFragment" minOccurs="0" maxOccurs="unbounded"/> </xs:sequence> </xs:choice> <xs:group ref="csmsl:TPropertyGroup"/> </xs:choice> <xs:attribute name="Name" type="csmsl:TSimpleIdentifier" use="required"/> <xs:attribute name="TypeName" type="xs:string" use="optional"/> <xs:attribute name="StoreEntitySet" type="xs:string" use="optional"/> </xs:complexType> <!-- Type for AssociationSetMapping element--> <xs:complexType name="TAssociationSetMapping"> <xs:sequence> <xs:element name="QueryView" type="xs:string" minOccurs="0" maxOccurs="1"/> <xs:element name="EndProperty" type="csmsl:TEndProperty" minOccurs="0" maxOccurs="2"/> <xs:element name="Condition" type="csmsl:TCondition" minOccurs="0" maxOccurs="unbounded"/> <xs:element name="ModificationFunctionMapping" type="csmsl:TAssociationSetModificationFunctionMapping" minOccurs="0" maxOccurs="1"/> </xs:sequence> <xs:attribute name="Name" type="csmsl:TSimpleIdentifier" use="required"/> <xs:attribute name="TypeName" type="csmsl:TQualifiedName" use="optional"/> <xs:attribute name="StoreEntitySet" type="xs:string" use="optional"/> </xs:complexType> <!-- Type for EntityTypeMapping element--> <xs:complexType name="TEntityTypeMapping"> <xs:sequence> <xs:element minOccurs="0" maxOccurs="unbounded" name="MappingFragment" type="csmsl:TMappingFragment"/> <xs:element minOccurs="0" maxOccurs="1" name="ModificationFunctionMapping" type="csmsl:TEntityTypeModificationFunctionMapping"/> </xs:sequence> <xs:attribute name="TypeName" type="xs:string" use="required"/> </xs:complexType> <!-- Type for FunctionImport EntityTypeMapping element--> <xs:complexType name="TFunctionImportEntityTypeMapping"> <xs:sequence> <xs:element minOccurs="0" maxOccurs="unbounded" name="Condition" type="csmsl:TFunctionImportCondition"/> </xs:sequence> <xs:attribute name="TypeName" type="xs:string" use="required"/> </xs:complexType> <!-- Type for MappingFragment Element--> <xs:complexType name="TMappingFragment"> <xs:group ref="csmsl:TPropertyGroup" minOccurs="1" maxOccurs="1"/> <xs:attribute name="StoreEntitySet" type="xs:string" use="required"/> </xs:complexType> <!-- Type for EntityTypeMapping/ModificationFunctionMapping element --> <xs:complexType name="TEntityTypeModificationFunctionMapping"> <xs:all> <xs:element minOccurs="1" maxOccurs="1" name="DeleteFunction" type="csmsl:TEntityTypeModificationFunction"/> <xs:element minOccurs="1" maxOccurs="1" name="InsertFunction" type="csmsl:TEntityTypeModificationFunctionWithResult"/> <xs:element minOccurs="1" maxOccurs="1" name="UpdateFunction" type="csmsl:TEntityTypeModificationFunctionWithResult"/> </xs:all> </xs:complexType> <!-- Type for AssociationSetMapping/ModificationFunctionMapping element --> <xs:complexType name="TAssociationSetModificationFunctionMapping"> <xs:all> <xs:element minOccurs="1" maxOccurs="1" name="DeleteFunction" type="csmsl:TAssociationSetModificationFunction"/> <xs:element minOccurs="1" maxOccurs="1" name="InsertFunction" type="csmsl:TAssociationSetModificationFunction"/> </xs:all> </xs:complexType> <!-- Type for entity type DeleteFunction --> <xs:complexType name="TEntityTypeModificationFunction"> <xs:group ref="csmsl:TEntityTypeFunctionMappingPropertyGroup" minOccurs="1" maxOccurs="1"/> <xs:attribute name="FunctionName" type="xs:string" use="required"/> <xs:attribute name="RowsAffectedParameter" type="xs:string" use="optional"/> </xs:complexType> <!-- Extensions to modification function for entity type InsertFunction and UpdateFunction --> <xs:complexType name="TEntityTypeModificationFunctionWithResult"> <xs:complexContent> <xs:extension base="csmsl:TEntityTypeModificationFunction"> <xs:group ref="csmsl:TResultBindingGroup" minOccurs="1" maxOccurs="1"/> </xs:extension> </xs:complexContent> </xs:complexType> <!-- Type for association set DeleteFunction and InsertFunction --> <xs:complexType name="TAssociationSetModificationFunction"> <xs:group ref="csmsl:TAssociationSetFunctionMappingPropertyGroup" minOccurs="1" maxOccurs="1"/> <xs:attribute name="FunctionName" type="xs:string" use="required"/> <xs:attribute name="RowsAffectedParameter" type="xs:string" use="optional"/> </xs:complexType> <!-- Grouping for entity type function mappings --> <xs:group name="TEntityTypeFunctionMappingPropertyGroup"> <xs:sequence> <xs:choice maxOccurs="unbounded"> <xs:element minOccurs="0" name="ScalarProperty" type="csmsl:TFunctionMappingScalarProperty"/> <xs:element minOccurs="0" name="AssociationEnd" type="csmsl:TFunctionMappingAssociationEnd"/> <xs:element minOccurs="0" name="ComplexProperty" type="csmsl:TFunctionMappingComplexProperty"/> </xs:choice> </xs:sequence> </xs:group> <!-- Grouping for entity type function mappings --> <xs:group name="TAssociationSetFunctionMappingPropertyGroup"> <xs:sequence> <xs:choice maxOccurs="unbounded"> <xs:element minOccurs="1" name="EndProperty" type="csmsl:TFunctionMappingEndProperty"/> </xs:choice> </xs:sequence> </xs:group> <!-- Type for function mapping end property --> <xs:complexType name="TFunctionMappingEndProperty"> <xs:group ref="csmsl:TFunctionMappingAssociationEndPropertyGroup" minOccurs="1" maxOccurs="1"/> <xs:attribute name="Name" type="csmsl:TSimpleIdentifier" use="required"/> </xs:complexType> <!-- Type for function mapping scalar property --> <xs:complexType name="TFunctionMappingScalarProperty"> <xs:attribute name="ParameterName" type="xs:string" use="required"/> <xs:attribute name="Name" type="csmsl:TSimpleIdentifier" use="required"/> <xs:attribute name="Version" type="csmsl:TVersion" use="optional"/> </xs:complexType> <!-- Type for function mapping result binding --> <xs:complexType name="TResultBinding"> <xs:attribute name="ColumnName" type="xs:string" use="required"/> <xs:attribute name="Name" type="csmsl:TSimpleIdentifier" use="required"/> </xs:complexType> <!-- Type for function mapping association end --> <xs:complexType name="TFunctionMappingAssociationEnd"> <xs:group ref="csmsl:TFunctionMappingAssociationEndPropertyGroup" minOccurs="1" maxOccurs="1"/> <xs:attribute name="AssociationSet" type="csmsl:TSimpleIdentifier" use="required"/> <xs:attribute name="From" type="csmsl:TSimpleIdentifier" use="required"/> <xs:attribute name="To" type="csmsl:TSimpleIdentifier" use="required"/> </xs:complexType> <!-- Grouping for property bindings in function mapping end property --> <xs:group name="TFunctionMappingAssociationEndPropertyGroup"> <xs:sequence> <xs:element minOccurs="0" maxOccurs="unbounded" name="ScalarProperty" type="csmsl:TFunctionMappingScalarProperty"/> </xs:sequence> </xs:group> <!-- Type for function mapping complex property --> <xs:complexType name="TFunctionMappingComplexProperty"> <xs:group ref="csmsl:TFunctionMappingComplexPropertyPropertyGroup" minOccurs="1" maxOccurs="1"/> <xs:attribute name="Name" type="csmsl:TSimpleIdentifier" use="required"/> <xs:attribute name="TypeName" type="xs:string" use="required"/> </xs:complexType> <!-- Grouping for result bindings in function mappings --> <xs:group name="TResultBindingGroup"> <xs:sequence> <xs:element minOccurs="0" maxOccurs="unbounded" name="ResultBinding" type="csmsl:TResultBinding"/> </xs:sequence> </xs:group> <!-- Grouping for property bindings in function mapping association end --> <xs:group name="TFunctionMappingComplexPropertyPropertyGroup"> <xs:sequence> <xs:choice maxOccurs="unbounded"> <xs:element minOccurs="0" name="ScalarProperty" type="csmsl:TFunctionMappingScalarProperty"/> <xs:element minOccurs="0" name="ComplexProperty" type="csmsl:TFunctionMappingComplexProperty"/> </xs:choice> </xs:sequence> </xs:group> <!-- Grouping these elements so that they can be reused These elements represent the property group that can either directly reside unser EntitySet, EntityType or MappingFragment--> <xs:group name="TPropertyGroup"> <xs:sequence> <xs:choice maxOccurs="unbounded"> <xs:element minOccurs="0" name="ComplexProperty" type="csmsl:TComplexProperty"/> <xs:element minOccurs="0" name="ScalarProperty" type="csmsl:TScalarProperty"/> <xs:element minOccurs="0" name="Condition" type="csmsl:TCondition"/> </xs:choice> </xs:sequence> </xs:group> <!-- Type for Condition Element--> <xs:complexType name="TCondition"> <xs:attribute name="Value" type="xs:string" use="optional"/> <xs:attribute name="Name" type="csmsl:TSimpleIdentifier" use="optional"/> <xs:attribute name="ColumnName" type="xs:string" use="optional"/> <xs:attribute name="IsNull" type="xs:boolean" use="optional"/> </xs:complexType> <!-- Type for FunctionImport Condition element--> <xs:complexType name="TFunctionImportCondition"> <xs:attribute name="Value" type="xs:string" use="optional"/> <xs:attribute name="ColumnName" type="xs:string" use="required"/> <xs:attribute name="IsNull" type="xs:boolean" use="optional"/> </xs:complexType> <!-- Type for End Property Elements in Association Maps --> <xs:complexType name="TEndProperty"> <xs:sequence> <xs:element maxOccurs="unbounded" name="ScalarProperty" type="csmsl:TScalarProperty"/> </xs:sequence> <xs:attribute name="Name" type="csmsl:TSimpleIdentifier" use="required"/> </xs:complexType> <!-- Type for Complex Property Map elements--> <xs:complexType name="TComplexProperty"> <xs:sequence> <xs:choice maxOccurs="unbounded"> <xs:element name="ScalarProperty" type="csmsl:TScalarProperty"/> <xs:element name="ComplexProperty" type="csmsl:TComplexProperty"/> <xs:element name="ComplexTypeMapping" type="csmsl:TComplexTypeMapping"/> <xs:element name="Condition" type="csmsl:TCondition"/> </xs:choice> </xs:sequence> <xs:attribute name="Name" type="csmsl:TSimpleIdentifier" use="required"/> <xs:attribute name="TypeName" type="xs:string" use="optional"/> <xs:attribute name="IsPartial" type="xs:boolean" use="optional"/> </xs:complexType> <!-- Type for Complex Type mapping element--> <xs:complexType name="TComplexTypeMapping"> <xs:sequence> <xs:choice maxOccurs="unbounded"> <xs:element name="ScalarProperty" type="csmsl:TScalarProperty"/> <xs:element name="ComplexProperty" type="csmsl:TComplexProperty"/> <xs:element name="Condition" type="csmsl:TCondition"/> </xs:choice> </xs:sequence> <xs:attribute name="TypeName" type="xs:string" use="optional"/> <xs:attribute name="IsPartial" type="xs:boolean" use="optional"/> </xs:complexType> <!-- Type for ScalarProperty Element--> <xs:complexType name="TScalarProperty"> <xs:attribute name="Name" type="csmsl:TSimpleIdentifier" use="required"/> <xs:attribute name="ColumnName" type="xs:string" use="required"/> </xs:complexType> <!--Definition for SimpleIdentifier This is the same definition that is being used in the CSDL XSD --> <xs:simpleType name="TSimpleIdentifier"> <xs:restriction base="xs:token"> <!-- The below pattern represents the allowed identifiers in ECMA specification --> <xs:pattern value="[\p{L}\p{Nl}][\p{L}\p{Nl}\p{Nd}\p{Mn}\p{Mc}\p{Pc}\p{Cf}]{0,}"/> </xs:restriction> </xs:simpleType> <!--Definition for QualifiedName. QualifiedName is SimpleIdentifiers with '.' allowed. This is the same definition that is being used in the CSDL XSD --> <xs:simpleType name="TQualifiedName"> <xs:restriction base="xs:token"> <!-- The below pattern represents the allowed identifiers in ECMA specification plus the '.' for namespace qualification --> <xs:pattern value="[\p{L}\p{Nl}][\p{L}\p{Nl}\p{Nd}\p{Mn}\p{Mc}\p{Pc}\p{Cf}]{0,}(\.[\p{L}\p{Nl}][\p{L}\p{Nl}\p{Nd}\p{Mn}\p{Mc}\p{Pc}\p{Cf}]{0,}){0,}"/> </xs:restriction> </xs:simpleType> <!--Definition for Version, which can 'original' or 'current' as its value--> <xs:simpleType name="TVersion"> <xs:restriction base="xs:token"> <xs:enumeration value="Original"/> <xs:enumeration value="Current"/> </xs:restriction> </xs:simpleType> <!-- Type fopr Space or Type Attribute --> <xs:simpleType name="TSpace"> <xs:restriction base="xs:token"> <xs:enumeration value="C-S"/> </xs:restriction> </xs:simpleType> </xs:schema> >° ÎÊï¾ ? lSystem.Resources.ResourceReader, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089#System.Resources.RuntimeResourceSet PADPADPîî?Æ.?¾>?¤`?')???¸¥?¡C¦?D³ ??8?®ÀV??Ha?u_m?é ??|FÕ??ô?¸??e£?Qè7?¥?I?ª$R?9V??Î[?#+??½??âªÁ?+·ø?^?"?X¨ö?U±]?2??} ¥?)¸·?m\Ð?fó?\õ8?gf?yÔh?¦ ??úà??b¡Â?3èN?óõ??ÙB??\Þ©?ýµC?õöI?kZO?×Û[?S½??)Ý?Fôî?tÂ7??)D?»"¼?e´þ?Ëï'??_Y?y??½hµ?;-?ÓG2?<5?¸òc?´Q??ê??©í ?qW?ee??³??kª?Q"»?¯"Æ?Y ô?? ?V@h?N1Æ?ÄÈ×? ò?G ?ðÌL?+C©???Ú?îø?&??v1??u??dúò?µ?Gb}?????P.??Û"Ü?IB?¾»l?Ó??ú??Câ??DI¢?GUã?vÂõ?qÏ?ûð??j%??b?¶?U[Ì?ÜnÎ?_Þò?å?sß?å+;?¶g¼?(é? Ìñ?Tz:??+u?<,ò?Gxù? .?{_? 2g?¶"i?×cm?°/·? -0?³æ5??ý??!Ò??LSê?NÇ ?Û???$Y\?cÈ??b?7K?? ·£?e¼?+Å? ¥?µØ-?å9?}?*??:J?yq]?×Ï_?Ø"??WºÎ?ôwÑ?]?U?êÿ??»???[Ò?GØ?ûòè?Wþ%?»4?óÿ?óf-? w??Cö¨?À ·?ï?ªr/? c?7?{? ÎÐ?Qmî?ó>ú??dú??2???? ?À?E(*?é®B?èÀO?éÀO?æÛn?ûq?Å????*«?TË?ªÿÔ?6? c ^ ºx¡9½¡ZQ&¡øX?¡.1¡?¢µ¢?/¢?V¢Òkh¢&Õ·¢¸Ë¢?ÃË¢¡ÜË¢?ðË¢[ Ì¢?)Ì¢Îí¢,ãÐó2£>Å¿¤+»Ù¤-vM¥ Aî¥éö÷¥^ãZ¦©m?¦Õà¦?D§)?V§ZÍ®§Àܳ§ô ¨ ;(¨??M¨Í??¨$W?¨HÞÚ¨#ì¨&"©áO©å;d©C覩?¨Õ©ñRª=Gªë?Oªá±Îªõoߪҫ±?%«¹â«? ¬;ÃS¬KÀ?¬õ??¬#ǧ¬ßmݬ?p<OK²·±eã*®Lí3®¸Ú?®ÉÖ$¯ÏG5¯&?d¯¶?z¯[)»¯o2ܯgp°ÓÄ-°rE°Ê??°T??°?¿°·Ô°âçL±ÇrT±'[i± ÐW²?)βÛÖײrÞ³¥LÀ³K? ´?y:´c D´È6e´?ã?´?ðï´ã? µj8 µKX*µ6?/µ?ÙCµ¿]µÅ³?µèz?µË?µ1?ɵ?n͵r=¶:J¶tBZ¶?¨a¶ÌQl¶LßÓ¶ö?·ÎÒ_·æ¿·?Ó·?+Ü·é'-¹À®¹û~ê¹sJ?º³Í»×,»>pG» ?»?»N?Ñ»ÖÕÓ»1ö»P¸z¼$¢²¼þFþ¼½g;1½Û&C½ oW½´Ð]¾oÞ~¾½ï?¾ ?¾¿?ë¿~sþ¿(nNÀ»«[ÀÏByÀ??À¸ü¡Àà?£À¦N¤ÀøoÖÀ½?ÞÀ|úXÁR\Áé,¢ÁÚ@ÄÁè/ÊÁ?cÐÁzíàÁª¼Â;?ÂYħ¼ØÂëÃ2ø;Ã??÷Ó?Ãîi¹Ãc?mÄ)wÂÄyÞÄãÅ?H8Å6?AÅJé?Å7÷¬ÅÁº¶ÅÌàÅàõÅ?1ÆkF;Æ (QÆQËTÆ>õUÆ ^`Æ|7°Æ ÝÆ?òÆGH?ÇEm?ÇfÆÇ?ËÇZ?ðÇ@Ô Èz?È1gÈ¢ñ:ÈqÝTÈCâ£ÈñÉmº}ÉÉËÉÑyÌɵÂÊ9*Ê®v¹ÊغÊYs»Ê??0ËÒ¡JËîbˤd?ËÌ ÄËk©ÉË?ÕËé_ãË)Ìz?çÌ&òÌeÞûÌòÚÍÍ>Í?¥xÍmÃÍëÎ=P!ÎÈö;Î÷è©ÎÞ¼ÎÆ0ÒÎãîÎ?ôÎÚ4Ï*½Ï¯.н5Ð"WÐÎ&wÐQûæÐI'yÑBºÑ_?ôÑx1$Ò°®*ÒRØYÒµ)oÒ)ðÿÒIDÓÝ#øÓoðKÔ!ÚþÔ*! Õ\[$Õ¬vÕ?²ªÕb¶ Ö?:Öb?YÖ?aiÖ?ÖÖ? ÖÐLÏÖCó ×`(×5ó<׬?¦×ð¤À×maÒ×Ðeì×ç`ú×ò?ý×õØ?EØ£ÎØérÙQ1ÙTPSÙ(ArÙkÚ:?<Ú?÷QÚKð¼Ú?ÐÚñÜGÛÛMÛÑ}PÛ´ RÛóMSÛW?TÛCÊnÛ¯ý¬Û#Üu1EÜ°³NÜ?m?ÜÄ??ÝdÜ)Þ<?Þ?D¤ÞëÖ¦Þ]ê§ÞØߥýßôÞß>lþß1Wàê&à }àÞ? à??+àÿØ2à´?à(å'á¤=árFDáÉÅVá?»rá??{á<&?á??á-jÂá¬ÒVâÒtâ)3?âlô¥âѶâ$d½â×?Ìâ?æñâ?'@ã2ª[ã?äQäÞ]uäò¤ätY?å?æÔåA¸ÛåOõåb÷Ùæ%! çð?[ç Ê?çÛcÇç)-ãçÒïçcÍ èʪè¹Ycè?'Áèr[Ôèmàèö³Oé8ïaéG¤é?»Ñé7)[êÎÁê}.?ês?ëÈ?Jë³þkëÕQ?ë#?¦ë¶©ëÏ?¼ësâë¢Dãë6eöëÒ5)ìX?ÅìÒ)Ñì×9áìá? íDípÒ.í?è8í 3î)( î?O!î?6îë jî pµî}`¶ï KÕïÕ6õï?ð 'EðRvxð9??ðÍÚ?ð?Ê?ðw5?ðfȨðÎß¿ð?§bñckñÓâ?ñ+??ñÈÀ?ñQo®ñÇj¿ñ?/úñ?,òýeFò½?rò¯?ròt)øòEäóKÎó'Ü!óD,óóÚ-óë©?óER¨óÿIó(¥³óD#Wôõªûôºñõ ñ[õÖìåõJà2öû®Êöj*ìöHpíö]?÷]°÷>ó}ø?©Óø?¹ùwç ùý ?ùÃàúôÀ<ú>êàú?ÃAûaukû rûA?ü9mCü! Fü?Hü?Hü°ÑPüf.¶ü@þü0?ý¼ý|8,ý\²5ý%ÄOý???ý®å¡ý ØýKcþñE1þ:~?þ¬ðúþ¹Zÿ!pÿ×Ó: ÀuK ~Q 4>Q Ø{ ?È¢ ?û ¬???fÑw?ÈR`̸ØØYÞD ªªðñJJZÂ?ýÂ]RÔnêðX «x?:?ó>ê?T'Zz É}?J?"h?w©çÖvø±}|=?³?Q©áYÎ.ºè^$?åóÙ÷`ò#SùT1Cµ(JûU0'£GSõSÁVI°DH`»,u?V¥íþÇå?Ê?aí§?* := ³k ë²| ¥Q? ÚöÝ Hlì }=' ?Ï? ?%¦ ?f¶ fNº f^Ù (Ü ?ß#=?Ub?i ©`(.7 2ŲJzK?E??¹¢-×°÷×°È5ò|R MKc Ž? NP¶ ê®Õ8xÔi5t?ý?AP±%¶¦¹¢&??qqRw?᧷?¨{ÓÆyëÆÍúõ? S$Oã1~i¿µ:èÐ0??n¡?J?¬Xi>~}²LÚ;V<ÄCø«t\??sÜÜ?»ðÐ^÷¥a/?ÏÔ~æ¾.åËÒ nu ½)t¬?æ>óÇ?]?ÏÒyæ´A8 öLuNÒ???êv?/oA{-ï?É?ËïÓPò»e???±Eè?êQÎQ{¥ ð¤l0Y?¹· ßáÌ©²ÝWw?ÃÌ`F:íi?»m.ÅJ+ Úqç 9Ù+!Tjw!w@?!z"f7K"ñi"û?n"Õ·?"¾( #³?#ªZ/#W?=#Êpt#s-{#±?æ#?_ï#B?ï#¢?ð#Áó#òó#G?-$?/ª$?̬$? ®$Ò)Ç$[%?Ñ% V%Â/%`ø~%Rõ°%ÙgÇ%£ÈT&ä?&?/6'BÔE'Z}]'ÁTø'oñ(ê|( xú(0¶)e\3)ñJ<)o2@)³?)zÉ)?ê)Cf*£?(+??Ì+¬:ó+We,½\(,®\=,JÑM,.$X,+_,8ý?,²½?, p?,S¸Þ,?ÿ-:·!-jWP-k7?-¹²-rǺ-ò9»-?.?7?. ?.æÊ$/T4_/ÏC?/6â?/ÞîÍ/? 0 ?¶0?1?ñ1?¼1Ñ:Ä1ý2Ð÷2®B+2o?@2?e2[(o2áþê2Æ?A3÷6q3í´y3&Î?3ÛÜ«3E±D4÷?I4?_4ÂÜ?4?cé4Áú\5ÓRc5)Ç?5?YÃ5âúÕ5É|$6?¸B6¸}6J?6?V?6?ç?6ª?Ó6G?7áO7??c7~?7µÑ?8?#9Í?9=È_9W?h9 ?9l?æ9ù??:åÉ?:?±:\¹:~´,;óÊ6;?ùV;`?Y;O{j;``?;ì*ì;E?ò;#Ô<?-¬<RÌ<ó?Ý<½)=£ =óÿ==èoW=uÑj=?S?=§oÁ=NÔ=?Ac>Ä?>°*?>Ï??>?Å!?«¥?µ?MU»?|°¿?Öù?üùX@?²?@=ä3A?4?AOê?AUs®Ahv¶A³>ÝAÒùÌB?úBs×FCy¸hCk4?C;?©C??ÂCÆïÎC£?ñC 0DaÚlD]?DÈ·´D²ÍDu?:E^YfE-ÿ?EÄæËE¢:ÙE¯Ñ/FA+ÝF?%GÐrG?à?GÐmHyFrH°Ã?H®±?HB?ÝH4eIÄô?I,z»IbaÜI)»?JB¸J§ÖÌJ!ëäJ?K?*eK@??Kcx?KÈ K£&³KfL r@L [DLZÙßL|áLÀ@#M«z%Mc+M?qüMK?qNjÑyNös?N9¿?N%¦ËN? ,O>nO`äObõOPPºHP-?`P??kP6¾kPäàqP*ñ¯P°P{¹P?u?Qñ?ÙQ'ÊRBógRÝpRñz?R(ÌÙR¼üRúÀüR°"qS« ?SÖ?S¤?SÞ²7T?:T?wLT_[Te?sT,?3U:pCU¹?dU8fUejUX??U¹¡Uy±·UÒ ÝUà*9V?llV:wVtì²VQ?$Wü?/W«;WüÖYW¢?nWH?W?h»W ÆW??IXm?bX?ûcX0?X E?Xs¬ÉXÜ~áX?ËiYë"¿YÌ?¿Y ý?ZK¡ZL¥Z*/±Z ¤ÈZ~lèZk?êZñPíZ"]ùZkß[Zèb[?à{[N]©[?[Ur \=t\?\NÍ.\£¼@\?Å\Z¬Ë\?]ÃW]®V]X(e]H?]}j?]q??]UP©]_eµ]]Ç^½ç?^Bµ?^9ª_I®_ù?Å_B?ã_ÉÚó_á=`gXD`Ò³_`ï4³`_°¾`ðú`tAaÏ}DaUAåa2§¡b!Ñb½?Úb¡,êb?òbg cÑqc ;.c¥³<ca?EcëÀecÌz³cXâc_ d(tGd?kWd[Íed®$}dÜ?d'iàdOÊèd??êd?'e?+e°Ó#e+.e??<eíFeL§?eÿUµe¯ó¿eæ«bfÒ¡¯f{Wg:1g%éAg?£ggË??gÐì´g?Õòg?î h±`häÿhË?£hÓÏëh²xôhì?Eia?iz² iØûj-k?:kJòZkµÂ l¬ lA1l?âLl(?lYú?lFêlt?mÔ=m©EVmGì?mÇMÛméìm?~n?÷$nQ"1nÜEnzRnÜknWÃonKqwnªÇ?n¬ø?nçì?n?³nµÚnÁoö:Jo?1boÅü?o¨DpÕãHp²ÈXp5²mp¬?op0ÒÆp$ØqïEpqé«?q?1?qÕü?q7¶q?±?r]rÇ?ár$qgsýrs®h?sƲ¡s¹½¢s?øãs??ÿs·ñt0²©tkøtÆ°þt@Å'uLõRu??uqoavð?vÛ²?v?WËvŲ wWòw!5(w °iwµáwGãwæréw?e1x?\x$å×xÌ%y¤Ð0y(qÛy,Lþy#ºþy,5z/°zàkKzÞkszvkwz=LôzB¥{?I{lM{?nÚ{5þ{£Ô|_ |^N|¢~|? §|#Í«|[rÈ| :}vV?}?m¶}è7ã}d?~dg?~4+?~?Õ¬~²ë~P~áñD ?d¨9Yöñ4 `M := ?9 4 åH ?ã ? D àé ¿- æ Å? 4 úJ óí Q wD +J 5Ý ?4 ÌÎ g Ê ?. W- R3 ¿ ÉF Vü 3 Q4 ?E S? ? ¸ V þ@ ? } X ûI XI w Î6 s Ù$ #ã 5° ý³ g© ? æN 1Ú ÞE f xM ð L? ¨E [ ?U Ñ Ýz 6 ð? +P P J ?Ê ´? ´K Êõ ÖI ºa ø - ²Í ý° âÕ ? x Ñß ò¢ ?; ;? @ èÀ .) &5 é- ?? ?Y àQ ?<