Current filter:
                                You should refresh the page.
                                  • This article is now obsolete. In v19.2, Entity Server Mode collections automatically detect the Entity Framework version and use appropriate EntityFuncitons and SqlFunctions.


                                    The information below is applicable for v19.1 and earlier versions.

                                    Some breaking changes introduced in Entity Framework 6.0 caused compatibility issues with Entity Framework Server Mode collections (EntityServerModeSource, EntityInstantFeedbackSource). This is the list of limitations.

                                    1. Filtering via the Auto Filter Row against numeric columns is not supported.
                                    2. Searching via the Find Panel against numeric columns is not supported.
                                    3. Incremental searching against numeric columns is not supported.
                                    4. The following column group intervals are not supported:
                                    * Date
                                    * DateMonth
                                    * DateRange
                                    * DateYear
                                    * Default (for DateTime columns)
                                    5. A numeric column as display member of the look-up editor is not supported.
                                    6. The following function operators are not supported in filters and unbound columns.
                                    * ToStr (if the parameter is an operand property referencing a numeric column)
                                    * AddDays
                                    * AddHours
                                    * AddMilliSeconds
                                    * AddMinutes
                                    * AddMonths
                                    * AddSeconds
                                    * AddYears
                                    * DateDiffDay
                                    * DateDiffHour
                                    * DateDiffMilliSecond
                                    * DateDiffMinute
                                    * DateDiffMonth
                                    * DateDiffSecond
                                    * DateDiffYear
                                    * GetDate
                                    7. The Like operation is not supported.
                                    Is there any workaround for this issue?

                                    Answer:
                                    We introduced a new feature that allows you to specify classes which will be used by our library to get methods that call functions in the database.

                                    In Entity Framework 6.0 these classes are:
                                    System.Data.Entity.Core.Objects.EntityFunctions
                                    System.Data.Entity.SqlServer.SqlFunctions

                                    [C#]
                                    DevExpress.Data.Linq.CriteriaToEFExpressionConverter.EntityFunctionsType = typeof(System.Data.Entity.Core.Objects.EntityFunctions); DevExpress.Data.Linq.CriteriaToEFExpressionConverter.SqlFunctionsType = typeof(System.Data.Entity.SqlServer.SqlFunctions);

                                    In Entity Framework 6.1+ the System.Data.Entity.Core.Objects.EntityFunctions is obsolete, and the System.Data.Entity.DbFunctions class should be used.

                                    [C#]
                                    DevExpress.Data.Linq.CriteriaToEFExpressionConverter.EntityFunctionsType = typeof(System.Data.Entity.DbFunctions); DevExpress.Data.Linq.CriteriaToEFExpressionConverter.SqlFunctionsType = typeof(System.Data.Entity.SqlServer.SqlFunctions);

                                    In Entity Framework Core 2.1+ only the Microsoft.EntityFrameworkCore.SqlServerDbFunctionsExtensions class should be used.

                                    [C#]
                                    DevExpress.Data.Linq.CriteriaToEFExpressionConverter.EntityFunctionsType = typeof(Microsoft.EntityFrameworkCore.SqlServerDbFunctionsExtensions);

                                    If you experience issues listed in the description to this article, execute the code above in your application's entry point. This will resolve problems caused by this limitation.
                                    The feature is included in the latest versions of DevExpress .NET libraries:
                                    v2014 vol 1.3
                                    v2013 vol 2.10

                                Show all comments
                                • Christian Peters 07.02.2014

                                  Hi Uriah,
                                  I just checked your solution with our system (EF 6.1.1).
                                  So far no problems.
                                  As soon as I find something I'll write it down here.
                                  'til then - How is yor progress so far to get things up and running without this workaround?
                                  Chris

                                • Uriah (DevExpress Support) 07.03.2014

                                  Hi Chris,
                                  At the moment, we cannot provide the estimated time frame. We will do our best to find a better solution as soon as possible.

                                • MCap 01.11.2015

                                  Any more word as to when ef 6.1 will be officially supported?

                                • Uriah (DevExpress Support) 01.12.2015

                                  Hello,

                                  We are working on the feature, but at the moment we cannot provide the date when our work is finished.

                                  I have created a separate ticket on your behalf to discuss a temporary workaround we provided: T195141: When Server Mode will support Entity Framework 6.1. This ticket is currently in our processing queue. Our team will address it as soon as we have any updates.

                                • budi bong 06.28.2015

                                  Hi Uriah,
                                  What version of DevExpress that support EF 6+ ?
                                  Currently I am using DevExpress v13.1 , is it support EF 6+ ? Thanks

                                • Uriah (DevExpress Support) 06.28.2015

                                  Hi Budi,

                                  The feature was included in the following versions of DevExpress .NET libraries:
                                  v2014 vol 1.3
                                  v2013 vol 2.10

                                • Sam Storino 01.27.2016

                                  Hello - is there a progress update for this ticket?
                                  Thanks!

                                • Uriah (DevExpress Support) 01.28.2016

                                  Hello Sam,

                                  This ticket is closed, as the solution was provided. I see that you submitted a separate ticket describing the issue you are experiencing: GridView - DateRangePicker doesn't work correctly when the BindToEF method is used. From what I gather, my colleagues helped you. Please let me know if you need any further assistance.

                                0 Solutions

                                Creation Date Importance Sort by