Re: Changing a Struct Property Value - C# Discussion Boards

10-Apr-15 13:49

This project I'm working on c# Win App, the customer built a DAL, which compiles into a DLL.
Then used straight Entity Framework 6.+ to bind against.

I read this article, that says you need to use the Entity Data Model to code and bind against.
Entity Framework in WinForms[^]
So I followed the instructions, and now I have a datagrid that I can load data in, and it works.
I figured out how to sort it using OrderBy

Question:
Is this the way to go?

Comment:
I'm old school here, where you hand type what you want to do.
I'm not use to the binding, and Entity Framework is new to me.
I can see how handy this can be if I can figure it out, and implement it correctly.
I would lime to get more control over my select statement here, or am I overlooking the design of EF altogether.

protected override void OnLoad(EventArgs e)
{
    base.OnLoad(e);
    _context = new entity_data_model.StoreDatabaseEntities();

    // Call the Load method to get the data for the given DbSet<br />
    // from the database.<br />
    // The data is materialized as entities. The entities are managed by<br />
    // the DbContext instance.

    _context.Customers.Load();
    _context.SalesOrderDetails.Load();

    // reference - <a href="https://msdn.microsoft.com/en-us/data/jj682076.aspx">https://msdn.microsoft.com/en-us/data/jj682076.aspx</a>
    // I saw examples of using a custom bind to the entity data model using querystrings
    // Place that code here.

    // Try sorting the data by FirstName, this works
    this.customerBindingSource.DataSource = _context.Customers.Local.ToBindingList().OrderBy(customer => customer.FirstName);

     // Basic loading of data with no order by or filtering
     this.salesOrderDetailBindingSource.DataSource =  _context.SalesOrderDetails.Local.ToBindingList();

      // Why can't I Filter? Can I put something in my Base model that will allow me to filter?
      // jkirkerx - I still get false, but I think this is old school, and relates to using DAL instead of the Entity Data Model
      Debug.WriteLine("Supports Filtering: " + customerBindingSource.SupportsFiltering);
      Debug.WriteLine("Supports Filtering: " + salesOrderDetailBindingSource.SupportsFiltering);            

      customerDataGridView.AutoGenerateColumns = false;
}

Re: Entity Data Model

Dave Kreskowiak10-Apr-15 15:55

Dave Kreskowiak

10-Apr-15 15:55

Is this to way to go ... where? What is it you want the code to do? The only reasonable fitness of this code is as an example of ... a badly laid out example of binding to a table of small size. It's most definitely not production quality code as its not scalable at all.

The first thing it does is load ALL of the Customers and ALL of the SalesOrderDetails tables. If the tables are quite large this will result is very slow query performance as EF re-hydrates every object in those tables, even if those objects are not needed by the query.

The code is binding to the ENTIRE list of Customers, not just the customers that are visible in the datagrid. Again, this does not scale as the list of Customers grows and grows. This setup does not support filtering nor does it allow for paging.

It also appears that the grid used for SalesOrderDetails is showing the entire list of orders details, not just the details for a selected Customer. What good is that?

A guide to posting questions on CodeProject

Click this: Asking questions is a skill.
Seriously, do it.

Dave Kreskowiak

Re: Entity Data Model

jkirkerx12-Apr-15 8:05

12-Apr-15 8:05

Good point you made there about loading the entire list of customers and sales orders. I forgot about that.

I'll look for a way to use Entity Framework without binding. So I guess the answer is no.

Ok, How about this?

jkirkerx12-Apr-15 13:55

Changing a Struct Property Value

12-Apr-15 13:55

No Entity Data Model
And just use the Data Access Layer that is compiled as a DLL
So I replaced the GridView with a ListView, wrote code to create the columns, and wrote this code to load the ListView object.

I really don't want to bind to objects. I want to use the benefits of the Data Access Layer concept, but without binding.
All the examples and turtorials I'm able to locate show Entity Framework and binding to objects.
So I got rid of the Entity Data Model and DataSources, and went back to the DAL only.

I'm not clear on the Entity Framework. Wasn't even sure if I was really using it or not, so I deleted the reference to it.
Got a few error messages in teh code I posted below, so I guess I'm using it.
This is a crash course for me on using DAL and Entity Framework, so please bear with me, I am underwater on this subject.

private void load_customers()
{

    lv_customers.Items.Clear();

    // How to use Entity Framework, that's the question
    // I'm using LINQ here to specify the data, and not Entity Framework

    // Basic LINQ Query Operation
    // <a href="https://msdn.microsoft.com/en-us/library/bb397927.aspx">https://msdn.microsoft.com/en-us/library/bb397927.aspx</a>

    using (StoreContext context = new StoreContext())
    {
        var query =
            from customer in context.Customers
            where customer.FirstName == "Randy" || customer.LastName == "Sublett"
            orderby customer.FirstName
            select new
            {
                ID = customer.ID,
                FirstName = customer.FirstName,
                LastName = customer.LastName,
                BusinessName = customer.BusinessName
            };                   

        foreach(var ci in query)
        {
           ListViewItem item = new ListViewItem(ci.ID.ToString(), 0);
           item.SubItems.Add(ci.FirstName);
           item.SubItems.Add(ci.LastName);
           item.SubItems.Add(ci.BusinessName);
           item.SubItems.Add(0.ToString());

           lv_customers.Items.Add(item);

           Application.DoEvents();
        }

   }

}

Kevin Marois10-Apr-15 11:01

10-Apr-15 11:01

Why doesn't this work:

namespace Sanebox1
{
    public class Employee
    {
        public Department TheDepartment { get; set; }

        public Employee()
        {
            TheDepartment.DepartmentId = 100;
        }
    }

    public struct Department
    {
        public int DepartmentId { get; set; }

    }
}

It won't compile with

Cannot modify the return value of 'Sandbox1.Employee.TheDepartment' because it is not a variable

I'm not trying to change the struct, I'm try to change the departmentId.

What's wrong here?

If it's not broken, fix it until it is

harold aptroot10-Apr-15 12:31

harold aptroot

10-Apr-15 12:31

Coder For Hire wrote:
I'm not trying to change the struct, I'm try to change the departmentId.

That's the problem. You can change the struct, but assigning to its fields (no matter if it's with a property or not) would do nothing (and is banned because it is always a bug).

Remember that properties are just syntactic sugar for get and set methods. You can see this in effect in a decompiler (you may have to mess with settings). Using TheDepartment in a context where it is read from (as you do here) then you're really calling a get-method that returns it. So it's a copy. You're making a copy, calling a set-method on it, then the copy disappears and really nothing has happened at all (unless the properties have side effects). At least, that's what you would be doing if it wasn't an error to write this. That's a sort of unofficial way to look at it though, properties and methods do act differently, for example if you emulate a property using your own getter and setter then you wouldn't get this compile error (you'd get the useless behaviour I described above).

This "weird difference" between fields and properties also exists between elements of an array and indexers (in particular this means changing an array of structs to List<T> does not always work).

To quote the spec,

ECMA 334, §14.5.4 Member access:
... if E is a property or indexer access, then the value of the property or indexer access is obtained
(§14.1.1) and E is reclassified as a value.

This says that TheDepartment is a value, and

ECMA 334, §18.3.3 Assignment:
When a property or indexer of a struct is the target of an assignment, the instance expression associated with
the property or indexer access shall be classified as a variable. If the instance expression is classified as a
value, a compile-time error occurs. This is described in further detail in §14.14.1.

says that if the target of assignment is a property of a struct and the instance is a value, then it's an error. So, DepartmentId cannot be the target of assignment here.

OriginalGriff10-Apr-15 22:03

OriginalGriff

10-Apr-15 22:03

Just to add to what Harold says, the problem is that Department is a struct, and thus a value type - so when you use a property to access the value what is returned is a copy of the value rather than a reference to the value itself - so when you change the value of a field or property within the copy, it will have no effect on the actual value in your class.
Try it: change the struct to a class and it will return a reference to the value instead - and it'll all compile fine.
Alternatively, manually implement the property in your Employee class and use the backing value directly:

public class Employee
    {
    private Department _TheDepartment;
    public Department TheDepartment
        {
        get { return _TheDepartment; }
        set { _TheDepartment = value; }
        }
    public Employee()
        {
        _TheDepartment.DepartmentId = 100;
        }
    }

public struct Department
    {
    public int DepartmentId { get; set; }
    }

Because that way you are directly referring to the valuetype, instead of a copy.

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

BillWoodruff10-Apr-15 22:53

BillWoodruff

10-Apr-15 22:53

I am hesitant to add any words to the astute explanations offered by Harold, and Griff. However, I can't help Smile | :)

providing you with a working example, created in Visual Studio 2013 using FrameWork 4.5, that may intrigue you:

namespace Sanebox2
{
    public class Employee
    {
        public Department TheDepartment { get; set; }

        public Employee(int departmentid = 100)
        {
            TheDepartment = new Department(departmentid);
        }
    }

    public struct Department
    {
        public int DepartmentId { get; set; }

        public Department(int id) : this()
        {
            DepartmentId = id;
        }
    }
}

// test somewhere in a method or event-handler, set break-point, examine 'e1, 'e2
// Employee e1 = new Employee();
// Employee e2 = new Employee(999);

«To kill an error's as good a service, sometimes better than, establishing new truth or fact.» Charles Darwin in "Prospero's Precepts"

modified 13-Apr-15 7:35am.

Richard Deeming13-Apr-15 1:31

Richard Deeming

13-Apr-15 1:31

Or, without changing the Department structure:

TheDepartment = new Department { DepartmentId = departmentId };

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

BillWoodruff13-Apr-15 1:49

BillWoodruff

13-Apr-15 1:49

Interesting, Richard. I am em-bare-assed to say that I can't explain (satisfactorily, to myself) exactly why adding the call to the base initializer makes this work. I assume it has something to do with the "parametric constructor" mentioned in various places I've searched for an answer to this.

cheers, Bill

«To kill an error's as good a service, sometimes better than, establishing new truth or fact.» Charles Darwin in "Prospero's Precepts"

Richard Deeming13-Apr-15 2:02

Richard Deeming

13-Apr-15 2:02

I guess it's due to compiler error CS0188[^] - all fields in a struct have to be assigned by a constructor before the constructor can call a method in the struct.

Setting a property counts as calling a method on the struct, which you can't do until all of the fields have been assigned. Since you're using an automatic property, you can't directly access the backing field to initialize it. Therefore, the only way to initialize it is to call the default parameterless constructor (which all structs have), which initializes all of the fields to their default values.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Kevin Marois13-Apr-15 3:06

13-Apr-15 3:06

What does the ": this()" do?

I can't find an explanation anywhere.

Removing it doesn't seem to have any effect.

If it's not broken, fix it until it is

Richard Deeming13-Apr-15 4:12

Richard Deeming

13-Apr-15 4:12

You shouldn't be able to compile the code without it - you'll get compiler error CS0188[^] - "The 'this' object cannot be used before all of its fields are assigned to".

All fields in a struct have to be assigned by a constructor before the constructor can call a method in the struct.
Setting a property counts as calling a method on the struct, which you can't do until all of the fields have been assigned.
Since you're using an automatic property, you can't directly access the backing field to initialize it.
Therefore, the only way to initialize the field is to call the default parameterless constructor first.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

C# Memory Leak Question

Kevin Marois10-Apr-15 10:45

Re: C# Memory Leak Question

10-Apr-15 10:45

I just saw this on SO:

In C#, these are some common memory leaks:
•Not removing event listeners. Any event listener that is created with an anonymous method or lambda expression that references an outside object will keep those objects alive. Remember to remove event listeners when they are no longer used.

Can someone show me an example of this in an anonymous method? I'd like to see how C# looks like that causes this.

Thanks

If it's not broken, fix it until it is

jschell10-Apr-15 11:36

jschell

10-Apr-15 11:36

Following in google seems to work for me

C# anonymous event listener example

Re: C# Memory Leak Question

Kevin Marois13-Apr-15 3:13

Easy Way to Display Multilingual Tooltip and Message Box

13-Apr-15 3:13

So the reason I asked is because I have this:

using (WebClient client = new WebClient())
{

    client.DownloadProgressChanged += (sender, e) =>
    {
        double bytesIn = double.Parse(e.BytesReceived.ToString());
        double totalBytes = double.Parse(e.TotalBytesToReceive.ToString());
        double percentage = bytesIn / totalBytes * 100;

        file.PercentDone = Math.Truncate(percentage);
    };

    client.DownloadFileCompleted += (sender, e) =>
    {
        Files.Remove(file);
    };

    await client.DownloadFileTaskAsync(new Uri(file.FileName), outputFile);
}

I've never dealt with leaks before, and I'm handling the events using lamdas. Isn't there a protential here for a memory leak?

If it's not broken, fix it until it is

Felix Obere10-Apr-15 10:03

Felix Obere

10-Apr-15 10:03

Do not know why the above post was deleted

convert piece of code from C++ to C#

MrKBA10-Apr-15 8:25

MrKBA

10-Apr-15 8:25

I have a piece of code in c++ and I want to know how it can be in C# :

int m_it[MAX_BC];
int m_iKe[MAX_ROUNDS][MAX_BC];
char const* a_pchIn;
int* pi = m_it;
for(i=0; i<8; i++)
{
    *pi = ((unsigned char)*(a_pchIn++) << 24);
    *pi |= ((unsigned char)*(a_pchIn++) << 16);
    *pi |= ((unsigned char)*(a_pchIn++) << 8);
    (*(pi++) |= (unsigned char)*(a_pchIn++)) ^= m_iKe[0][i];
}

In C# ?
Thank you

Re: convert piece of code from C++ to C#

RedDk12-Apr-15 16:49

RedDk

12-Apr-15 16:49

This answer might erk a few programmers here in Discussions, but I can recall having a moderate amount of success taking C++ code verbatim and pasting it as C# code in the C# code behind module I was working on, attempting a compile, THEN ACTUALLY working from the compiler error list to clear the syntax breaks while F2-ing the HELP tome.

'Might try this if you find no other solution ...

single quote inside double quote in C# ASP.NET

Rajeshkunwar2510-Apr-15 3:42

Rajeshkunwar25

10-Apr-15 3:42

Code--- C#

XML

strHTML = "<table id='table1'> <colgroup><col width='190'/></colgroup><tbody>";
                for (int i = 0; i < objDs.Tables[0].Rows.Count; i++)
                {
                    if (i <= 10)
                    {
                        strUniqueID = "a" + i;
                        strBGColor = "a" + i.ToString();
                    }
                    else
                    {
                        strUniqueID = "a" + i;
                        strBGColor = "a" + (i - 1);
                    }
                    strSubject = objDs.Tables[0].Rows[i]["SubjectName"].ToString();
                    iSubjectID = Convert.ToInt32(objDs.Tables[0].Rows[i]["Subjectid"]);

<pre>
                strHTML = strHTML + &quot;&lt;tr&gt;&lt;td class=&#39;dark&#39;&gt;&lt;div id=&#39;&quot; + strUniqueID + &quot;&#39; class=&#39;drag clone &quot; + strBGColor + &quot;&#39;&gt;&quot; + strSubject + &quot;&lt;/div&gt;&lt;input id=&#39;b_&quot; + strUniqueID + &quot;&#39; class=&#39;&quot; + strUniqueID + &quot;&#39; type=&#39;button&#39; value=&#39;&#39; onclick=&#39;report(&quot; + strUniqueID + &quot;)&#39; title=&#39;Show only &quot; + strSubject + &quot;&#39;/&gt;&lt;/td&gt;&lt;/tr&gt;&quot;;

            }
            strHTML = strHTML + &quot;&lt;tr&gt;&lt;td class=&#39;trash&#39; title=&#39;Trash&#39;&gt;Trash&lt;/td&gt;&lt;/tr&gt;&quot;;
            strHTML = strHTML + &quot;&lt;/tbody&gt;&lt;/table&gt;&quot;;
            left.InnerHtml = strHTML;</pre>

---OutPut

English Test P

Kunal

Kunwar

Maths

Maths Test

Raj

Trash

Re: single quote inside double quote in C# ASP.NET

OriginalGriff10-Apr-15 3:57

OriginalGriff

10-Apr-15 3:57

And?
You didn't ask a question...

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

I can't get my splash screen to close

jkirkerx9-Apr-15 11:00