Server Error in '/' Application.

Incorrect syntax near 'S'.
Unclosed quotation mark after the character string ' AS Value) Genders ON I.gender = Genders.Value
               WHERE
                   I.gender IS NOT NULL
               ORDER BY
                   Genders.DisplayText

               SELECT DISTINCT
                   I.MaterialTypeFull as DisplayText,
                   I.MaterialTypeFull as Value
               FROM
                   #FilteredFrames F INNER JOIN dbo.inventory I ON F.sku = I.sku
               WHERE
                   I.MaterialTypeFull IS NOT NULL
               ORDER BY
                   I.MaterialTypeFull

               SELECT DISTINCT
                   I.FrameShape AS DisplayText,
                   I.FrameShape AS Value
               FROM
                   #FilteredFrames F INNER JOIN dbo.inventory I ON F.sku = I.sku
               WHERE
                   I.FrameShape IS NOT NULL
               ORDER BY
                   I.FrameShape

               SELECT DISTINCT
                   I.ColorGroup AS DisplayText,
                   I.ColorGroup AS Value
               FROM
                   #FilteredFrames F INNER JOIN dbo.inventory I ON F.sku = I.sku
               WHERE
                   I.ColorGroup IS NOT NULL
               ORDER BY
                   I.ColorGroup

               SELECT DISTINCT
                   C.Collection_Code AS DisplayText,
                   I.coll_group AS Value
               FROM
                   #FilteredFrames F INNER JOIN dbo.inventory I ON F.sku = I.sku
                   INNER JOIN dbo.Collection C ON C.coll_group = I.coll_group
               WHERE
                   C.[Enabled] = 1
               ORDER BY
                   C.Collection_Code

               SELECT
                   COALESCE(MIN(EyeMeasurements_Eye), 0)
               FROM
                   #FilteredFrames F INNER JOIN dbo.inventory I ON F.sku = I.sku
               WHERE
                   EyeMeasurements_Eye IS NOT...

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near 'S'.
Unclosed quotation mark after the character string ' AS Value) Genders ON I.gender = Genders.Value
               WHERE
                   I.gender IS NOT NULL
               ORDER BY
                   Genders.DisplayText

               SELECT DISTINCT
                   I.MaterialTypeFull as DisplayText,
                   I.MaterialTypeFull as Value
               FROM
                   #FilteredFrames F INNER JOIN dbo.inventory I ON F.sku = I.sku
               WHERE
                   I.MaterialTypeFull IS NOT NULL
               ORDER BY
                   I.MaterialTypeFull

               SELECT DISTINCT
                   I.FrameShape AS DisplayText,
                   I.FrameShape AS Value
               FROM
                   #FilteredFrames F INNER JOIN dbo.inventory I ON F.sku = I.sku
               WHERE
                   I.FrameShape IS NOT NULL
               ORDER BY
                   I.FrameShape

               SELECT DISTINCT
                   I.ColorGroup AS DisplayText,
                   I.ColorGroup AS Value
               FROM
                   #FilteredFrames F INNER JOIN dbo.inventory I ON F.sku = I.sku
               WHERE
                   I.ColorGroup IS NOT NULL
               ORDER BY
                   I.ColorGroup

               SELECT DISTINCT
                   C.Collection_Code AS DisplayText,
                   I.coll_group AS Value
               FROM
                   #FilteredFrames F INNER JOIN dbo.inventory I ON F.sku = I.sku
                   INNER JOIN dbo.Collection C ON C.coll_group = I.coll_group
               WHERE
                   C.[Enabled] = 1
               ORDER BY
                   C.Collection_Code

               SELECT
                   COALESCE(MIN(EyeMeasurements_Eye), 0)
               FROM
                   #FilteredFrames F INNER JOIN dbo.inventory I ON F.sku = I.sku
               WHERE
                   EyeMeasurements_Eye IS NOT...

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException (0x80131904): Incorrect syntax near 'S'.
Unclosed quotation mark after the character string ' AS Value) Genders ON I.gender = Genders.Value
                WHERE
                    I.gender IS NOT NULL
                ORDER BY
                    Genders.DisplayText

                SELECT DISTINCT
                    I.MaterialTypeFull as DisplayText,
                    I.MaterialTypeFull as Value
                FROM
                    #FilteredFrames F INNER JOIN dbo.inventory I ON F.sku = I.sku
                WHERE
                    I.MaterialTypeFull IS NOT NULL
                ORDER BY
                    I.MaterialTypeFull

                SELECT DISTINCT
                    I.FrameShape AS DisplayText,
                    I.FrameShape AS Value
                FROM
                    #FilteredFrames F INNER JOIN dbo.inventory I ON F.sku = I.sku
                WHERE
                    I.FrameShape IS NOT NULL
                ORDER BY
                    I.FrameShape

                SELECT DISTINCT
                    I.ColorGroup AS DisplayText,
                    I.ColorGroup AS Value
                FROM
                    #FilteredFrames F INNER JOIN dbo.inventory I ON F.sku = I.sku
                WHERE
                    I.ColorGroup IS NOT NULL
                ORDER BY
                    I.ColorGroup

                SELECT DISTINCT
                    C.Collection_Code AS DisplayText,
                    I.coll_group AS Value
                FROM
                    #FilteredFrames F INNER JOIN dbo.inventory I ON F.sku = I.sku
                    INNER JOIN dbo.Collection C ON C.coll_group = I.coll_group
                WHERE
                    C.[Enabled] = 1
                ORDER BY
                    C.Collection_Code

                SELECT
                    COALESCE(MIN(EyeMeasurements_Eye), 0)
                FROM
                    #FilteredFrames F INNER JOIN dbo.inventory I ON F.sku = I.sku
                WHERE
                    EyeMeasurements_Eye IS NOT...]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +277
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +765
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4616
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +88
   System.Data.SqlClient.SqlDataReader.get_MetaData() +103
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +621
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +3382
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +707
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +83
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +302
   Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior) +63
   Dapper.SqlMapper.QueryMultipleImpl(IDbConnection cnn, CommandDefinition& command) +739
   Dapper.SqlMapper.QueryMultiple(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType) +123
   Kenmark_Consumer.Models.Collections.GetSearchFilterOptions(List`1 brands, List`1 colors, List`1 genders, List`1 materials, List`1 shapes, String collectionName, String collectionAttribute) in C:\BuildAgent\work\80365974eab54db3\Kenmark-Consumer\Models\Collections.cs:637
   Kenmark_Consumer.Controllers.CollectionController.ViewCollection(List`1 brands, List`1 colors, List`1 genders, List`1 materials, List`1 shapes, String brandName, String collectionName, String collectionGroup, String collectionAttribute, Int32 eyeSizeMin, Int32 eyeSizeMax, Int32 page, Int32 sort, Filters filter, Boolean isViewAll) in C:\BuildAgent\work\80365974eab54db3\Kenmark-Consumer\Controllers\CollectionController.cs:87
   lambda_method(Closure , ControllerBase , Object[] ) +1349
   System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +35
   System.Web.Mvc.Async.<>c.<BeginInvokeSynchronousActionMethod>b__9_0(IAsyncResult asyncResult, ActionInvocation innerInvokeState) +39
   System.Web.Mvc.Async.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult) +77
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult) +42
   System.Web.Mvc.Async.<>c__DisplayClass11_0.<InvokeActionMethodFilterAsynchronouslyRecursive>b__0() +80
   System.Web.Mvc.Async.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2() +396
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) +42
   System.Web.Mvc.Async.<>c__DisplayClass3_6.<BeginInvokeAction>b__4() +42
   System.Web.Mvc.Async.<>c__DisplayClass3_1.<BeginInvokeAction>b__1(IAsyncResult asyncResult) +188
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) +38
   System.Web.Mvc.<>c.<BeginExecuteCore>b__152_1(IAsyncResult asyncResult, ExecuteCoreState innerState) +29
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +73
   System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +52
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +39
   System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) +38
   System.Web.Mvc.<>c.<BeginProcessRequest>b__20_1(IAsyncResult asyncResult, ProcessRequestState innerState) +43
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +73
   System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +38
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +651
   System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +220
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +134


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4690.0