1. Home
  2. Forum
  3. ASP.NET Core - EJ 2
  4. Grid with Iqueryable on Complex Data Binding with EF core

Grid with Iqueryable on Complex Data Binding with EF core

I have been trying to get filtering, sorting, and searching working on Grids with complex databinding (having the dot operator). I have found several questions that have similar questions such as:

In these quests and others that have been asked the answer is usually:

            services.AddControllersWithViews().AddNewtonsoftJson(options =>

            {

                  options.SerializerSettings.ContractResolver = new DefaultContractResolver();

                  options.SerializerSettings.ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore;

             });

Which I have and does not fix my problem.

When I try and search and filter I get:
            "Object reference not set to an instance of an object."

When I try and sort I get:

             The LINQ expression 'DbSet()

                      .Include(m => m.MessageType)

                      .Include(m => m.Incident)

                      .Include(m => m.Person)

                      .Include(m => m.OffenseCode)

                      .Select((a, i) => new {

                          a = a,

                          TempData = __ToList_0.get_Item(i)

                      })' could not be translated.

This is similar to the first question. All test projects listed are never attached to any external resources. I believe the problem is how Entityframework Core and syncfusion are interacting.

Attached is a bare bones project I made that has a grid data with complex data binding. The project will create a database and seed it will test data (DataContext and Seed). However, it attempts to do this on SQL Server Express, so the computer that it is run on will need SQL Server Express.

Attachment: SyncfusionComplexBinding_c02cbfd0.zip


14 Replies
RS Rajapandiyan Settu Syncfusion Team December 17, 2021 02:27 PM UTC

Hi Eric Petersen, 
 
Thanks for contacting Syncfusion support. 
 
Currently, we are checking reported query “I have been trying to get filtering, sorting, and searching working on Grids with complex databinding (having the dot operator)” at our end. So, we will update the further details on Dec 21st, 2021. 
 
We appreciate your patience until then. 
 
Regards, 
Rajapandiyan S 


RR Rajapandi Ravi Syncfusion Team December 21, 2021 12:52 PM UTC

Hi Eric, 

We have checked your attached sample and try to reproduce your reported problem, but your application was not running properly at our end and also the data was not binded to the Grid. Please refer the below screenshot for more information. 

Screenshot: 

 

Before we start providing solution on your query, Please share the working sample that will be helpful for us to validate. 

Rajapandi R 



EP Eric Petersen December 27, 2021 05:23 PM UTC

It looks like it can't connect to the SQL server express. Was SQL server express on the machine and did it create the database?



Did you get an exception in program.cs? There would normally be a logger here, but I wanted to keep the project as small as possible.

If so, there should be a database on the SQL server express with this database and tables.



RR Rajapandi Ravi Syncfusion Team December 29, 2021 01:41 AM UTC

Hi Eric, 

Thanks for the update 

Currently, we are working on this query, and we will update you the details on Thursday 30th Dec 2021. Until then we appreciate your patience. 

Rajapandi R 


RR Rajapandi Ravi Syncfusion Team December 30, 2021 11:55 AM UTC

Hi Eric, 

We are able to run your application and we can reproduce your reported problem at our end. Currently, we are validating the problem and we will update you the details on Tuesday, 4th Jan 2022. Until then we appreciate your patience. 

Rajapandi R 


RR Rajapandi Ravi Syncfusion Team January 5, 2022 12:48 PM UTC

Hi Eric,  

We are able to reproduce your reported problem at our end and we have forwarded your query to our internal team, and we need some more time to validate. So, we will update you the details on or before 11th Jan 2022. Until then we appreciate your patience.  

Regards,  
Rajapandi R 


RR Rajapandi Ravi Syncfusion Team January 11, 2022 01:53 PM UTC

Hi Eric, 

Thanks for your patience 

After validating further with the source, we have confirmed and logged this as a bug in the component. So, we have considered "Filtering, Sorting & searching was not working properly with complex data-binding” as a defect and logged a report for the same. We will include the defect fix in our upcoming Feb 2nd, 2022, patch release. 

You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link. 


Regards, 
Rajapandi R 


EP Eric Petersen January 18, 2022 04:52 PM UTC

Thanks, I look forward to seeing the changes.


RR Rajapandi Ravi Syncfusion Team January 19, 2022 04:21 AM UTC

Hi Eric, 

Thankyou. Currently we are working on it, and we will update you details as we promised. 

Regards, 
Rajapandi R 


RS Rajapandiyan Settu Syncfusion Team February 3, 2022 11:04 AM UTC

Hi Eric,  
  
Sorry for the inconvenience caused. 

Due to our 2021 Volume 4 SP release, we have not rolled out the weekly patch release. We will include the fix for this bug (“Filtering, Sorting & searching was not working properly with complex data-binding”) in our next patch release which is expected to be roll out on Feb 9th 2022. 

We appreciate your patience until then. 

Regards, 
Rajapandiyan S 


RR Rajapandi Ravi Syncfusion Team February 10, 2022 12:42 PM UTC

Hi Eric,   
   
Sorry for the inconvenience caused.  

We have fixed the issue internally, But due to some unforeseen circumstances, the fix of this issue (“Filtering, Sorting & searching was not working properly with complex data-binding”) was not included in our weekly patch release. Currently, we are working on this with high priority and will include the fix in our next weekly release Feb 16th, 2022. 
    
We will update you once the fix is rolled out. Until then, we appreciate your patience.   

Rajapandi R 


RR Rajapandi Ravi Syncfusion Team February 16, 2022 03:08 PM UTC

Hi Eric, 

We are glad to announce that our Essential Javascript2 patch release (v19.4.52) has been rolled out successfully and in that release, we have added the fix for the issue - “Filtering, Sorting & searching was not working properly with complex data-binding”. So please update your packages to this version to include this fix. 


We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance. 

Regards, 
Rajapandi R 


EP Eric Petersen March 9, 2022 12:01 AM UTC

The update fixed the problem for us. Thanks.


RR Rajapandi Ravi Syncfusion Team March 9, 2022 04:31 AM UTC

Hi Eric, 

We are happy to hear that the provided fix resolved your reported problem. 

Please get back to us if you need further assistance. 

Rajapandi R 


Loader.
Up arrow icon