Listview shows as empty when there is a long column name in the model

kirsten greed

created 6 years ago (modified 6 years ago)

I have records in my table but my xaf listview is empty.
I have identified that the problem is in my model because if I remove this field from the model then I see the records
public bool ExcludeFromPrioritizeByDueByDate { get; set; }I have tried using a different name

Code
[Column("ExcludeFromPrioritizeByDueByDate")]  
   public bool ExcPByDueByDate { get; set; }

but it does not help.
I have also tried using the fluent configuration

Code
public class JobListConfiguration : EntityTypeConfiguration<JobList> {  
   public JobListConfiguration()  
    {  
        Property(x => x.ExcPByDueByDate).HasColumnName("ExcludeFromPrioritizeByDueByDate");  
    }  
 }

I am unsure whether the issue is Entity Framework or XAF

Comments (1)

kirsten greed 6 years ago

I have Cross posted to Stack Overflow

Answers approved by DevExpress Support

Anatol (DevExpress)

created 6 years ago

Hello Kirsten,

The issue likely occurs because your database system does not support column names of this length. So, the actual column name is truncated, and your Entity Framework data provider cannot find it by the full name. If my supposition is correct, you can reproduce the same behavior without XAF.
So, instead of making the property name shorter, shorten the column name:

C#
[Column("ExcPByDueByDate")]  
public bool ExcludeFromPrioritizeByDueByDate { get; set; }

You will also need to rename the database column that is already created, or recreated the database.

It this does not help, I suggest that you use the SQL queries profiler to determine why data is not loaded. In addition, check if there are any handled exceptions: Collect and Analyze the Diagnostic Information.

Comments (1)

kirsten greed 6 years ago

Thanks Anatol those suggestions helped.
It turned out I had misspelt the column name.
This was not picked up in the log file
However using the SQL Server Profiler showed that the query was failing.

Listview shows as empty when there is a long column name in the model

Answers approved by DevExpress Support

Recently viewed tickets