Cannot bind data control so it displays changes in EF objects

[Mariusz Juszkiewicz]

I am having a problem with an application to display data that I manully add to EF classes and save it in the database. They just do not show up.

I am using ObservableCollection which shudl tell the datagrid that the changes happened.

Attachment: BlackBookWPFCore_df5b37e9.zip

[Vijayarasan Sivanandham]

Hi Mariusz Juszkiewicz, 

 

Thank you for contacting Syncfusion support. 

 

We have tried to run the demo application share by you. But we are facing below issue 

 

 

 

Could you please revert us with SQL Server database file? It will help us to investigate further and provide you earlier prompt solution. 

 

Regards,   

Vijayarasan S   

[Mariusz Juszkiewicz]

Vijayarasan,

You need to set connection string to your SQL server application will generate the database by itself. Connection string is in file MainFormContext.cs.

@"Server=.;Database=BlackBookEPFCore;Trusted_Connection=True;MultipleActiveResultSets=True;App=BlackBookEPFCore";

it is set to default database so it should work on any machine with SQL server on it. I am using Visual Studio Community 2019 version 16.4.4

If you have difficulty setting this up let me know. I have attached a backup copy of the database.

MJ

Attachment: BlackBookEPFCore_aaa36697.zip

[Muthu Kumaran Gnanavinayagam]

Hi Mariusz, 

 

Currently we are validating the reported query at our end and will update further details on or before 25^th February, 2020. We will highly appreciate your patience until then. 

 

Regars, 

G.Muthu kumaran. 

[Vijayarasan Sivanandham]

Hi Mariusz Juszkiewicz, 

Thank you for your patience. 

Currently we are configuring the attached application from our side and we will update further details on or before 28^th February 2020. We sincerely apology for the delay. 

Regards, 

Vijayarasan S   

[Vijayarasan Sivanandham]

Hi Mariusz Juszkiewicz,

We configured your sample at our end and we have execute the sample and add the data in SfDataGrid. Its works as expected there is not error occurs. Please find the tested video demo from our end in the below link,

Video Link: https://www.syncfusion.com/downloads/support/forum/151646/ze/BlackBookWPF-1323860583

If still you are facing the same issue, can you please share us below things? 

1. Brief replication procedure/video illustration of the reported issue

Please let us know, if you need any further assistance on this.

Regards,
Vijayarasan S 

[Mariusz Juszkiewicz]

Yes thank you. I should have been more descriptive in my request.

I can add data no problem allthough there is one glich which I will come back.

First, in the pannel above grid there is a button with which I was testing adding a new row of data directly to EF.

When I click on it data is added to the database, however, it does not show up in the data grid.

This is my problem it does not recogize that there new record in the EF and update the grid.

Second.  Proposal ID is autonumber, evetually I was planning to hide it from the user view because it is assigned value from the database.

It is not manual entry. If you enter let say 999 for Proposal ID database will overwright it with next sequencial number and not use the 999 number.

Datagrid should notice that change through EF and update ID accordingly.

Hope I have explained my dillema. Thank you. MJ

[Vijayarasan Sivanandham]

Hi Mariusz Juszkiewicz, 

Please find answers for your queries below 

Queries	Answers
Data is added to the database but does not show up in the data grid.	We have analyzed your query that “Data is added to the database but does not show up in the SfDataGrid". Since, in your application, you maintain the SfDataGrid item source as list collection. List collection does not contain the collection changed event. So, it does not show the data in SfDataGrid. Your requirement can be achieved  by SQL Dependency Nuget and please refer the following link,                      https://dzone.com/articles/introduction-to-mysql-1                       https://www.nuget.org/packages/SqlTableDependency/
Proposal ID database will overwright it with next sequencial number	In manual entry of proposal Id should be validating by the SfDataGrid.RowValidating Event to cancel the editing value in SfDataGrid. Please refer the below user guide document for your reference, UG Link:  https://help.syncfusion.com/wpf/datagrid/data-validation#row-validation

Please let us know, if you need any further assistance on this. 

Regards, 

Vijayarasan S 

[Mariusz Juszkiewicz]

do you have an example of working datagrid with Entity Framework CORE?

[Vijayarasan Sivanandham]

Hi Mariusz Juszkiewicz,

Thanks for the update.

Currently, we are analyzing your requirement of “datagrid with Entity Framework CORE” in SfDataGrid. We will validate and update you the details on March 18, 2020.

We appreciate your patience until then.

Regards,
Vijayarasan S