1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
|
<?xml version="1.0" encoding="utf-8"?>
<Schema Namespace="CodeFirstDatabaseSchema" Provider="System.Data.SqlClient" ProviderManifestToken="2008" Alias="Self" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
<EntityType Name="SupplierWithLocation">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
<Property Name="Name" Type="nvarchar(max)" Nullable="true" />
<Property Name="Location" Type="geography" Nullable="true" />
</EntityType>
<EntityType Name="WidgetWithGeometry">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
<Property Name="Name" Type="nvarchar(max)" Nullable="true" />
<Property Name="SomeGeometry" Type="geometry" Nullable="true" />
<Property Name="NotGeometry" Type="nvarchar" Nullable="false" MaxLength="16" />
<Property Name="SomeMoreGeometry" Type="geometry" Nullable="true" />
</EntityType>
<EntityType Name="WidgetWithLineString">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
<Property Name="AGeometricLineString" Type="geometry" Nullable="true" />
</EntityType>
<EntityType Name="WidgetWithPolygon">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
<Property Name="AGeometricPolygon" Type="geometry" Nullable="true" />
</EntityType>
<EntityContainer Name="CodeFirstDatabase">
<EntitySet Name="SupplierWithLocation" EntityType="Self.SupplierWithLocation" Schema="dbo" Table="SupplierWithLocations" />
<EntitySet Name="WidgetWithGeometry" EntityType="Self.WidgetWithGeometry" Schema="dbo" Table="WidgetWithGeometries" />
<EntitySet Name="WidgetWithLineString" EntityType="Self.WidgetWithLineString" Schema="dbo" Table="WidgetWithLineString" />
<EntitySet Name="WidgetWithPolygon" EntityType="Self.WidgetWithPolygon" Schema="dbo" Table="WidgetWithPolygon" />
</EntityContainer>
<Function Name="fx_SuppliersWithinRange" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="true" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
<Parameter Name="miles" Type="int" Mode="In" />
<Parameter Name="location" Type="geography" Mode="In" />
<ReturnType>
<CollectionType>
<RowType>
<Property Name="Id" Type="int" Nullable="false" />
<Property Name="Name" Type="nvarchar(max)" Nullable="true" />
<Property Name="Location" Type="geography" Nullable="true" />
</RowType>
</CollectionType>
</ReturnType>
</Function>
<Function Name="fx_SupplierLocationsWithinRange" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="true" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
<Parameter Name="miles" Type="int" Mode="In" />
<Parameter Name="location" Type="geography" Mode="In" />
<ReturnType>
<CollectionType>
<RowType>
<Property Name="Location" Type="geography" Nullable="true" />
</RowType>
</CollectionType>
</ReturnType>
</Function>
</Schema>
|
