Does everyone agree Stack Overflow is shit?
-
Yup. SO is no more or less toxic than CP, Reddit, etc.
Jeremy Falcon
It isn't more toxic that CP/Reddit? I must just have a knack for having trolls' channel their core sphincters. :D Or maybe pedantry type things just piss me off way more than they oughta. I seriousness, I guess I haven't really been on SO in over a decade to know. Oh I'll steal their useful lines here and there, I'm just not joining the circus.
-
SO is not friendly for people asking questions, especially if one of their "elites" insist that you post code for a non-code question (as you found out). EF making assumptions is precisely why I hate and abhor ORMs of any description, and I rolled my own entity factory and DAL code (back in the day when I was still writing real code instead of this javascript crap I'm dealing with now). If you're interested and have the freedom to move away from EF, I've written some articles with regards to entity generation based on database contents, as well as a generic ADO assembly. It's all .net framework code, but you shouldn't have any probs moving it to .net core if that's a requirement. Entity Factory - Get Your ORM-less Freak On![^] Generic DAL for ADO.Net - A Revisit[^]
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013 -
How is SO any different than the IRC days back in the 90s? Or the BBS days in the 80s? We're supposed to be mature, professional seniors here and yet we still think the problem is specific to one site? You ever ask a question on CP? You'll need to do the same exact thing with phrasing. Same thing goes with managing devs IRL, or anyone for that matter (including non-devs). And funny how people only come out of the wood works to complain. :suss: This is the part where you argue now...
Jeremy Falcon
-
I didn't say it was specific to SO. SO was merely the qualifying criteria for the discussion. Yeah, CP can be just as bad, but for different reasons. I don't see many/any homework questions (of the ilk, "I need you to do my homework for me) on SO, but that used to be a real problem here. Since I don't really haunt the Q/A section anymore, I don't know it it's still a problem. Besides that, we're talking about SO, not CP. Why are you so angry lately?
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013#realJSOP wrote:
Why are you so angry lately?
mmm... I think he is more or less the same grumpy as usually, only that today is writing more answers than usually ;P :laugh:
M.D.V. ;) If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about? Help me to understand what I'm saying, and I'll explain it better to you Rating helpful answers is nice, but saying thanks can be even nicer.
-
EF decides I have properties, for example a Widget class in an entry and if there's no FK it creates a WidgetId property. This despite were Posgress (all lower case) and we say Key instead of Id. I know of no way to modify or configure this feature and asked how to turn it off. I was asked for a code sample, I said no, this is a general EF feature and I want to turn it off. I got told they can't help without a specific code sample, and they turned my question off!!!! To be clear this happens even with auto generated code and is ALWAYS WRONG. I am happy to have an issue I need to sort out to access one property, based on auto generated nonsense, but I don't want NO ACCESS to a table because it will always invent columns in the SQL that I never claimed to exist.
From my perspective (which I've shared here on more than one occasion), SO is great for small(-ish) snippets that just so happen to directly address what you came searching for. But it's not the place to ASK questions, unless you went in early and are already part of the clique and have the reputation points (or whatever system it is they're using). It's too much of a catch-22 to be newbie-friendly. And without the equivalent of a lounge, it's not the place to make friends and become part of the clique either. Overall, I find it very unwelcoming. At least on CP, if you have a question, as long as you ask it intelligently and demonstrate you've put some effort into it (aka NOT "do my homework for me"), you'll get real, useful help. I've found many answers on SO, typically as links Google provided as responses to my searches. But as I'm writing this, suddenly I realize I now tend to use ChatGPT to get code snippets, and as a result, haven't gone back / been redirected to SO for quite a while. ChatGPT undoubtedly scrapes SO for its info, but as long as it can provide usable answers, I find myself having no reason to go back to SO. Recent events here on CP notwithstanding, personally I see SO as being the one with the more limited future. There, I said it.
-
EF decides I have properties, for example a Widget class in an entry and if there's no FK it creates a WidgetId property. This despite were Posgress (all lower case) and we say Key instead of Id. I know of no way to modify or configure this feature and asked how to turn it off. I was asked for a code sample, I said no, this is a general EF feature and I want to turn it off. I got told they can't help without a specific code sample, and they turned my question off!!!! To be clear this happens even with auto generated code and is ALWAYS WRONG. I am happy to have an issue I need to sort out to access one property, based on auto generated nonsense, but I don't want NO ACCESS to a table because it will always invent columns in the SQL that I never claimed to exist.
I have found SO very useful, but I don't ask questions, I just search for answers and then compare the sometimes myriad results until I find the inspiration to produce a result relevant to me. Failing that, since I have already exhausted CP before going to SO, I reread M$ docs until the screaming dies down and and I figure it out myself!
- I would love to change the world, but they won’t give me the source code.
-
EF decides I have properties, for example a Widget class in an entry and if there's no FK it creates a WidgetId property. This despite were Posgress (all lower case) and we say Key instead of Id. I know of no way to modify or configure this feature and asked how to turn it off. I was asked for a code sample, I said no, this is a general EF feature and I want to turn it off. I got told they can't help without a specific code sample, and they turned my question off!!!! To be clear this happens even with auto generated code and is ALWAYS WRONG. I am happy to have an issue I need to sort out to access one property, based on auto generated nonsense, but I don't want NO ACCESS to a table because it will always invent columns in the SQL that I never claimed to exist.
Way back when I was still making the transition from VB6 which I was lucky to have been a member of a interactive group moderated by John Smiley where the vibe was like CP I had some real unpleasant encounters on SO might have been my wording for the questions though I always explained I was a novice at VBNet every now and then a more polite person would respond with a answer or a website with information to help with the question. When I first joined Code Project it was to ask a question about VB.Net and Visual Studio I was very lucky the response came from Original Griff need I say more. YES every now and then the tone on CP is sharp and of no help but that is seldom and I just take this members reply as he has forgotten what it was like to not know what you are doing when trying to learn to code in a new language. The big issue with SO has always been the idea of points for posting an answer and begging for accepting the answer. The most worthless reply is one that goes like this "You should NOT be doing it that way" with no reply how to do it I just delete the question which you can not do now YES Stack Overflow is NOT of great value
-
EF decides I have properties, for example a Widget class in an entry and if there's no FK it creates a WidgetId property. This despite were Posgress (all lower case) and we say Key instead of Id. I know of no way to modify or configure this feature and asked how to turn it off. I was asked for a code sample, I said no, this is a general EF feature and I want to turn it off. I got told they can't help without a specific code sample, and they turned my question off!!!! To be clear this happens even with auto generated code and is ALWAYS WRONG. I am happy to have an issue I need to sort out to access one property, based on auto generated nonsense, but I don't want NO ACCESS to a table because it will always invent columns in the SQL that I never claimed to exist.
I have found it to be a very good collection of knowledge from previously asked questions. I refrain from asking questions there though. Thankfully, I have rarely had a question that I did not find an answer for either here or there.
"They have a consciousness, they have a life, they have a soul! Damn you! Let the rabbits wear glasses! Save our brothers! Can I get an amen?"
-
EF decides I have properties, for example a Widget class in an entry and if there's no FK it creates a WidgetId property. This despite were Posgress (all lower case) and we say Key instead of Id. I know of no way to modify or configure this feature and asked how to turn it off. I was asked for a code sample, I said no, this is a general EF feature and I want to turn it off. I got told they can't help without a specific code sample, and they turned my question off!!!! To be clear this happens even with auto generated code and is ALWAYS WRONG. I am happy to have an issue I need to sort out to access one property, based on auto generated nonsense, but I don't want NO ACCESS to a table because it will always invent columns in the SQL that I never claimed to exist.
SO is very picky about what type of question it wants. Even though you're just looking for a general setting you'd need to give them a concrete example with a sample table and the incorrect code is generates. EF6 used some sort of templating system I've never seen anywhere else that you could probably edit to change the output of the generated code: Lasciate ogne speranza, voi ch'intrate. I've never had to dig that deep into EF Core to know if how it works. Hopefully they use something less gross.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius
-
EF decides I have properties, for example a Widget class in an entry and if there's no FK it creates a WidgetId property. This despite were Posgress (all lower case) and we say Key instead of Id. I know of no way to modify or configure this feature and asked how to turn it off. I was asked for a code sample, I said no, this is a general EF feature and I want to turn it off. I got told they can't help without a specific code sample, and they turned my question off!!!! To be clear this happens even with auto generated code and is ALWAYS WRONG. I am happy to have an issue I need to sort out to access one property, based on auto generated nonsense, but I don't want NO ACCESS to a table because it will always invent columns in the SQL that I never claimed to exist.
-
Jeremy Falcon wrote:
To be fair… the same can happen on CP.
Could happen, however people are usually welcomed here. Maybe we're not great experts, but, more often than not, try to help.
"In testa che avete, Signor di Ceprano?" -- Rigoletto
That's my problem with SO. The times I've posted questions there they were marked as duplicates and closed or simply deleted. This was after I deliberately wrote them to describe how they weren't like the other instances of the question :suss:.
Software Zen:
delete this; -
I’ve gotten more answers from SO Googling than any other website, bar none. Don’t see the reason for all the hate… which isn’t really helpful and compromises 90% of I see in the lounge.
Jeremy Falcon
I read lots of good answers there. If I ask a question, no matter how much detail and code I give, I get abuse.
-
I use it if results come up in Google searches. The couple of times I submitted questions were... unsuccessful :mad: X|.
Software Zen:
delete this;Exactly the same!!!
-
SO is not friendly for people asking questions, especially if one of their "elites" insist that you post code for a non-code question (as you found out). EF making assumptions is precisely why I hate and abhor ORMs of any description, and I rolled my own entity factory and DAL code (back in the day when I was still writing real code instead of this javascript crap I'm dealing with now). If you're interested and have the freedom to move away from EF, I've written some articles with regards to entity generation based on database contents, as well as a generic ADO assembly. It's all .net framework code, but you shouldn't have any probs moving it to .net core if that's a requirement. Entity Factory - Get Your ORM-less Freak On![^] Generic DAL for ADO.Net - A Revisit[^]
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013Sounds good but I just moved everyone to EF from basic string mashed SQL. It being the standard was a big part of my argument
-
BTW - the way to configure Postgres style naming is to use a snake name casing setting. Here's one I used earlier:
var connectionString = builder.Configuration.GetConnectionString("DefaultConnection") ??
throw new InvalidOperationException("Connection string 'DefaultConnection' not found.");
builder.Services.AddDbContext(options =>
{
options.UseNpgsql(connectionString, o => o.UseQuerySplittingBehavior(QuerySplittingBehavior.SplitQuery))
.UseSnakeCaseNamingConvention()
.ConfigureWarnings(warnings => warnings.Throw(RelationalEventId.QueryPossibleUnintendedUseOfEqualsWarning));
});You can also override the OnModelCreating to override the naming convention for your foreign keys:
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
// Apply the naming convention to all relationships
foreach (var relationship in modelBuilder.Model.GetEntityTypes().SelectMany(e => e.GetForeignKeys()))
{
relationship.SetConstraintName(relationship.GetConstraintName().Replace("_id", "_key"));
}
base.OnModelCreating(modelBuilder);
}But that's just CodeProject. Where people aren't always arsey and rep-hunting.
OK so that looks awesome but my NpgSql doesn't have those methods and typing that in and trying to get a hint on a namespace does not work? What DLL am I missing please?
-
BTW - the way to configure Postgres style naming is to use a snake name casing setting. Here's one I used earlier:
var connectionString = builder.Configuration.GetConnectionString("DefaultConnection") ??
throw new InvalidOperationException("Connection string 'DefaultConnection' not found.");
builder.Services.AddDbContext(options =>
{
options.UseNpgsql(connectionString, o => o.UseQuerySplittingBehavior(QuerySplittingBehavior.SplitQuery))
.UseSnakeCaseNamingConvention()
.ConfigureWarnings(warnings => warnings.Throw(RelationalEventId.QueryPossibleUnintendedUseOfEqualsWarning));
});You can also override the OnModelCreating to override the naming convention for your foreign keys:
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
// Apply the naming convention to all relationships
foreach (var relationship in modelBuilder.Model.GetEntityTypes().SelectMany(e => e.GetForeignKeys()))
{
relationship.SetConstraintName(relationship.GetConstraintName().Replace("_id", "_key"));
}
base.OnModelCreating(modelBuilder);
}But that's just CodeProject. Where people aren't always arsey and rep-hunting.
Found it. Thank you!!!!
-
From my perspective (which I've shared here on more than one occasion), SO is great for small(-ish) snippets that just so happen to directly address what you came searching for. But it's not the place to ASK questions, unless you went in early and are already part of the clique and have the reputation points (or whatever system it is they're using). It's too much of a catch-22 to be newbie-friendly. And without the equivalent of a lounge, it's not the place to make friends and become part of the clique either. Overall, I find it very unwelcoming. At least on CP, if you have a question, as long as you ask it intelligently and demonstrate you've put some effort into it (aka NOT "do my homework for me"), you'll get real, useful help. I've found many answers on SO, typically as links Google provided as responses to my searches. But as I'm writing this, suddenly I realize I now tend to use ChatGPT to get code snippets, and as a result, haven't gone back / been redirected to SO for quite a while. ChatGPT undoubtedly scrapes SO for its info, but as long as it can provide usable answers, I find myself having no reason to go back to SO. Recent events here on CP notwithstanding, personally I see SO as being the one with the more limited future. There, I said it.
I always thought that's why it could never be CP. No community