search

dotnet / ef6

This is the codebase for Entity Framework 6 (previously maintained at https://entityframework.codeplex.com). Entity Framework Core is maintained at https://github.com/dotnet/efcore.
https://docs.microsoft.com/ef/ef6
MIT License
1.43k stars 545 forks source link

"This method cannot be translated into a store expression" error occurs when I using User defined function in Edmx with EF6 #840

Closed jacksparrow47 closed 5 years ago

jacksparrow47 commented 5 years ago

Describe what is not working as expected. Hi, I use Ef6 with Oracle.ManagedDataAccess.Client for get record from Oracle database. I have same user defined functions in Oracle for "ToString" or "ToLower" when searching in database. I using Edmx file (Database-First) in application and I have a static class that name is OracleFunctions for using function in Edmx file like below

`

   public static class OracleFunctions
   {
   [EdmFunction("Model.Store", "TO_STRING")]
    public static string NumberToString(Decimal? input)
    {
        throw new NotSupportedException("bu fonksiyon desteklenmiyor");
    }

    [EdmFunction("Model.Store", "TO_STRING")]
    public static string NumberToString(Decimal input)
    {
        throw new NotSupportedException("bu fonksiyon desteklenmiyor");
    }

    [EdmFunction("Model.Store", "TO_STRING")]
    public static string NumberToString(Double? input)
    {

        throw new NotSupportedException("bu fonksiyon desteklenmiyor");
    }

    [EdmFunction("Model.Store", "TO_STRING")]
    public static string NumberToString(double input)
    {

        throw new NotSupportedException("bu fonksiyon desteklenmiyor");
    }

    [EdmFunction("Model.Store", "TO_STRING")]
    public static string NumberToString(int input)
    {

        throw new NotSupportedException("bu fonksiyon desteklenmiyor");
    }

    [EdmFunction("Model.Store", "TO_STRING")]
    public static string NumberToString(int? input)
    {
        throw new NotSupportedException("bu fonksiyon desteklenmiyor");
    }

    [EdmFunction("Model.Store", "TO_STRING")]
    public static string NumberToString(Int16? input)
    {

        throw new NotSupportedException("bu fonksiyon desteklenmiyor");
    }

    [EdmFunction("Model.Store", "TO_STRING")]
    public static string NumberToString(Int16 input)
    {

        throw new NotSupportedException("bu fonksiyon desteklenmiyor");
    }

    [EdmFunction("Model.Store", "TO_STRING")]
    public static string NumberToString(byte? input)
    {

        throw new NotSupportedException("bu fonksiyon desteklenmiyor");
    }

    [EdmFunction("Model.Store", "TO_STRING")]
    public static string NumberToString(byte input)
    {

        throw new NotSupportedException("bu fonksiyon desteklenmiyor");
    }

}

`

Forexample I using this class like below

`

      public static void Main()
       {
        SB.DAL.Test.DbTestEntities dbTest = new SB.DAL.Test.DbTestEntities();

        var getLayer = dbTest.AT_LAYER.Where(a => 
        OracleFunctions.NumberToString(a.SERVICEID).Contains("1")).FirstOrDefault();
      }

`

when I use Ef5 everything is well and returning me results that I want , But when I upgrade to Ef6 then error occurs and throw below exeption

An unhandled exception of type 'System.NotSupportedException' occurred in mscorlib.dll

Additional information: LINQ to Entities does not recognize the method 'System.String NumberToString(System.Decimal)' method, and this method cannot be translated into a store expression.

If you are seeing an exception, include the full exceptions details (message and stack trace).

Exception message:

An unhandled exception of type 'System.NotSupportedException' occurred in mscorlib.dll

Additional information: LINQ to Entities does not recognize the method 'System.String NumberToString(System.Decimal)' method, and this method cannot be translated into a store expression.

Stack trace:

   at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.MethodCallTranslator.DefaultTranslator.Translate(ExpressionConverter parent, MethodCallExpression call)
   at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.MethodCallTranslator.TypedTranslate(ExpressionConverter parent, MethodCallExpression linq)
   at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.TypedTranslator`1.Translate(ExpressionConverter parent, Expression linq)
   at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.TranslateExpression(Expression linq)
   at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.TranslateFunctionIntoLike(MethodCallExpression call, Boolean insertPercentAtStart, Boolean insertPercentAtEnd, Func`5 defaultTranslator)
   at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.MethodCallTranslator.StringContainsTranslator.Translate(ExpressionConverter parent, MethodCallExpression call)
   at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.MethodCallTranslator.TypedTranslate(ExpressionConverter parent, MethodCallExpression linq)
   at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.TypedTranslator`1.Translate(ExpressionConverter parent, Expression linq)
   at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.TranslateExpression(Expression linq)
   at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.TranslateLambda(LambdaExpression lambda, DbExpression input)
   at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.TranslateLambda(LambdaExpression lambda, DbExpression input, DbExpressionBinding& binding)
   at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.MethodCallTranslator.OneLambdaTranslator.Translate(ExpressionConverter parent, MethodCallExpression call, DbExpression& source, DbExpressionBinding& sourceBinding, DbExpression& lambda)
   at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.MethodCallTranslator.OneLambdaTranslator.Translate(ExpressionConverter parent, MethodCallExpression call)
   at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.MethodCallTranslator.SequenceMethodTranslator.Translate(ExpressionConverter parent, MethodCallExpression call, SequenceMethod sequenceMethod)
   at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.MethodCallTranslator.TypedTranslate(ExpressionConverter parent, MethodCallExpression linq)
   at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.TypedTranslator`1.Translate(ExpressionConverter parent, Expression linq)
   at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.TranslateExpression(Expression linq)
   at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.MethodCallTranslator.UnarySequenceMethodTranslator.Translate(ExpressionConverter parent, MethodCallExpression call)
   at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.MethodCallTranslator.SequenceMethodTranslator.Translate(ExpressionConverter parent, MethodCallExpression call, SequenceMethod sequenceMethod)
   at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.MethodCallTranslator.TypedTranslate(ExpressionConverter parent, MethodCallExpression linq)
   at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.TypedTranslator`1.Translate(ExpressionConverter parent, Expression linq)
   at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.TranslateExpression(Expression linq)
   at System.Data.Entity.Core.Objects.ELinq.ExpressionConverter.Convert()
   at System.Data.Entity.Core.Objects.ELinq.ELinqQueryState.GetExecutionPlan(Nullable`1 forMergeOption)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClassb.<GetResults>b__a()
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClassb.<GetResults>b__9()
   at System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute[TResult](Func`1 operation)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0()
   at System.Lazy`1.CreateValue()
   at System.Lazy`1.LazyInitValue()
   at System.Lazy`1.get_Value()
   at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
   at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)
   at System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.<GetElementFunction>b__1[TResult](IEnumerable`1 sequence)
   at System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable`1 query, Expression queryRoot)
   at System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[TResult](Expression expression)
   at System.Data.Entity.Internal.Linq.DbQueryProvider.Execute[TResult](Expression expression)
   at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source)
   at SB.DAL.Test.Program.Main() in C:\Codes\Gits\EKON.SERVICES\Service\SB.DAL.Test\Program.cs:line 16
   at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
   at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
   at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
   at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()

Steps to reproduce

OracleFunctions.cs


 public static class OracleFunctions
    {

        [EdmFunction("Model.Store", "TO_STRING")]
        public static string NumberToString(Decimal? input)
        {
            throw new NotSupportedException("bu fonksiyon desteklenmiyor");
        }

        [EdmFunction("Model.Store", "TO_STRING")]
        public static string NumberToString(Decimal input)
        {
            throw new NotSupportedException("bu fonksiyon desteklenmiyor");
        }

        [EdmFunction("Model.Store", "TO_STRING")]
        public static string NumberToString(Double? input)
        {

            throw new NotSupportedException("bu fonksiyon desteklenmiyor");
        }

        [EdmFunction("Model.Store", "TO_STRING")]
        public static string NumberToString(double input)
        {

            throw new NotSupportedException("bu fonksiyon desteklenmiyor");
        }

        [EdmFunction("Model.Store", "TO_STRING")]
        public static string NumberToString(int input)
        {

            throw new NotSupportedException("bu fonksiyon desteklenmiyor");
        }

        [EdmFunction("Model.Store", "TO_STRING")]
        public static string NumberToString(int? input)
        {
            throw new NotSupportedException("bu fonksiyon desteklenmiyor");
        }

        [EdmFunction("Model.Store", "TO_STRING")]
        public static string NumberToString(Int16? input)
        {

            throw new NotSupportedException("bu fonksiyon desteklenmiyor");
        }

        [EdmFunction("Model.Store", "TO_STRING")]
        public static string NumberToString(Int16 input)
        {

            throw new NotSupportedException("bu fonksiyon desteklenmiyor");
        }

        [EdmFunction("Model.Store", "TO_STRING")]
        public static string NumberToString(byte? input)
        {

            throw new NotSupportedException("bu fonksiyon desteklenmiyor");
        }

        [EdmFunction("Model.Store", "TO_STRING")]
        public static string NumberToString(byte input)
        {

            throw new NotSupportedException("bu fonksiyon desteklenmiyor");
        }

    }

Program.cs


 public static void Main()
        {
            SB.DAL.Test.DbTestEntities dbTest = new SB.DAL.Test.DbTestEntities();

            var getLayer = dbTest.AT_LAYER.Where(a => OracleFunctions.NumberToString(a.SERVICEID).Contains("1")).FirstOrDefault();
        }

DbTestEntities.edmx


 <?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
  <!-- EF Runtime content -->
  <edmx:Runtime>
    <!-- SSDL content -->
    <edmx:StorageModels>
      <Schema Namespace="Model.Store" Provider="Oracle.ManagedDataAccess.Client" ProviderManifestToken="11.2" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
        <EntityType Name="AT_LAYER">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="SYSID" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="SERVICEID" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="CRTR" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="CRTM" Type="date" Nullable="false" />
          <Property Name="UPTM" Type="date" />
          <Property Name="UPTR" Type="number" Precision="38" Scale="0" />
          <Property Name="DISPLAYNAME" Type="nvarchar2" MaxLength="250" />
          <Property Name="LAYERNAME" Type="nvarchar2" MaxLength="250" />
          <Property Name="SERVICETYPEID" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="MINSCALE" Type="number" Precision="38" Scale="0" />
          <Property Name="MAXSCALE" Type="number" Precision="38" Scale="0" />
          <Property Name="XMIN" Type="number" Precision="38" Scale="0" />
          <Property Name="XMAX" Type="number" Precision="38" Scale="0" />
          <Property Name="YMIN" Type="number" Precision="38" Scale="0" />
          <Property Name="YMAX" Type="number" Precision="38" Scale="0" />
          <Property Name="LEGANDURL" Type="clob" />
          <Property Name="LAYERORDER" Type="number" Precision="3" Scale="0" />
          <Property Name="CRS" Type="nvarchar2" MaxLength="50" />
          <Property Name="LAYEROPACITY" Type="number" Precision="3" Scale="0" />
          <Property Name="MATRIXCOUNT" Type="number" Precision="3" Scale="0" />
          <Property Name="STATEID" Type="number" Precision="2" Scale="0" Nullable="false" />
          <Property Name="SERVICEVERSIONID" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="XMAXRES" Type="number" Precision="38" Scale="0" />
          <Property Name="XMINRES" Type="number" Precision="38" Scale="0" />
          <Property Name="YMAXRES" Type="number" Precision="38" Scale="0" />
          <Property Name="YMINRES" Type="number" Precision="38" Scale="0" />
          <Property Name="INTERNALLAYERID" Type="nvarchar2" MaxLength="50" />
          <Property Name="INTERNALSERVICETYPE" Type="nvarchar2" MaxLength="50" />
          <Property Name="WFSLAYERID" Type="number" Precision="38" Scale="0" />
          <Property Name="DEFAULTCRS" Type="nvarchar2" MaxLength="50" />
          <Property Name="INTERNALSERVICEID" Type="nvarchar2" MaxLength="50" />
          <Property Name="LAYERXML" Type="clob" />
          <Property Name="TILEMATRIXSET" Type="nvarchar2" MaxLength="750" />
          <Property Name="ID" Type="number" Precision="38" Scale="0" Nullable="false" />
        </EntityType>
        <EntityType Name="AT_SERVERTYPE_E">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="ID" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="CRTR" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="CRTM" Type="date" Nullable="false" />
          <Property Name="UPTM" Type="date" />
          <Property Name="UPTR" Type="number" Precision="38" Scale="0" />
          <Property Name="NAME" Type="nvarchar2" MaxLength="100" Nullable="false" />
          <Property Name="DSCR" Type="nvarchar2" MaxLength="500" />
        </EntityType>
        <EntityType Name="AT_SERVERVERSION_E">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="ID" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="CRTR" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="CRTM" Type="date" Nullable="false" />
          <Property Name="UPTM" Type="date" />
          <Property Name="UPTR" Type="number" Precision="38" Scale="0" />
          <Property Name="VERSION" Type="nvarchar2" MaxLength="100" Nullable="false" />
          <Property Name="DSCR" Type="nvarchar2" MaxLength="500" />
          <Property Name="SERVERTYPEID" Type="number" Precision="38" Scale="0" Nullable="false" />
        </EntityType>
        <EntityType Name="AT_SERVICE">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="ID" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="SYSID" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="NAME" Type="nvarchar2" MaxLength="250" Nullable="false" />
          <Property Name="CRTR" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="CRTM" Type="date" Nullable="false" />
          <Property Name="UPTM" Type="date" />
          <Property Name="UPTR" Type="number" Precision="38" Scale="0" />
          <Property Name="INSTITUTIONID" Type="number" Precision="38" Scale="0" />
          <Property Name="STATEID" Type="number" Precision="2" Scale="0" Nullable="false" />
          <Property Name="SERVERTYPEID" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="SERVERVERSIONID" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="ISINTERNAL" Type="number" Precision="2" Scale="0" />
          <Property Name="INTERNALSYSID" Type="nvarchar2" MaxLength="50" />
          <Property Name="INTERNALSERVICEID" Type="nvarchar2" MaxLength="50" />
        </EntityType>
        <EntityType Name="AT_SERVICEAUTHTYPE_E">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="ID" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="NAME" Type="nvarchar2" MaxLength="100" Nullable="false" />
          <Property Name="DSCR" Type="nvarchar2" MaxLength="500" Nullable="false" />
        </EntityType>
        <EntityType Name="AT_SERVICETYPE_E">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="ID" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="CRTR" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="CRTM" Type="date" Nullable="false" />
          <Property Name="UPTM" Type="date" />
          <Property Name="UPTR" Type="number" Precision="38" Scale="0" />
          <Property Name="NAME" Type="nvarchar2" MaxLength="100" Nullable="false" />
          <Property Name="DSCR" Type="nvarchar2" MaxLength="500" />
        </EntityType>
        <EntityType Name="AT_SERVICEVERSION">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="SERVICEID" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="VERSION" Type="nvarchar2" MaxLength="50" Nullable="false" />
          <Property Name="CRTR" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="CRTM" Type="date" Nullable="false" />
          <Property Name="UPTM" Type="date" />
          <Property Name="UPTR" Type="number" Precision="38" Scale="0" />
          <Property Name="SYSID" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="SERVICETYPEID" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="URL" Type="nvarchar2" MaxLength="2000" />
          <Property Name="USERNAME" Type="nvarchar2" MaxLength="100" />
          <Property Name="PASSWORD" Type="nvarchar2" MaxLength="100" />
          <Property Name="ISSECURE" Type="number" Precision="2" Scale="0" />
          <Property Name="TOKEN" Type="nvarchar2" MaxLength="100" />
          <Property Name="AUTHENTICATIONTYPEID" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="ISDEFAULT" Type="number" Precision="2" Scale="0" Nullable="false" />
          <Property Name="MAXWIDTH" Type="nvarchar2" MaxLength="50" />
          <Property Name="MAXHEIGHT" Type="nvarchar2" MaxLength="50" />
          <Property Name="DSCR" Type="nvarchar2" MaxLength="250" />
          <Property Name="CLIENTID" Type="nvarchar2" MaxLength="50" />
          <Property Name="CLIENTSECRET" Type="nvarchar2" MaxLength="250" />
          <Property Name="AUTHENTICATIONURL" Type="nvarchar2" MaxLength="500" />
          <Property Name="TOKENEXPIRATIONDATE" Type="date" />
          <Property Name="OLDATLASUSERNAME" Type="nvarchar2" MaxLength="100" />
          <Property Name="OLDATLASPASSWORD" Type="nvarchar2" MaxLength="100" />
          <Property Name="PROCEEDACCORDINGCAPABILITIES" Type="number" Precision="2" Scale="0" />
          <Property Name="ACCESSLEVEL" Type="number" Precision="38" Scale="0" />
          <Property Name="FORCEALLLAYER" Type="number" Precision="38" Scale="0" />
          <Property Name="ID" Type="number" Precision="38" Scale="0" Nullable="false" />
        </EntityType>
        <EntityType Name="AT_SERVICEVERSIONOPERATION">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="SERVICEVERSIONID" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="NAME" Type="nvarchar2" MaxLength="250" Nullable="false" />
          <Property Name="GETURL" Type="nvarchar2" MaxLength="2000" />
          <Property Name="POSTURL" Type="nvarchar2" MaxLength="2000" />
          <Property Name="CRTM" Type="date" Nullable="false" />
          <Property Name="CRTR" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="UPTM" Type="date" />
          <Property Name="UPTR" Type="number" Precision="38" Scale="0" />
          <Property Name="FORMATLIST" Type="nvarchar2" MaxLength="1000" />
          <Property Name="ID" Type="number" Precision="38" Scale="0" Nullable="false" />
        </EntityType>
        <EntityType Name="AT_SERVICEVERSIONTILEMATRIX">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="SERVICEVERSIONID" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="NAME" Type="nvarchar2" MaxLength="250" Nullable="false" />
          <Property Name="DSCR" Type="nvarchar2" MaxLength="750" />
          <Property Name="CRS" Type="nvarchar2" MaxLength="250" />
          <Property Name="WELLKNOWNSCALESET" Type="nvarchar2" MaxLength="500" />
          <Property Name="MATRIXCOUNT" Type="number" Precision="38" Scale="0" />
          <Property Name="TILEWIDTH" Type="number" Precision="38" Scale="0" />
          <Property Name="TILEHEIGHT" Type="number" Precision="38" Scale="0" />
          <Property Name="ID" Type="number" Precision="38" Scale="0" Nullable="false" />
        </EntityType>
        <EntityType Name="AT_USERLAYERLIST">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="ID" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="NAME" Type="nvarchar2" MaxLength="250" Nullable="false" />
          <Property Name="DSCR" Type="nvarchar2" MaxLength="1000" />
          <Property Name="CRTM" Type="date" Nullable="false" />
          <Property Name="CRTR" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="UPTM" Type="date" />
          <Property Name="UPTR" Type="number" Precision="38" Scale="0" />
          <Property Name="SYSID" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="USERID" Type="number" Precision="38" Scale="0" />
        </EntityType>
        <EntityType Name="AT_USERROLELAYERRELATION">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="ID" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="SYSID" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="CRTM" Type="date" Nullable="false" />
          <Property Name="CRTR" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="USERID" Type="number" Precision="38" Scale="0" />
          <Property Name="ROLEID" Type="number" Precision="38" Scale="0" />
          <Property Name="LAYERID" Type="number" Precision="38" Scale="0" />
          <Property Name="SERVICEVERSIONID" Type="number" Precision="38" Scale="0" />
          <Property Name="DISPLAYNAME" Type="nvarchar2" MaxLength="250" />
          <Property Name="URL" Type="nvarchar2" MaxLength="2000" />
          <Property Name="ROWNUMBER" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="PARENTROWNUMBER" Type="number" Precision="38" Scale="0" />
          <Property Name="ISEXTERNAL" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="WFSWRITE" Type="number" Precision="38" Scale="0" Nullable="false" />
          <Property Name="BASICAUTHUSERNAME" Type="nvarchar2" MaxLength="50" />
          <Property Name="BASICAUTHPASSWORD" Type="nvarchar2" MaxLength="50" />
          <Property Name="VERSION" Type="nvarchar2" MaxLength="50" />
          <Property Name="SERVICETYPE" Type="nvarchar2" MaxLength="50" />
          <Property Name="LAYERNAME" Type="nvarchar2" MaxLength="250" />
          <Property Name="XMIN" Type="number" Precision="38" Scale="0" />
          <Property Name="XMAX" Type="number" Precision="38" Scale="0" />
          <Property Name="YMIN" Type="number" Precision="38" Scale="0" />
          <Property Name="YMAX" Type="number" Precision="38" Scale="0" />
          <Property Name="XMAXRES" Type="number" Precision="38" Scale="0" />
          <Property Name="XMINRES" Type="number" Precision="38" Scale="0" />
          <Property Name="YMAXRES" Type="number" Precision="38" Scale="0" />
          <Property Name="YMINRES" Type="number" Precision="38" Scale="0" />
          <Property Name="LEGANDURL" Type="clob" />
          <Property Name="APIKEY" Type="nvarchar2" MaxLength="100" />
          <Property Name="TOKEN" Type="nvarchar2" MaxLength="100" />
          <Property Name="USERLAYERLISTID" Type="number" Precision="38" Scale="0" />
          <Property Name="MINSCALE" Type="number" Precision="38" Scale="0" />
          <Property Name="MAXSCALE" Type="number" Precision="38" Scale="0" />
          <Property Name="MATRIXCOUNT" Type="number" Precision="38" Scale="0" />
          <Property Name="LAYEROPACITY" Type="number" Precision="38" Scale="0" />
          <Property Name="CRS" Type="nvarchar2" MaxLength="20" />
          <Property Name="LAYERORDER" Type="number" Precision="38" Scale="0" />
          <Property Name="SLD" Type="clob" />
          <Property Name="DEFAULTCRS" Type="nvarchar2" MaxLength="20" />
          <Property Name="TRANSACTIONID" Type="nvarchar2" MaxLength="50" />
        </EntityType>
        <Association Name="AT_LAYER_FK1">
          <End Role="AT_SERVICE" Type="Self.AT_SERVICE" Multiplicity="1" />
          <End Role="AT_LAYER" Type="Self.AT_LAYER" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AT_SERVICE">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="AT_LAYER">
              <PropertyRef Name="SERVICEID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="AT_SERVICEVERSION_FK1">
          <End Role="AT_SERVICE" Type="Self.AT_SERVICE" Multiplicity="1" />
          <End Role="AT_SERVICEVERSION" Type="Self.AT_SERVICEVERSION" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AT_SERVICE">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="AT_SERVICEVERSION">
              <PropertyRef Name="SERVICEID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="AT_SERVICEVERSIONOPERATIO_FK1">
          <End Role="AT_SERVICEVERSION" Type="Self.AT_SERVICEVERSION" Multiplicity="1" />
          <End Role="AT_SERVICEVERSIONOPERATION" Type="Self.AT_SERVICEVERSIONOPERATION" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AT_SERVICEVERSION">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="AT_SERVICEVERSIONOPERATION">
              <PropertyRef Name="SERVICEVERSIONID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="AT_SERVICEVERTILEMATRIX_FK1">
          <End Role="AT_SERVICEVERSION" Type="Self.AT_SERVICEVERSION" Multiplicity="1" />
          <End Role="AT_SERVICEVERSIONTILEMATRIX" Type="Self.AT_SERVICEVERSIONTILEMATRIX" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AT_SERVICEVERSION">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="AT_SERVICEVERSIONTILEMATRIX">
              <PropertyRef Name="SERVICEVERSIONID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="AT_USERROLELAYERRELATION_FK1">
          <End Role="AT_USERLAYERLIST" Type="Self.AT_USERLAYERLIST" Multiplicity="0..1" />
          <End Role="AT_USERROLELAYERRELATION" Type="Self.AT_USERROLELAYERRELATION" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AT_USERLAYERLIST">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="AT_USERROLELAYERRELATION">
              <PropertyRef Name="USERLAYERLISTID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="AT_USERROLELAYERRELATION_FK4">
          <End Role="AT_LAYER" Type="Self.AT_LAYER" Multiplicity="0..1" />
          <End Role="AT_USERROLELAYERRELATION" Type="Self.AT_USERROLELAYERRELATION" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AT_LAYER">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="AT_USERROLELAYERRELATION">
              <PropertyRef Name="LAYERID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="LAYERSERVICEVERSION">
          <End Role="AT_SERVICEVERSION" Type="Self.AT_SERVICEVERSION" Multiplicity="1" />
          <End Role="AT_LAYER" Type="Self.AT_LAYER" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AT_SERVICEVERSION">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="AT_LAYER">
              <PropertyRef Name="SERVICEVERSIONID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="LAYERTYPE">
          <End Role="AT_SERVICETYPE_E" Type="Self.AT_SERVICETYPE_E" Multiplicity="1" />
          <End Role="AT_LAYER" Type="Self.AT_LAYER" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AT_SERVICETYPE_E">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="AT_LAYER">
              <PropertyRef Name="SERVICETYPEID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="SERVERTYPEVERSION">
          <End Role="AT_SERVERTYPE_E" Type="Self.AT_SERVERTYPE_E" Multiplicity="1" />
          <End Role="AT_SERVERVERSION_E" Type="Self.AT_SERVERVERSION_E" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AT_SERVERTYPE_E">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="AT_SERVERVERSION_E">
              <PropertyRef Name="SERVERTYPEID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="SERVICEAUTHENTICATIONTYPE">
          <End Role="AT_SERVICEAUTHTYPE_E" Type="Self.AT_SERVICEAUTHTYPE_E" Multiplicity="1" />
          <End Role="AT_SERVICEVERSION" Type="Self.AT_SERVICEVERSION" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AT_SERVICEAUTHTYPE_E">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="AT_SERVICEVERSION">
              <PropertyRef Name="AUTHENTICATIONTYPEID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="SERVICESERVERTYPE">
          <End Role="AT_SERVERTYPE_E" Type="Self.AT_SERVERTYPE_E" Multiplicity="1" />
          <End Role="AT_SERVICE" Type="Self.AT_SERVICE" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AT_SERVERTYPE_E">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="AT_SERVICE">
              <PropertyRef Name="SERVERTYPEID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="SERVICESERVERVERTION">
          <End Role="AT_SERVERVERSION_E" Type="Self.AT_SERVERVERSION_E" Multiplicity="1" />
          <End Role="AT_SERVICE" Type="Self.AT_SERVICE" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AT_SERVERVERSION_E">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="AT_SERVICE">
              <PropertyRef Name="SERVERVERSIONID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="SERVICEVERSIIONSERVICETYPE">
          <End Role="AT_SERVICETYPE_E" Type="Self.AT_SERVICETYPE_E" Multiplicity="1" />
          <End Role="AT_SERVICEVERSION" Type="Self.AT_SERVICEVERSION" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AT_SERVICETYPE_E">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="AT_SERVICEVERSION">
              <PropertyRef Name="SERVICETYPEID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Function Name="DATETOSTRING" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="true" ParameterTypeSemantics="AllowImplicitConversion" Schema="AKBIS" ReturnType="varchar2">
          <Parameter Name="DEGER" Type="date" Mode="In" />
        </Function>
        <Function Name="DATETRUNC" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="true" ParameterTypeSemantics="AllowImplicitConversion" Schema="AKBIS" ReturnType="date">
          <Parameter Name="DEGER" Type="date" Mode="In" />
        </Function>
        <Function Name="EKON_ISTINFO_CALC_F" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="AKBIS">
          <Parameter Name="KAYDON" Type="varchar2" Mode="In" />
        </Function>
        <Function Name="EKON_TICINFO_CALC_F" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="AKBIS">
          <Parameter Name="KAYDON" Type="varchar2" Mode="In" />
        </Function>
        <Function Name="TO_STRING" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="true" ParameterTypeSemantics="AllowImplicitConversion" Schema="AKBIS" ReturnType="varchar2">
          <Parameter Name="DEGER" Type="number" Mode="In" />
        </Function>
        <Function Name="TURKISHCHRACTERCONVERT" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="true" ParameterTypeSemantics="AllowImplicitConversion" Schema="AKBIS" ReturnType="varchar2">
          <Parameter Name="INPUT" Type="varchar2" Mode="In" />
          <Parameter Name="CONVERTTYPE" Type="number" Mode="In" />
        </Function>
        <Function Name="UPDATESERVICESTATEPRO" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="AKBIS">
          <Parameter Name="FUPTR" Type="number" Mode="In" />
          <Parameter Name="FSTATEID" Type="number" Mode="In" />
          <Parameter Name="FID" Type="number" Mode="In" />
          <Parameter Name="FIDOUT" Type="number" Mode="Out" />
        </Function>
        <EntityContainer Name="ModelStoreContainer">
          <EntitySet Name="AT_LAYER" EntityType="Self.AT_LAYER" Schema="AKBIS" store:Type="Tables" />
          <EntitySet Name="AT_SERVERTYPE_E" EntityType="Self.AT_SERVERTYPE_E" Schema="AKBIS" store:Type="Tables" />
          <EntitySet Name="AT_SERVERVERSION_E" EntityType="Self.AT_SERVERVERSION_E" Schema="AKBIS" store:Type="Tables" />
          <EntitySet Name="AT_SERVICE" EntityType="Self.AT_SERVICE" Schema="AKBIS" store:Type="Tables" />
          <EntitySet Name="AT_SERVICEAUTHTYPE_E" EntityType="Self.AT_SERVICEAUTHTYPE_E" Schema="AKBIS" store:Type="Tables" />
          <EntitySet Name="AT_SERVICETYPE_E" EntityType="Self.AT_SERVICETYPE_E" Schema="AKBIS" store:Type="Tables" />
          <EntitySet Name="AT_SERVICEVERSION" EntityType="Self.AT_SERVICEVERSION" Schema="AKBIS" store:Type="Tables" />
          <EntitySet Name="AT_SERVICEVERSIONOPERATION" EntityType="Self.AT_SERVICEVERSIONOPERATION" Schema="AKBIS" store:Type="Tables" />
          <EntitySet Name="AT_SERVICEVERSIONTILEMATRIX" EntityType="Self.AT_SERVICEVERSIONTILEMATRIX" Schema="AKBIS" store:Type="Tables" />
          <EntitySet Name="AT_USERLAYERLIST" EntityType="Self.AT_USERLAYERLIST" Schema="AKBIS" store:Type="Tables" />
          <EntitySet Name="AT_USERROLELAYERRELATION" EntityType="Self.AT_USERROLELAYERRELATION" Schema="AKBIS" store:Type="Tables" />
          <AssociationSet Name="AT_LAYER_FK1" Association="Self.AT_LAYER_FK1">
            <End Role="AT_SERVICE" EntitySet="AT_SERVICE" />
            <End Role="AT_LAYER" EntitySet="AT_LAYER" />
          </AssociationSet>
          <AssociationSet Name="AT_SERVICEVERSION_FK1" Association="Self.AT_SERVICEVERSION_FK1">
            <End Role="AT_SERVICE" EntitySet="AT_SERVICE" />
            <End Role="AT_SERVICEVERSION" EntitySet="AT_SERVICEVERSION" />
          </AssociationSet>
          <AssociationSet Name="AT_SERVICEVERSIONOPERATIO_FK1" Association="Self.AT_SERVICEVERSIONOPERATIO_FK1">
            <End Role="AT_SERVICEVERSION" EntitySet="AT_SERVICEVERSION" />
            <End Role="AT_SERVICEVERSIONOPERATION" EntitySet="AT_SERVICEVERSIONOPERATION" />
          </AssociationSet>
          <AssociationSet Name="AT_SERVICEVERTILEMATRIX_FK1" Association="Self.AT_SERVICEVERTILEMATRIX_FK1">
            <End Role="AT_SERVICEVERSION" EntitySet="AT_SERVICEVERSION" />
            <End Role="AT_SERVICEVERSIONTILEMATRIX" EntitySet="AT_SERVICEVERSIONTILEMATRIX" />
          </AssociationSet>
          <AssociationSet Name="AT_USERROLELAYERRELATION_FK1" Association="Self.AT_USERROLELAYERRELATION_FK1">
            <End Role="AT_USERLAYERLIST" EntitySet="AT_USERLAYERLIST" />
            <End Role="AT_USERROLELAYERRELATION" EntitySet="AT_USERROLELAYERRELATION" />
          </AssociationSet>
          <AssociationSet Name="AT_USERROLELAYERRELATION_FK4" Association="Self.AT_USERROLELAYERRELATION_FK4">
            <End Role="AT_LAYER" EntitySet="AT_LAYER" />
            <End Role="AT_USERROLELAYERRELATION" EntitySet="AT_USERROLELAYERRELATION" />
          </AssociationSet>
          <AssociationSet Name="LAYERSERVICEVERSION" Association="Self.LAYERSERVICEVERSION">
            <End Role="AT_SERVICEVERSION" EntitySet="AT_SERVICEVERSION" />
            <End Role="AT_LAYER" EntitySet="AT_LAYER" />
          </AssociationSet>
          <AssociationSet Name="LAYERTYPE" Association="Self.LAYERTYPE">
            <End Role="AT_SERVICETYPE_E" EntitySet="AT_SERVICETYPE_E" />
            <End Role="AT_LAYER" EntitySet="AT_LAYER" />
          </AssociationSet>
          <AssociationSet Name="SERVERTYPEVERSION" Association="Self.SERVERTYPEVERSION">
            <End Role="AT_SERVERTYPE_E" EntitySet="AT_SERVERTYPE_E" />
            <End Role="AT_SERVERVERSION_E" EntitySet="AT_SERVERVERSION_E" />
          </AssociationSet>
          <AssociationSet Name="SERVICEAUTHENTICATIONTYPE" Association="Self.SERVICEAUTHENTICATIONTYPE">
            <End Role="AT_SERVICEAUTHTYPE_E" EntitySet="AT_SERVICEAUTHTYPE_E" />
            <End Role="AT_SERVICEVERSION" EntitySet="AT_SERVICEVERSION" />
          </AssociationSet>
          <AssociationSet Name="SERVICESERVERTYPE" Association="Self.SERVICESERVERTYPE">
            <End Role="AT_SERVERTYPE_E" EntitySet="AT_SERVERTYPE_E" />
            <End Role="AT_SERVICE" EntitySet="AT_SERVICE" />
          </AssociationSet>
          <AssociationSet Name="SERVICESERVERVERTION" Association="Self.SERVICESERVERVERTION">
            <End Role="AT_SERVERVERSION_E" EntitySet="AT_SERVERVERSION_E" />
            <End Role="AT_SERVICE" EntitySet="AT_SERVICE" />
          </AssociationSet>
          <AssociationSet Name="SERVICEVERSIIONSERVICETYPE" Association="Self.SERVICEVERSIIONSERVICETYPE">
            <End Role="AT_SERVICETYPE_E" EntitySet="AT_SERVICETYPE_E" />
            <End Role="AT_SERVICEVERSION" EntitySet="AT_SERVICEVERSION" />
          </AssociationSet>
        </EntityContainer>
      </Schema>
    </edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="Model" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
        <EntityType Name="AT_LAYER">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="SYSID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="SERVICEID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="CRTR" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="CRTM" Type="DateTime" Nullable="false" />
          <Property Name="UPTM" Type="DateTime" />
          <Property Name="UPTR" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="DISPLAYNAME" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="LAYERNAME" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="SERVICETYPEID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="MINSCALE" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="MAXSCALE" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="XMIN" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="XMAX" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="YMIN" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="YMAX" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="LEGANDURL" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
          <Property Name="LAYERORDER" Type="Int16" />
          <Property Name="CRS" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="LAYEROPACITY" Type="Int16" />
          <Property Name="MATRIXCOUNT" Type="Int16" />
          <Property Name="STATEID" Type="Int16" Nullable="false" />
          <Property Name="SERVICEVERSIONID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="XMAXRES" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="XMINRES" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="YMAXRES" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="YMINRES" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="INTERNALLAYERID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="INTERNALSERVICETYPE" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="WFSLAYERID" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="DEFAULTCRS" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="INTERNALSERVICEID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="LAYERXML" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
          <Property Name="TILEMATRIXSET" Type="String" MaxLength="750" FixedLength="false" Unicode="true" />
          <Property Name="ID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <NavigationProperty Name="AT_SERVICE" Relationship="Self.AT_LAYER_FK1" FromRole="AT_LAYER" ToRole="AT_SERVICE" />
          <NavigationProperty Name="AT_USERROLELAYERRELATION" Relationship="Self.AT_USERROLELAYERRELATION_FK4" FromRole="AT_LAYER" ToRole="AT_USERROLELAYERRELATION" />
          <NavigationProperty Name="AT_SERVICEVERSION" Relationship="Self.LAYERSERVICEVERSION" FromRole="AT_LAYER" ToRole="AT_SERVICEVERSION" />
          <NavigationProperty Name="AT_SERVICETYPE_E" Relationship="Self.LAYERTYPE" FromRole="AT_LAYER" ToRole="AT_SERVICETYPE_E" />
        </EntityType>
        <EntityType Name="AT_SERVERTYPE_E">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="ID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="CRTR" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="CRTM" Type="DateTime" Nullable="false" />
          <Property Name="UPTM" Type="DateTime" />
          <Property Name="UPTR" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="NAME" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="DSCR" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="AT_SERVERVERSION_E" Relationship="Self.SERVERTYPEVERSION" FromRole="AT_SERVERTYPE_E" ToRole="AT_SERVERVERSION_E" />
          <NavigationProperty Name="AT_SERVICE" Relationship="Self.SERVICESERVERTYPE" FromRole="AT_SERVERTYPE_E" ToRole="AT_SERVICE" />
        </EntityType>
        <EntityType Name="AT_SERVERVERSION_E">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="ID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="CRTR" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="CRTM" Type="DateTime" Nullable="false" />
          <Property Name="UPTM" Type="DateTime" />
          <Property Name="UPTR" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="VERSION" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="DSCR" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
          <Property Name="SERVERTYPEID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <NavigationProperty Name="AT_SERVERTYPE_E" Relationship="Self.SERVERTYPEVERSION" FromRole="AT_SERVERVERSION_E" ToRole="AT_SERVERTYPE_E" />
          <NavigationProperty Name="AT_SERVICE" Relationship="Self.SERVICESERVERVERTION" FromRole="AT_SERVERVERSION_E" ToRole="AT_SERVICE" />
        </EntityType>
        <EntityType Name="AT_SERVICE">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="ID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="SYSID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="NAME" Type="String" MaxLength="250" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="CRTR" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="CRTM" Type="DateTime" Nullable="false" />
          <Property Name="UPTM" Type="DateTime" />
          <Property Name="UPTR" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="INSTITUTIONID" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="STATEID" Type="Int16" Nullable="false" />
          <Property Name="SERVERTYPEID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="SERVERVERSIONID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="ISINTERNAL" Type="Int16" />
          <Property Name="INTERNALSYSID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="INTERNALSERVICEID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="AT_LAYER" Relationship="Self.AT_LAYER_FK1" FromRole="AT_SERVICE" ToRole="AT_LAYER" />
          <NavigationProperty Name="AT_SERVERTYPE_E" Relationship="Self.SERVICESERVERTYPE" FromRole="AT_SERVICE" ToRole="AT_SERVERTYPE_E" />
          <NavigationProperty Name="AT_SERVERVERSION_E" Relationship="Self.SERVICESERVERVERTION" FromRole="AT_SERVICE" ToRole="AT_SERVERVERSION_E" />
          <NavigationProperty Name="AT_SERVICEVERSION" Relationship="Self.AT_SERVICEVERSION_FK1" FromRole="AT_SERVICE" ToRole="AT_SERVICEVERSION" />
        </EntityType>
        <EntityType Name="AT_SERVICEAUTHTYPE_E">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="ID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="NAME" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="DSCR" Type="String" MaxLength="500" FixedLength="false" Unicode="true" Nullable="false" />
          <NavigationProperty Name="AT_SERVICEVERSION" Relationship="Self.SERVICEAUTHENTICATIONTYPE" FromRole="AT_SERVICEAUTHTYPE_E" ToRole="AT_SERVICEVERSION" />
        </EntityType>
        <EntityType Name="AT_SERVICETYPE_E">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="ID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="CRTR" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="CRTM" Type="DateTime" Nullable="false" />
          <Property Name="UPTM" Type="DateTime" />
          <Property Name="UPTR" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="NAME" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="DSCR" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="AT_LAYER" Relationship="Self.LAYERTYPE" FromRole="AT_SERVICETYPE_E" ToRole="AT_LAYER" />
          <NavigationProperty Name="AT_SERVICEVERSION" Relationship="Self.SERVICEVERSIIONSERVICETYPE" FromRole="AT_SERVICETYPE_E" ToRole="AT_SERVICEVERSION" />
        </EntityType>
        <EntityType Name="AT_SERVICEVERSION">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="SERVICEID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="VERSION" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="CRTR" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="CRTM" Type="DateTime" Nullable="false" />
          <Property Name="UPTM" Type="DateTime" />
          <Property Name="UPTR" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="SYSID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="SERVICETYPEID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="URL" Type="String" MaxLength="2000" FixedLength="false" Unicode="true" />
          <Property Name="USERNAME" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="PASSWORD" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="ISSECURE" Type="Int16" />
          <Property Name="TOKEN" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="AUTHENTICATIONTYPEID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="ISDEFAULT" Type="Int16" Nullable="false" />
          <Property Name="MAXWIDTH" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="MAXHEIGHT" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="DSCR" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="CLIENTID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="CLIENTSECRET" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="AUTHENTICATIONURL" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
          <Property Name="TOKENEXPIRATIONDATE" Type="DateTime" />
          <Property Name="OLDATLASUSERNAME" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="OLDATLASPASSWORD" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="PROCEEDACCORDINGCAPABILITIES" Type="Int16" />
          <Property Name="ACCESSLEVEL" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="FORCEALLLAYER" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="ID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <NavigationProperty Name="AT_LAYER" Relationship="Self.LAYERSERVICEVERSION" FromRole="AT_SERVICEVERSION" ToRole="AT_LAYER" />
          <NavigationProperty Name="AT_SERVICE" Relationship="Self.AT_SERVICEVERSION_FK1" FromRole="AT_SERVICEVERSION" ToRole="AT_SERVICE" />
          <NavigationProperty Name="AT_SERVICEAUTHTYPE_E" Relationship="Self.SERVICEAUTHENTICATIONTYPE" FromRole="AT_SERVICEVERSION" ToRole="AT_SERVICEAUTHTYPE_E" />
          <NavigationProperty Name="AT_SERVICETYPE_E" Relationship="Self.SERVICEVERSIIONSERVICETYPE" FromRole="AT_SERVICEVERSION" ToRole="AT_SERVICETYPE_E" />
          <NavigationProperty Name="AT_SERVICEVERSIONOPERATION" Relationship="Self.AT_SERVICEVERSIONOPERATIO_FK1" FromRole="AT_SERVICEVERSION" ToRole="AT_SERVICEVERSIONOPERATION" />
          <NavigationProperty Name="AT_SERVICEVERSIONTILEMATRIX" Relationship="Self.AT_SERVICEVERTILEMATRIX_FK1" FromRole="AT_SERVICEVERSION" ToRole="AT_SERVICEVERSIONTILEMATRIX" />
        </EntityType>
        <EntityType Name="AT_SERVICEVERSIONOPERATION">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="SERVICEVERSIONID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="NAME" Type="String" MaxLength="250" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="GETURL" Type="String" MaxLength="2000" FixedLength="false" Unicode="true" />
          <Property Name="POSTURL" Type="String" MaxLength="2000" FixedLength="false" Unicode="true" />
          <Property Name="CRTM" Type="DateTime" Nullable="false" />
          <Property Name="CRTR" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="UPTM" Type="DateTime" />
          <Property Name="UPTR" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="FORMATLIST" Type="String" MaxLength="1000" FixedLength="false" Unicode="true" />
          <Property Name="ID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <NavigationProperty Name="AT_SERVICEVERSION" Relationship="Self.AT_SERVICEVERSIONOPERATIO_FK1" FromRole="AT_SERVICEVERSIONOPERATION" ToRole="AT_SERVICEVERSION" />
        </EntityType>
        <EntityType Name="AT_SERVICEVERSIONTILEMATRIX">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="SERVICEVERSIONID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="NAME" Type="String" MaxLength="250" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="DSCR" Type="String" MaxLength="750" FixedLength="false" Unicode="true" />
          <Property Name="CRS" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="WELLKNOWNSCALESET" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
          <Property Name="MATRIXCOUNT" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="TILEWIDTH" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="TILEHEIGHT" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="ID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <NavigationProperty Name="AT_SERVICEVERSION" Relationship="Self.AT_SERVICEVERTILEMATRIX_FK1" FromRole="AT_SERVICEVERSIONTILEMATRIX" ToRole="AT_SERVICEVERSION" />
        </EntityType>
        <EntityType Name="AT_USERLAYERLIST">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="ID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="NAME" Type="String" MaxLength="250" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="DSCR" Type="String" MaxLength="1000" FixedLength="false" Unicode="true" />
          <Property Name="CRTM" Type="DateTime" Nullable="false" />
          <Property Name="CRTR" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="UPTM" Type="DateTime" />
          <Property Name="UPTR" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="SYSID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="USERID" Type="Decimal" Precision="38" Scale="0" />
          <NavigationProperty Name="AT_USERROLELAYERRELATION" Relationship="Self.AT_USERROLELAYERRELATION_FK1" FromRole="AT_USERLAYERLIST" ToRole="AT_USERROLELAYERRELATION" />
        </EntityType>
        <EntityType Name="AT_USERROLELAYERRELATION">
          <Key>
            <PropertyRef Name="ID" />
          </Key>
          <Property Name="ID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="SYSID" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="CRTM" Type="DateTime" Nullable="false" />
          <Property Name="CRTR" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="USERID" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="ROLEID" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="LAYERID" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="SERVICEVERSIONID" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="DISPLAYNAME" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="URL" Type="String" MaxLength="2000" FixedLength="false" Unicode="true" />
          <Property Name="ROWNUMBER" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="PARENTROWNUMBER" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="ISEXTERNAL" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="WFSWRITE" Type="Decimal" Precision="38" Scale="0" Nullable="false" />
          <Property Name="BASICAUTHUSERNAME" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="BASICAUTHPASSWORD" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="VERSION" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="SERVICETYPE" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="LAYERNAME" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="XMIN" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="XMAX" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="YMIN" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="YMAX" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="XMAXRES" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="XMINRES" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="YMAXRES" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="YMINRES" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="LEGANDURL" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
          <Property Name="APIKEY" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="TOKEN" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
          <Property Name="USERLAYERLISTID" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="MINSCALE" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="MAXSCALE" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="MATRIXCOUNT" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="LAYEROPACITY" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="CRS" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="LAYERORDER" Type="Decimal" Precision="38" Scale="0" />
          <Property Name="SLD" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
          <Property Name="DEFAULTCRS" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
          <Property Name="TRANSACTIONID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <NavigationProperty Name="AT_LAYER" Relationship="Self.AT_USERROLELAYERRELATION_FK4" FromRole="AT_USERROLELAYERRELATION" ToRole="AT_LAYER" />
          <NavigationProperty Name="AT_USERLAYERLIST" Relationship="Self.AT_USERROLELAYERRELATION_FK1" FromRole="AT_USERROLELAYERRELATION" ToRole="AT_USERLAYERLIST" />
        </EntityType>
        <Association Name="AT_LAYER_FK1">
          <End Role="AT_SERVICE" Type="Self.AT_SERVICE" Multiplicity="1" />
          <End Role="AT_LAYER" Type="Self.AT_LAYER" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AT_SERVICE">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="AT_LAYER">
              <PropertyRef Name="SERVICEID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="AT_USERROLELAYERRELATION_FK4">
          <End Role="AT_LAYER" Type="Self.AT_LAYER" Multiplicity="0..1" />
          <End Role="AT_USERROLELAYERRELATION" Type="Self.AT_USERROLELAYERRELATION" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AT_LAYER">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="AT_USERROLELAYERRELATION">
              <PropertyRef Name="LAYERID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="LAYERSERVICEVERSION">
          <End Role="AT_SERVICEVERSION" Type="Self.AT_SERVICEVERSION" Multiplicity="1" />
          <End Role="AT_LAYER" Type="Self.AT_LAYER" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AT_SERVICEVERSION">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="AT_LAYER">
              <PropertyRef Name="SERVICEVERSIONID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="LAYERTYPE">
          <End Role="AT_SERVICETYPE_E" Type="Self.AT_SERVICETYPE_E" Multiplicity="1" />
          <End Role="AT_LAYER" Type="Self.AT_LAYER" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AT_SERVICETYPE_E">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="AT_LAYER">
              <PropertyRef Name="SERVICETYPEID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="SERVERTYPEVERSION">
          <End Role="AT_SERVERTYPE_E" Type="Self.AT_SERVERTYPE_E" Multiplicity="1" />
          <End Role="AT_SERVERVERSION_E" Type="Self.AT_SERVERVERSION_E" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AT_SERVERTYPE_E">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="AT_SERVERVERSION_E">
              <PropertyRef Name="SERVERTYPEID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="SERVICESERVERTYPE">
          <End Role="AT_SERVERTYPE_E" Type="Self.AT_SERVERTYPE_E" Multiplicity="1" />
          <End Role="AT_SERVICE" Type="Self.AT_SERVICE" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AT_SERVERTYPE_E">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="AT_SERVICE">
              <PropertyRef Name="SERVERTYPEID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="SERVICESERVERVERTION">
          <End Role="AT_SERVERVERSION_E" Type="Self.AT_SERVERVERSION_E" Multiplicity="1" />
          <End Role="AT_SERVICE" Type="Self.AT_SERVICE" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AT_SERVERVERSION_E">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="AT_SERVICE">
              <PropertyRef Name="SERVERVERSIONID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="AT_SERVICEVERSION_FK1">
          <End Role="AT_SERVICE" Type="Self.AT_SERVICE" Multiplicity="1" />
          <End Role="AT_SERVICEVERSION" Type="Self.AT_SERVICEVERSION" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AT_SERVICE">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="AT_SERVICEVERSION">
              <PropertyRef Name="SERVICEID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="SERVICEAUTHENTICATIONTYPE">
          <End Role="AT_SERVICEAUTHTYPE_E" Type="Self.AT_SERVICEAUTHTYPE_E" Multiplicity="1" />
          <End Role="AT_SERVICEVERSION" Type="Self.AT_SERVICEVERSION" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AT_SERVICEAUTHTYPE_E">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="AT_SERVICEVERSION">
              <PropertyRef Name="AUTHENTICATIONTYPEID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="SERVICEVERSIIONSERVICETYPE">
          <End Role="AT_SERVICETYPE_E" Type="Self.AT_SERVICETYPE_E" Multiplicity="1" />
          <End Role="AT_SERVICEVERSION" Type="Self.AT_SERVICEVERSION" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AT_SERVICETYPE_E">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="AT_SERVICEVERSION">
              <PropertyRef Name="SERVICETYPEID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="AT_SERVICEVERSIONOPERATIO_FK1">
          <End Role="AT_SERVICEVERSION" Type="Self.AT_SERVICEVERSION" Multiplicity="1" />
          <End Role="AT_SERVICEVERSIONOPERATION" Type="Self.AT_SERVICEVERSIONOPERATION" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AT_SERVICEVERSION">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="AT_SERVICEVERSIONOPERATION">
              <PropertyRef Name="SERVICEVERSIONID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="AT_SERVICEVERTILEMATRIX_FK1">
          <End Role="AT_SERVICEVERSION" Type="Self.AT_SERVICEVERSION" Multiplicity="1" />
          <End Role="AT_SERVICEVERSIONTILEMATRIX" Type="Self.AT_SERVICEVERSIONTILEMATRIX" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AT_SERVICEVERSION">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="AT_SERVICEVERSIONTILEMATRIX">
              <PropertyRef Name="SERVICEVERSIONID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="AT_USERROLELAYERRELATION_FK1">
          <End Role="AT_USERLAYERLIST" Type="Self.AT_USERLAYERLIST" Multiplicity="0..1" />
          <End Role="AT_USERROLELAYERRELATION" Type="Self.AT_USERROLELAYERRELATION" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AT_USERLAYERLIST">
              <PropertyRef Name="ID" />
            </Principal>
            <Dependent Role="AT_USERROLELAYERRELATION">
              <PropertyRef Name="USERLAYERLISTID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityContainer Name="Entities" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="AT_LAYER" EntityType="Self.AT_LAYER" />
          <EntitySet Name="AT_SERVERTYPE_E" EntityType="Self.AT_SERVERTYPE_E" />
          <EntitySet Name="AT_SERVERVERSION_E" EntityType="Self.AT_SERVERVERSION_E" />
          <EntitySet Name="AT_SERVICE" EntityType="Self.AT_SERVICE" />
          <EntitySet Name="AT_SERVICEAUTHTYPE_E" EntityType="Self.AT_SERVICEAUTHTYPE_E" />
          <EntitySet Name="AT_SERVICETYPE_E" EntityType="Self.AT_SERVICETYPE_E" />
          <EntitySet Name="AT_SERVICEVERSION" EntityType="Self.AT_SERVICEVERSION" />
          <EntitySet Name="AT_SERVICEVERSIONOPERATION" EntityType="Self.AT_SERVICEVERSIONOPERATION" />
          <EntitySet Name="AT_SERVICEVERSIONTILEMATRIX" EntityType="Self.AT_SERVICEVERSIONTILEMATRIX" />
          <EntitySet Name="AT_USERLAYERLIST" EntityType="Self.AT_USERLAYERLIST" />
          <EntitySet Name="AT_USERROLELAYERRELATION" EntityType="Self.AT_USERROLELAYERRELATION" />
          <AssociationSet Name="AT_LAYER_FK1" Association="Self.AT_LAYER_FK1">
            <End Role="AT_SERVICE" EntitySet="AT_SERVICE" />
            <End Role="AT_LAYER" EntitySet="AT_LAYER" />
          </AssociationSet>
          <AssociationSet Name="AT_USERROLELAYERRELATION_FK4" Association="Self.AT_USERROLELAYERRELATION_FK4">
            <End Role="AT_LAYER" EntitySet="AT_LAYER" />
            <End Role="AT_USERROLELAYERRELATION" EntitySet="AT_USERROLELAYERRELATION" />
          </AssociationSet>
          <AssociationSet Name="LAYERSERVICEVERSION" Association="Self.LAYERSERVICEVERSION">
            <End Role="AT_SERVICEVERSION" EntitySet="AT_SERVICEVERSION" />
            <End Role="AT_LAYER" EntitySet="AT_LAYER" />
          </AssociationSet>
          <AssociationSet Name="LAYERTYPE" Association="Self.LAYERTYPE">
            <End Role="AT_SERVICETYPE_E" EntitySet="AT_SERVICETYPE_E" />
            <End Role="AT_LAYER" EntitySet="AT_LAYER" />
          </AssociationSet>
          <AssociationSet Name="SERVERTYPEVERSION" Association="Self.SERVERTYPEVERSION">
            <End Role="AT_SERVERTYPE_E" EntitySet="AT_SERVERTYPE_E" />
            <End Role="AT_SERVERVERSION_E" EntitySet="AT_SERVERVERSION_E" />
          </AssociationSet>
          <AssociationSet Name="SERVICESERVERTYPE" Association="Self.SERVICESERVERTYPE">
            <End Role="AT_SERVERTYPE_E" EntitySet="AT_SERVERTYPE_E" />
            <End Role="AT_SERVICE" EntitySet="AT_SERVICE" />
          </AssociationSet>
          <AssociationSet Name="SERVICESERVERVERTION" Association="Self.SERVICESERVERVERTION">
            <End Role="AT_SERVERVERSION_E" EntitySet="AT_SERVERVERSION_E" />
            <End Role="AT_SERVICE" EntitySet="AT_SERVICE" />
          </AssociationSet>
          <AssociationSet Name="AT_SERVICEVERSION_FK1" Association="Self.AT_SERVICEVERSION_FK1">
            <End Role="AT_SERVICE" EntitySet="AT_SERVICE" />
            <End Role="AT_SERVICEVERSION" EntitySet="AT_SERVICEVERSION" />
          </AssociationSet>
          <AssociationSet Name="SERVICEAUTHENTICATIONTYPE" Association="Self.SERVICEAUTHENTICATIONTYPE">
            <End Role="AT_SERVICEAUTHTYPE_E" EntitySet="AT_SERVICEAUTHTYPE_E" />
            <End Role="AT_SERVICEVERSION" EntitySet="AT_SERVICEVERSION" />
          </AssociationSet>
          <AssociationSet Name="SERVICEVERSIIONSERVICETYPE" Association="Self.SERVICEVERSIIONSERVICETYPE">
            <End Role="AT_SERVICETYPE_E" EntitySet="AT_SERVICETYPE_E" />
            <End Role="AT_SERVICEVERSION" EntitySet="AT_SERVICEVERSION" />
          </AssociationSet>
          <AssociationSet Name="AT_SERVICEVERSIONOPERATIO_FK1" Association="Self.AT_SERVICEVERSIONOPERATIO_FK1">
            <End Role="AT_SERVICEVERSION" EntitySet="AT_SERVICEVERSION" />
            <End Role="AT_SERVICEVERSIONOPERATION" EntitySet="AT_SERVICEVERSIONOPERATION" />
          </AssociationSet>
          <AssociationSet Name="AT_SERVICEVERTILEMATRIX_FK1" Association="Self.AT_SERVICEVERTILEMATRIX_FK1">
            <End Role="AT_SERVICEVERSION" EntitySet="AT_SERVICEVERSION" />
            <End Role="AT_SERVICEVERSIONTILEMATRIX" EntitySet="AT_SERVICEVERSIONTILEMATRIX" />
          </AssociationSet>
          <AssociationSet Name="AT_USERROLELAYERRELATION_FK1" Association="Self.AT_USERROLELAYERRELATION_FK1">
            <End Role="AT_USERLAYERLIST" EntitySet="AT_USERLAYERLIST" />
            <End Role="AT_USERROLELAYERRELATION" EntitySet="AT_USERROLELAYERRELATION" />
          </AssociationSet>
          <FunctionImport Name="EKON_ISTINFO_CALC_F">
            <Parameter Name="KAYDON" Mode="In" Type="String" />
          </FunctionImport>
          <FunctionImport Name="EKON_TICINFO_CALC_F">
            <Parameter Name="KAYDON" Mode="In" Type="String" />
          </FunctionImport>
          <FunctionImport Name="UPDATESERVICESTATEPRO">
            <Parameter Name="FUPTR" Mode="In" Type="Decimal" />
            <Parameter Name="FSTATEID" Mode="In" Type="Decimal" />
            <Parameter Name="FID" Mode="In" Type="Decimal" />
            <Parameter Name="FIDOUT" Mode="Out" Type="Decimal" />
          </FunctionImport>
        </EntityContainer>
      </Schema>
    </edmx:ConceptualModels>
    <!-- C-S mapping content -->
    <edmx:Mappings>
      <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
        <EntityContainerMapping StorageEntityContainer="ModelStoreContainer" CdmEntityContainer="Entities">
          <EntitySetMapping Name="AT_LAYER">
            <EntityTypeMapping TypeName="Model.AT_LAYER">
              <MappingFragment StoreEntitySet="AT_LAYER">
                <ScalarProperty Name="SYSID" ColumnName="SYSID" />
                <ScalarProperty Name="SERVICEID" ColumnName="SERVICEID" />
                <ScalarProperty Name="CRTR" ColumnName="CRTR" />
                <ScalarProperty Name="CRTM" ColumnName="CRTM" />
                <ScalarProperty Name="UPTM" ColumnName="UPTM" />
                <ScalarProperty Name="UPTR" ColumnName="UPTR" />
                <ScalarProperty Name="DISPLAYNAME" ColumnName="DISPLAYNAME" />
                <ScalarProperty Name="LAYERNAME" ColumnName="LAYERNAME" />
                <ScalarProperty Name="SERVICETYPEID" ColumnName="SERVICETYPEID" />
                <ScalarProperty Name="MINSCALE" ColumnName="MINSCALE" />
                <ScalarProperty Name="MAXSCALE" ColumnName="MAXSCALE" />
                <ScalarProperty Name="XMIN" ColumnName="XMIN" />
                <ScalarProperty Name="XMAX" ColumnName="XMAX" />
                <ScalarProperty Name="YMIN" ColumnName="YMIN" />
                <ScalarProperty Name="YMAX" ColumnName="YMAX" />
                <ScalarProperty Name="LEGANDURL" ColumnName="LEGANDURL" />
                <ScalarProperty Name="LAYERORDER" ColumnName="LAYERORDER" />
                <ScalarProperty Name="CRS" ColumnName="CRS" />
                <ScalarProperty Name="LAYEROPACITY" ColumnName="LAYEROPACITY" />
                <ScalarProperty Name="MATRIXCOUNT" ColumnName="MATRIXCOUNT" />
                <ScalarProperty Name="STATEID" ColumnName="STATEID" />
                <ScalarProperty Name="SERVICEVERSIONID" ColumnName="SERVICEVERSIONID" />
                <ScalarProperty Name="XMAXRES" ColumnName="XMAXRES" />
                <ScalarProperty Name="XMINRES" ColumnName="XMINRES" />
                <ScalarProperty Name="YMAXRES" ColumnName="YMAXRES" />
                <ScalarProperty Name="YMINRES" ColumnName="YMINRES" />
                <ScalarProperty Name="INTERNALLAYERID" ColumnName="INTERNALLAYERID" />
                <ScalarProperty Name="INTERNALSERVICETYPE" ColumnName="INTERNALSERVICETYPE" />
                <ScalarProperty Name="WFSLAYERID" ColumnName="WFSLAYERID" />
                <ScalarProperty Name="DEFAULTCRS" ColumnName="DEFAULTCRS" />
                <ScalarProperty Name="INTERNALSERVICEID" ColumnName="INTERNALSERVICEID" />
                <ScalarProperty Name="LAYERXML" ColumnName="LAYERXML" />
                <ScalarProperty Name="TILEMATRIXSET" ColumnName="TILEMATRIXSET" />
                <ScalarProperty Name="ID" ColumnName="ID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="AT_SERVERTYPE_E">
            <EntityTypeMapping TypeName="Model.AT_SERVERTYPE_E">
              <MappingFragment StoreEntitySet="AT_SERVERTYPE_E">
                <ScalarProperty Name="ID" ColumnName="ID" />
                <ScalarProperty Name="CRTR" ColumnName="CRTR" />
                <ScalarProperty Name="CRTM" ColumnName="CRTM" />
                <ScalarProperty Name="UPTM" ColumnName="UPTM" />
                <ScalarProperty Name="UPTR" ColumnName="UPTR" />
                <ScalarProperty Name="NAME" ColumnName="NAME" />
                <ScalarProperty Name="DSCR" ColumnName="DSCR" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="AT_SERVERVERSION_E">
            <EntityTypeMapping TypeName="Model.AT_SERVERVERSION_E">
              <MappingFragment StoreEntitySet="AT_SERVERVERSION_E">
                <ScalarProperty Name="ID" ColumnName="ID" />
                <ScalarProperty Name="CRTR" ColumnName="CRTR" />
                <ScalarProperty Name="CRTM" ColumnName="CRTM" />
                <ScalarProperty Name="UPTM" ColumnName="UPTM" />
                <ScalarProperty Name="UPTR" ColumnName="UPTR" />
                <ScalarProperty Name="VERSION" ColumnName="VERSION" />
                <ScalarProperty Name="DSCR" ColumnName="DSCR" />
                <ScalarProperty Name="SERVERTYPEID" ColumnName="SERVERTYPEID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="AT_SERVICE">
            <EntityTypeMapping TypeName="Model.AT_SERVICE">
              <MappingFragment StoreEntitySet="AT_SERVICE">
                <ScalarProperty Name="ID" ColumnName="ID" />
                <ScalarProperty Name="SYSID" ColumnName="SYSID" />
                <ScalarProperty Name="NAME" ColumnName="NAME" />
                <ScalarProperty Name="CRTR" ColumnName="CRTR" />
                <ScalarProperty Name="CRTM" ColumnName="CRTM" />
                <ScalarProperty Name="UPTM" ColumnName="UPTM" />
                <ScalarProperty Name="UPTR" ColumnName="UPTR" />
                <ScalarProperty Name="INSTITUTIONID" ColumnName="INSTITUTIONID" />
                <ScalarProperty Name="STATEID" ColumnName="STATEID" />
                <ScalarProperty Name="SERVERTYPEID" ColumnName="SERVERTYPEID" />
                <ScalarProperty Name="SERVERVERSIONID" ColumnName="SERVERVERSIONID" />
                <ScalarProperty Name="ISINTERNAL" ColumnName="ISINTERNAL" />
                <ScalarProperty Name="INTERNALSYSID" ColumnName="INTERNALSYSID" />
                <ScalarProperty Name="INTERNALSERVICEID" ColumnName="INTERNALSERVICEID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="AT_SERVICEAUTHTYPE_E">
            <EntityTypeMapping TypeName="Model.AT_SERVICEAUTHTYPE_E">
              <MappingFragment StoreEntitySet="AT_SERVICEAUTHTYPE_E">
                <ScalarProperty Name="ID" ColumnName="ID" />
                <ScalarProperty Name="NAME" ColumnName="NAME" />
                <ScalarProperty Name="DSCR" ColumnName="DSCR" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="AT_SERVICETYPE_E">
            <EntityTypeMapping TypeName="Model.AT_SERVICETYPE_E">
              <MappingFragment StoreEntitySet="AT_SERVICETYPE_E">
                <ScalarProperty Name="ID" ColumnName="ID" />
                <ScalarProperty Name="CRTR" ColumnName="CRTR" />
                <ScalarProperty Name="CRTM" ColumnName="CRTM" />
                <ScalarProperty Name="UPTM" ColumnName="UPTM" />
                <ScalarProperty Name="UPTR" ColumnName="UPTR" />
                <ScalarProperty Name="NAME" ColumnName="NAME" />
                <ScalarProperty Name="DSCR" ColumnName="DSCR" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="AT_SERVICEVERSION">
            <EntityTypeMapping TypeName="Model.AT_SERVICEVERSION">
              <MappingFragment StoreEntitySet="AT_SERVICEVERSION">
                <ScalarProperty Name="SERVICEID" ColumnName="SERVICEID" />
                <ScalarProperty Name="VERSION" ColumnName="VERSION" />
                <ScalarProperty Name="CRTR" ColumnName="CRTR" />
                <ScalarProperty Name="CRTM" ColumnName="CRTM" />
                <ScalarProperty Name="UPTM" ColumnName="UPTM" />
                <ScalarProperty Name="UPTR" ColumnName="UPTR" />
                <ScalarProperty Name="SYSID" ColumnName="SYSID" />
                <ScalarProperty Name="SERVICETYPEID" ColumnName="SERVICETYPEID" />
                <ScalarProperty Name="URL" ColumnName="URL" />
                <ScalarProperty Name="USERNAME" ColumnName="USERNAME" />
                <ScalarProperty Name="PASSWORD" ColumnName="PASSWORD" />
                <ScalarProperty Name="ISSECURE" ColumnName="ISSECURE" />
                <ScalarProperty Name="TOKEN" ColumnName="TOKEN" />
                <ScalarProperty Name="AUTHENTICATIONTYPEID" ColumnName="AUTHENTICATIONTYPEID" />
                <ScalarProperty Name="ISDEFAULT" ColumnName="ISDEFAULT" />
                <ScalarProperty Name="MAXWIDTH" ColumnName="MAXWIDTH" />
                <ScalarProperty Name="MAXHEIGHT" ColumnName="MAXHEIGHT" />
                <ScalarProperty Name="DSCR" ColumnName="DSCR" />
                <ScalarProperty Name="CLIENTID" ColumnName="CLIENTID" />
                <ScalarProperty Name="CLIENTSECRET" ColumnName="CLIENTSECRET" />
                <ScalarProperty Name="AUTHENTICATIONURL" ColumnName="AUTHENTICATIONURL" />
                <ScalarProperty Name="TOKENEXPIRATIONDATE" ColumnName="TOKENEXPIRATIONDATE" />
                <ScalarProperty Name="OLDATLASUSERNAME" ColumnName="OLDATLASUSERNAME" />
                <ScalarProperty Name="OLDATLASPASSWORD" ColumnName="OLDATLASPASSWORD" />
                <ScalarProperty Name="PROCEEDACCORDINGCAPABILITIES" ColumnName="PROCEEDACCORDINGCAPABILITIES" />
                <ScalarProperty Name="ACCESSLEVEL" ColumnName="ACCESSLEVEL" />
                <ScalarProperty Name="FORCEALLLAYER" ColumnName="FORCEALLLAYER" />
                <ScalarProperty Name="ID" ColumnName="ID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="AT_SERVICEVERSIONOPERATION">
            <EntityTypeMapping TypeName="Model.AT_SERVICEVERSIONOPERATION">
              <MappingFragment StoreEntitySet="AT_SERVICEVERSIONOPERATION">
                <ScalarProperty Name="SERVICEVERSIONID" ColumnName="SERVICEVERSIONID" />
                <ScalarProperty Name="NAME" ColumnName="NAME" />
                <ScalarProperty Name="GETURL" ColumnName="GETURL" />
                <ScalarProperty Name="POSTURL" ColumnName="POSTURL" />
                <ScalarProperty Name="CRTM" ColumnName="CRTM" />
                <ScalarProperty Name="CRTR" ColumnName="CRTR" />
                <ScalarProperty Name="UPTM" ColumnName="UPTM" />
                <ScalarProperty Name="UPTR" ColumnName="UPTR" />
                <ScalarProperty Name="FORMATLIST" ColumnName="FORMATLIST" />
                <ScalarProperty Name="ID" ColumnName="ID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="AT_SERVICEVERSIONTILEMATRIX">
            <EntityTypeMapping TypeName="Model.AT_SERVICEVERSIONTILEMATRIX">
              <MappingFragment StoreEntitySet="AT_SERVICEVERSIONTILEMATRIX">
                <ScalarProperty Name="SERVICEVERSIONID" ColumnName="SERVICEVERSIONID" />
                <ScalarProperty Name="NAME" ColumnName="NAME" />
                <ScalarProperty Name="DSCR" ColumnName="DSCR" />
                <ScalarProperty Name="CRS" ColumnName="CRS" />
                <ScalarProperty Name="WELLKNOWNSCALESET" ColumnName="WELLKNOWNSCALESET" />
                <ScalarProperty Name="MATRIXCOUNT" ColumnName="MATRIXCOUNT" />
                <ScalarProperty Name="TILEWIDTH" ColumnName="TILEWIDTH" />
                <ScalarProperty Name="TILEHEIGHT" ColumnName="TILEHEIGHT" />
                <ScalarProperty Name="ID" ColumnName="ID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="AT_USERLAYERLIST">
            <EntityTypeMapping TypeName="Model.AT_USERLAYERLIST">
              <MappingFragment StoreEntitySet="AT_USERLAYERLIST">
                <ScalarProperty Name="ID" ColumnName="ID" />
                <ScalarProperty Name="NAME" ColumnName="NAME" />
                <ScalarProperty Name="DSCR" ColumnName="DSCR" />
                <ScalarProperty Name="CRTM" ColumnName="CRTM" />
                <ScalarProperty Name="CRTR" ColumnName="CRTR" />
                <ScalarProperty Name="UPTM" ColumnName="UPTM" />
                <ScalarProperty Name="UPTR" ColumnName="UPTR" />
                <ScalarProperty Name="SYSID" ColumnName="SYSID" />
                <ScalarProperty Name="USERID" ColumnName="USERID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="AT_USERROLELAYERRELATION">
            <EntityTypeMapping TypeName="Model.AT_USERROLELAYERRELATION">
              <MappingFragment StoreEntitySet="AT_USERROLELAYERRELATION">
                <ScalarProperty Name="ID" ColumnName="ID" />
                <ScalarProperty Name="SYSID" ColumnName="SYSID" />
                <ScalarProperty Name="CRTM" ColumnName="CRTM" />
                <ScalarProperty Name="CRTR" ColumnName="CRTR" />
                <ScalarProperty Name="USERID" ColumnName="USERID" />
                <ScalarProperty Name="ROLEID" ColumnName="ROLEID" />
                <ScalarProperty Name="LAYERID" ColumnName="LAYERID" />
                <ScalarProperty Name="SERVICEVERSIONID" ColumnName="SERVICEVERSIONID" />
                <ScalarProperty Name="DISPLAYNAME" ColumnName="DISPLAYNAME" />
                <ScalarProperty Name="URL" ColumnName="URL" />
                <ScalarProperty Name="ROWNUMBER" ColumnName="ROWNUMBER" />
                <ScalarProperty Name="PARENTROWNUMBER" ColumnName="PARENTROWNUMBER" />
                <ScalarProperty Name="ISEXTERNAL" ColumnName="ISEXTERNAL" />
                <ScalarProperty Name="WFSWRITE" ColumnName="WFSWRITE" />
                <ScalarProperty Name="BASICAUTHUSERNAME" ColumnName="BASICAUTHUSERNAME" />
                <ScalarProperty Name="BASICAUTHPASSWORD" ColumnName="BASICAUTHPASSWORD" />
                <ScalarProperty Name="VERSION" ColumnName="VERSION" />
                <ScalarProperty Name="SERVICETYPE" ColumnName="SERVICETYPE" />
                <ScalarProperty Name="LAYERNAME" ColumnName="LAYERNAME" />
                <ScalarProperty Name="XMIN" ColumnName="XMIN" />
                <ScalarProperty Name="XMAX" ColumnName="XMAX" />
                <ScalarProperty Name="YMIN" ColumnName="YMIN" />
                <ScalarProperty Name="YMAX" ColumnName="YMAX" />
                <ScalarProperty Name="XMAXRES" ColumnName="XMAXRES" />
                <ScalarProperty Name="XMINRES" ColumnName="XMINRES" />
                <ScalarProperty Name="YMAXRES" ColumnName="YMAXRES" />
                <ScalarProperty Name="YMINRES" ColumnName="YMINRES" />
                <ScalarProperty Name="LEGANDURL" ColumnName="LEGANDURL" />
                <ScalarProperty Name="APIKEY" ColumnName="APIKEY" />
                <ScalarProperty Name="TOKEN" ColumnName="TOKEN" />
                <ScalarProperty Name="USERLAYERLISTID" ColumnName="USERLAYERLISTID" />
                <ScalarProperty Name="MINSCALE" ColumnName="MINSCALE" />
                <ScalarProperty Name="MAXSCALE" ColumnName="MAXSCALE" />
                <ScalarProperty Name="MATRIXCOUNT" ColumnName="MATRIXCOUNT" />
                <ScalarProperty Name="LAYEROPACITY" ColumnName="LAYEROPACITY" />
                <ScalarProperty Name="CRS" ColumnName="CRS" />
                <ScalarProperty Name="LAYERORDER" ColumnName="LAYERORDER" />
                <ScalarProperty Name="SLD" ColumnName="SLD" />
                <ScalarProperty Name="DEFAULTCRS" ColumnName="DEFAULTCRS" />
                <ScalarProperty Name="TRANSACTIONID" ColumnName="TRANSACTIONID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <FunctionImportMapping FunctionImportName="EKON_ISTINFO_CALC_F" FunctionName="Model.Store.EKON_ISTINFO_CALC_F" />
          <FunctionImportMapping FunctionImportName="EKON_TICINFO_CALC_F" FunctionName="Model.Store.EKON_TICINFO_CALC_F" />
          <FunctionImportMapping FunctionImportName="UPDATESERVICESTATEPRO" FunctionName="Model.Store.UPDATESERVICESTATEPRO" />
        </EntityContainerMapping>
      </Mapping>
    </edmx:Mappings>
  </edmx:Runtime>
  <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
    <Connection>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
      </DesignerInfoPropertySet>
    </Connection>
    <Options>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="ValidateOnBuild" Value="true" />
        <DesignerProperty Name="EnablePluralization" Value="false" />
        <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
        <DesignerProperty Name="UseLegacyProvider" Value="true" />
        <DesignerProperty Name="CodeGenerationStrategy" Value="None" />
      </DesignerInfoPropertySet>
    </Options>
    <!-- Diagram content (shape and connector positions) -->
    <Diagrams></Diagrams>
  </Designer>
</edmx:Edmx>

Further technical details

EF version: 6.0.0.0 Database Provider:Oracle.ManagedDataAccess.Client Operating system:Windows 10 IDE:Visual Studio 2015

ajcvickers commented 5 years ago

This is an issue with the Oracle provider for EF6. Please follow up with Oracle.