Sanity check here...   Shouldn't these two linq queries return the same results?   Query #1:  int stateId = 2;  var streets = from s in ctx.tblStreet               where s.State_Id == stateId               &amp;&amp; s.ParentStreet_Id == (int?)null               select s;   Query #2:  int stateId = 2; int? parentStreetId = (int?)null;  var streets = from s in ctx.tblStreet               where s.State_Id == stateId               &amp;&amp; s.ParentStreet_Id == parentStreetId               select s;   ====== EDIT ==========  The first linq query yields the records that I expect it to, while the second linq query does not. I would expect both of them to yield the same results, but they don't.  ====== EDIT #2 ==========  tblStreet definition...  int State_Id not null  int ParentStreet_id null  ====== EDIT #3 ==========  The generated sql is different for the two queries, but I would expect it to not matter in this case, because @p1 (parentStreetId) equals (int?)null. Please note that in the queries below I removed all of the select fields and replaced them with an asterisk in order to shorten up the select and just show the where clause.  Query #1:  SELECT * WHERE ([t0].[State_Id] = @p0) AND ([t0].[ParentStreet_Id] IS NULL)  Query #2:  SELECT * WHERE ([t0].[State_Id] = @p0) AND ([t0].[ParentStreet_Id] = @p1)
I have a Category entity which has a Nullable ParentId field. When the method below is executing and the categoryId is null, the result seems null however there are categories which has null ParentId value.  What is the problem in here, what am I missing?  public IEnumerable&lt;ICategory&gt; GetSubCategories(long? categoryId) {     var subCategories = this.Repository.Categories.Where(c =&gt; c.ParentId == categoryId)         .ToList().Cast&lt;ICategory&gt;();      return subCategories; }   By the way, when I change the condition to (c.ParentId == null),  result seems normal.
Homomorphism between compact Hausdorff spaces. Intel Corporation Device [8086:0d4f] is not supported on Ubuntu 18.04.3 I am currently unable to install ubuntu server 18.04.03 LTS on the latest intel NUC10i7FNH.  Ubuntu always states both network adapters as unclaimed. The previous version (NUC8i7BEH) has the same network controller I219-V and worked like a charm.  *-network:0 UNCLAIMED      description:  Network controller      product: Intel Corporation      vendor: Intel Corporation      physical id: 14.3      ...   Without network it is not even possible to follow most suggestions how to get it enabled, because it is impossible to fetch new packages from internet.  Here are some more information as requested:  The output from: modprobe -v e1000e &amp;&amp; dmesg | grep e10   [ 3447.889394] e1000e: Intel(R) PRO/1000 Network Driver - 3.2.6-k [ 3447.889395] e1000e: Copyright(c) 1999 - 2015 Intel Corporation.   The output from: sudo lspci -knn  00:1f.6 Ethernet controller [0200]: Intel Corporation Device [8086:0d4f]     Subsystem: Intel Corporation Device [8086:2081] 01:00.0 PCI bridge [0604]: Intel Corporation JHL7540 Thunderbolt 3 Bridge [Titan Ridge 2C 2018] [8086:15e7] (rev 06)    For me this looks somehow, as the kernal driver would not be in use :-/  Here are a few more information i got from playiung around with 19.10 desktop version.  [    0.000000] Linux version 5.3.0-29-generic (buildd@lcy01-amd64-024) (gcc version 9.2.1 20191008 (Ubuntu 9.2.1-9ubuntu2)) #31-Ubuntu SMP Fri Jan 17 17:27:26 UTC 2020 (Ubuntu 5.3.0-29.31-generic 5.3.13)   output from lshw:    *-network:0        Beschreibung: Kabellose Verbindung        Produkt: Intel Corporation        Hersteller: Intel Corporation        Physische ID: 14.3        Bus-Informationen: pci@0000:00:14.3        Logischer Name: wlp0s20f3        Version: 00        Seriennummer: c8:09:a8:9c:cd:e0        Breite: 64 bits        Takt: 33MHz        Fähigkeiten: pm msi pciexpress msix bus_master cap_list ethernet physical wireless        Konfiguration: broadcast=yes driver=iwlwifi driverversion=5.3.0-29-generic firmware=48.4fa0041f.0 ip=192.168.178.109 latency=0 link=yes multicast=yes wireless=IEEE 802.11        Ressourcen: iomemory:600-5ff irq:16 memory:6023114000-6023117fff   The output from: modprobe -v e1000e &amp;&amp; dmesg | grep e10  [    2.357430] e1000e: Intel(R) PRO/1000 Network Driver - 3.2.6-k [    2.357430] e1000e: Copyright(c) 1999 - 2015 Intel Corporation. [    2.357616] e1000e 0000:00:1f.6: Interrupt Throttling Rate (ints/sec) set to dynamic conservative mode [    2.562796] e1000e 0000:00:1f.6 0000:00:1f.6 (uninitialized): registered PHC clock [    2.634139] e1000e 0000:00:1f.6 eth0: (PCI Express:2.5GT/s:Width x1) 1c:69:7a:60:44:f0 [    2.634140] e1000e 0000:00:1f.6 eth0: Intel(R) PRO/1000 Network Connection [    2.634258] e1000e 0000:00:1f.6 eth0: MAC: 13, PHY: 12, PBA No: FFFFFF-0FF [    2.634991] e1000e 0000:00:1f.6 eno1: renamed from eth0 [    5.103285] checking generic (4000000000 e10000) vs hw (4000000000 10000000) [   15.806697] e1000e: eno1 NIC Link is Up 1000 Mbps Full Duplex, Flow Control: None    output from lspci:  00:1f.6 Ethernet controller [0200]: Intel Corporation Ethernet Connection (10) I219-V [8086:0d4f]     DeviceName:  LAN     Subsystem: Intel Corporation Ethernet Connection (10) I219-V [8086:2081]     Kernel driver in use: e1000e     Kernel modules: e1000e I'd like to find the files in the current directory that contain the text "chrome".  $ find . -exec grep chrome find: missing argument to `-exec'   What am I doing wrong? I deleted an answer which had no upvotes or downvotes, but after some time I saw that my reputation was -2 and the reason is linked to my search engine.    I want to know why this happened and what "linked to my serach engine" means? Found the alternative form: $\sum _{k=1}^\infty ((1-\frac{1}{k})^{k})^k$. Tried various criteria, no luck so far. Planetary/Atmospheric volumetric clouds I created a planet in blender a while ago, and now i'm interested in adding volumetric clouds instead of using a 2D texture. I considered adding a bump node to my material, but then it would remove the realism in the image.  This is what I've created:    This is the effect I want to create:      Any thoughts? I have some  gained from survey questions.  In my case they are  responses (Strongly Disagree-Disagree-Neutral-Agree-Strongly Agree).  In my data they are coded as 1-5.  I  don't think means would mean much here, so what basic summary statistics are considered usefull? What exactly is the cause of RAM incompatibility? I'm looking at rather short QVL lists from manufacturers, and I'm wondering what is the underlying cause of RAM incompatibility aside from the obvious: Obvious Reasons for Incompatibility  RAM Generation (DDR, DDR2, DDR3, DDR4) Form Factor / pin count RAM Type (ECC vs Non-ECC, Registered vs not, Buffered vs not) Minimum speeds on a board that cannot adjust the memory frequency Non-standard voltage range on a board that cannot adjust the memory voltage Channel count (single vs dual vs quad) Bad or inoperable module Mismatched set  Not Obvious Reasons  Brand SKU Max Capacity Speed too high  As in, why can't motherboard manufacturers just list the specifications of the RAM they will accommodate, and support every memory chip of that category instead of listing specific SKUs from specific brands? What happens electrically/physically that causes boards to fail to POST / operate with RAM that is otherwise 'compatible' with all of the specifications of RAM that is on the QVL? Solve $x^2+2=y^3$ using infinite descent? Recently, the TeX.SE question  got onto the Hot Network Questions list.  Like many questions on TeX.SE, it contains some TeX markup in its title.  Unfortunately, on , this markup gets parsed and rendered as math:    I propose that either:   the entire Hot Network Questions sidebar should be excluded from MathJax parsing by styling it with the tex2jax_ignore class, or at least, any hot questions from TeX.SE should be so excluded from MathJax parsing.   Or I suppose we could always implement , which asks for all questions with TeX in the title to be excluded from Hot Network Questions entirely.  That might be throwing out the baby with the bathwater, though.    Ps. This issue is partially masked by , which causes MathJax not to be rendered in many elements that are hidden by default and revealed using jQuery .show(), such as all but the first five questions in the Hot Network Questions sidebar.  The  user script contains a generic fix for that bug, so users who have it installed will see this issue more frequently, but it occurs even without SOUP whenever a question with TeX markup in the title happens to show up among the top five hot questions that are always visible by default. How do I disable notifications in my personal profile for activity on pages I am an admin of? I'm an admin of several pages on Facebook (for technical stuff like RSS imports, etc.), but neither do I contribute content nor do I care about their content.  Still, as an admin, I get notifications (upper left hand, the globe icon) about activity (someone liked this, someone posted that) on those pages in my personal (!) profile .  Does anyone have the same issue? Is there any way to explicitly disable notifications for certain pages?  (This behavior seems to be new, by the way; I'm only seeing those notifications for a few weeks now.) Is some of my internal memory missing? Quotient ring of Gaussian integers A very basic ring theory question, which I am not able to solve. How does one show that    $\mathbb{Z}[i]/(3-i) \cong \mathbb{Z}/10\mathbb{Z}$. Extending the result: $\mathbb{Z}[i]/(a-ib) \cong \mathbb{Z}/(a^{2}+b^{2})\mathbb{Z}$, if $a,b$ are relatively prime.   My attempt was to define a map, $\varphi:\mathbb{Z}[i] \to \mathbb{Z}/10\mathbb{Z}$ and show that the kernel is the ideal generated by $\langle{3-i\rangle}$. But I couldn't think of such a map. Anyhow, any ideas would be helpful. Why is there a temperature gradient on Earth? I was thinking about why the poles are colder and I came out with three possible explanations.  1. The atmosphere blocks light beams coming to poles    The Sun is seen only slightly over the horizon at the poles, so the light beams have longer way to the poles. If only this case were true, then the total difference between the poles and the equator would be the same as the energy that was absorbed by the atmosphere.  2. Sun is only slightly over the horizon at the poles.    Poles are often in shadow of the parts of the Earth which are closer to the equator.  3. Poles are farther from the Sun    The longer is the way to Sun the lower is the chance to catch a light from the Sun.  Please, correct me wherever I'm wrong. I'd like to know   Which of these three is most correct?  How significant are the described effects of the other explanations? I've just updated to macOS 10.12 and when I try to execute srm in Terminal, it says -bash: srm: command not found.   Is srm removed? How to fix this? How can I take a photo using a slow shutter speed without it being overexposed? When I try to take a picture using a slow shutter speed in daylight it is overexposed. How can I change the settings so it isn't overexposed? Should "Applied Cryptography" be capitalized? Is it a proper noun? I'm trying to write a cover letter for a fairly prestigious job, and I'm aiming for (arguably too much) perfection in my cover letter. I don't want to be turned away only because the hiring people though I was too careless with my punctuation and capitalization.  My sentence goes as follows:     I hope to one day go on to complete a Masters degree in Computer Science with a focus in Applied Cryptography.   I've never been great with the technical rules of the English language, despite being a native speaker. After reading  It seems that there is no perfect solution for getting rid of the stretch at the poles of UV spheres.  According to , icospheres can be used for stretch-less UV mapping:     All faces have the same area, which may be useful for certain types of UV mapping containing non-organic textures. An example that comes to mind is an isocahedral die or billiard balls where stretch must be minimized near the point where the number is printed onto the ball.   Incidentally, a lowish-poly billiard ball is exactly what I'm attempting to create.  However, my attempts at neatly unwrapping an icosphere have mostly failed (smart UV unwrap works perfectly for using baked textures, however I was hoping for something more like the example in the 6th post of , with a nice clean rectangular map).  How can an icosphere (I assumed the term "geosphere" in the thread was referring to a (geodesic) sphere made of triangles, like an icosphere) be cleanly unwrapped? Or if it's not possible, is there another way to do this which I'm missing?    I'm planning on using the resulting sphere in the BGE. What does negative R-squared mean? Let's say I have some data, and then I fit the data with a model (a non-linear regression). Then I calculate the R-squared ($R^2$).  When R-squared is negative, what does that mean? Does that mean my model is bad? I know the range of $R^2$ can be [-1,1]. When $R^2$ is 0, what does that mean as well? How are the age restrictions followed by ICC for under 19 cricket tournaments? I have some doubts under this topic,   Can a player aged 19 play under 19 international cricket match? (Since 19 is not under 19) Consider a player having birthday during the series/tournament. How the age will be calculated for him?