|
I have a question about eager loading of navigation properties using EF6. Note I like to use the extension syntax.
Suppose I have three tables A, B and C. There is a one-to-many relationship between A and B, and also a relationship between B and C. So, for a given A, I can obtain the collection of Bs using two methods:
Method 1 : using a primary key query...
var Bs = context.B.Where(b => b.AId == A.Id).ToList();
Method 2 : using the navigation property...
var Bs = a.Bs.ToList();
Now, suppose I want to load C for each B at the same time. Using Method 1 it is...
var Bs = context.B.Include(b => b.C).Where(b => b.AId == A.Id).ToList();
My question is, is there an equivalent simple way to load C for each B when using Method 2?
|
|
|
|
|
A lot of the time this is based on the serializer that you're using. JSON.NET, for instance, will do this automatically when serializing an IQueryable. Depending on your serialization strategy, you may need to roll your own.
If you need to work with it in intermediate logic, any queryable references will be resolved automatically as long as is not disposed when you attempt to call them. Just don't force enumeration on the collection until you actually need the data item.
Something like
var b = context.As.SelectMany(a => a.Bs);
var c = PerformSomeLogicOnEnumerable(b);
return c.ToArray();
"There are three kinds of lies: lies, damned lies and statistics."
- Benjamin Disraeli
|
|
|
|
|
If I am not wrong, you need all A, B and relevant C's? Give this a try (where "B" is a collection of B's as a property of "A", and likewise "C" is a collection of C's as a property of "B"):
var abc = context.A.Include("B").Include("B.C");
You have just been Sharapova'd.
|
|
|
|
|
..
modified 23-Jun-20 3:35am.
|
|
|
|
|
Which password are you talking about, the router or some website? In either case it is likely that the only way to check is by trying to login via the web interface.
|
|
|
|
|
...
modified 23-Jun-20 3:36am.
|
|
|
|
|
We do not condone, support, or assist in the production of malicious code in any way, form, or manner. This is a professional site for professional developers.
If you want to know how to create such things, you need to visit a hacking site: but be sure to disable all firewalls and antivirus products first or they won't trust you enough to tell you.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Message Closed
modified 23-Jun-20 3:35am.
|
|
|
|
|
Daniyaltjm wrote: i want to hack the wi-fi router by brutforce
That is trying to bypass a legitimate security feature.
That is malicious.
You will get no help from us.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Message Closed
modified 23-Jun-20 3:37am.
|
|
|
|
|
OriginalGriff is right. You might think that you have a legitimate reason for wanting to do this (although I remain to be convinced about this) but you wouldn't be the only one able to read the answer and, if we provide you with code to do this, we are also providing the code for people who want to do damage with this technique. This is why you will get no code for this here - we don't know who will end up reading it.
This space for rent
|
|
|
|
|
I already suggested you just need to use the web interface to try and login. If your password is not valid it will not let you. But if you want to know how to hack a system then you have come to the wrong place.
|
|
|
|
|
Message Closed
modified 23-Jun-20 3:40am.
|
|
|
|
|
You check WiFi passwords by logging on to the ADSL modem/router through the web interface of the device. I guess you have never done this so you think there is some other way to hack the device.
|
|
|
|
|
No, i don't want connect the setup interface router! just i want for example: i have a textBox and into it is "1234" pass & i have a button . i want when click the button the "1234" in the textBox send to the my SSID for example "USER" & return "correct" or "incorrect" the pass ! It is very complicated ?  please help me...
|
|
|
|
|
|
Very thank's, can you build a simple program that has a listBox to show SSID & a textBox that i enter a password & click the button & return me a messagebox that this is correct or incorrect ? 
|
|
|
|
|
|
he he hoooow! i do it by "Simplewifi.dll"
|
|
|
|
|
You might want to try RentACoder.com or whatever it's called nowadays.
This space for rent
|
|
|
|
|
I have 10 textboxes in a form, the thing is I want make the visibility of all these textboxes to hide and visible based on button click.is their any way to group all these 10 textboxes into single component to make hide /visible based on button click.
ex.: Now for each text box I am doing like this.
textBox1.visible=false;
textBox2.visible=false;
textbox3.visble=false;
something can I do like this,
textbox_Group.visble=false;
thanks in advance...
|
|
|
|
|
To "group" them, you could create a UserControl with contains them all. Making that visible and invisible would affect all the controls it contains.
That does mean that you need to provide properties to access the textBox values (which is a good idea), but you could place them all on a Panel and change the visibility of that to the same display effect, but keeping all the TextBoxes directly accessible to the whole form class.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
In addition to the strategies that OriginalGriff told you about, you could use a ContainerControl like a SplitterPanel to create an easy pop-out - pop-back userinterface. Let's say your Buttons were all in Panel1 of the SplitContainer; then you can show/hide it by:
private void button1_Click(object sender, EventArgs e)
{
splitContainer1.Panel1Collapsed = ! splitContainer1.Panel1Collapsed;
}To get this to work as one might expect:
for the SplitContainer:
0. set appropriate MinimumSize and MaximumSize values.
1. set the 'SplitterDistance property to the width of the left Panel.
2. set IsSplitterFixed property to 'true if you are not going to allow the user to re-size the Panels
for the Panels
1. set the Panel1MinSize and Panel2MinSize (int) properties to appropriate values
If the 'Orientation property of the SplitterPanel is 'Vertical, then the two min size properties are going to set the width of the Panels.
~
Keep in mind that when the collapsed Panel1 is expanded, the Controls placed in Panel2 are going to move depending on how you set their Anchor/Dock properties.
«There is a spectrum, from "clearly desirable behaviour," to "possibly dodgy behavior that still makes some sense," to "clearly undesirable behavior." We try to make the latter into warnings or, better, errors. But stuff that is in the middle category you don’t want to restrict unless there is a clear way to work around it.» Eric Lippert, May 14, 2008
|
|
|
|
|
|
Hi,
How does the Office 2016-Like Help works? How can I add a similar to my C# application?
Thanks,
Jassim[^]
Technology News @ www.JassimRahma.com
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
