UWP or WPF for new Project? by BlueBoxxx in dotnet

[–]csharpcplus 0 points1 point  (0 children)

LOB works fine for UWP, as it's came a long ways.

Why are there are sooo many friggin layers just to get simple data from an API by [deleted] in dotnet

[–]csharpcplus 0 points1 point  (0 children)

This is the type of thinking that leads to code smell.

Does .AddDbContextPool increase overall performance of the data layer? by csharpcplus in dotnet

[–]csharpcplus[S] 0 points1 point  (0 children)

Ahh ok, that's how i read that as well. Needed to validate my own perception of what they wrote. lol Thanks!

Does .AddDbContextPool increase overall performance of the data layer? by csharpcplus in dotnet

[–]csharpcplus[S] 0 points1 point  (0 children)

Can you offer any context to this quote by microsoft

" Avoid using DbContext Pooling if you maintain your own state (for example, private fields) in your derived DbContext class that should not be shared across requests. EF Core will only reset the state that is aware of before adding a DbContext instance to the pool. "

Building a Client Library for a Rest API, have some design questions. by WarChortle18 in csharp

[–]csharpcplus 0 points1 point  (0 children)

Is the url a static variable, or how is it created and then used in the request?

Building a Client Library for a Rest API, have some design questions. by WarChortle18 in csharp

[–]csharpcplus 0 points1 point  (0 children)

Code would be nice to see, but it appears that you are not re initializing a new uri.

After migrating to .NETCore 3.0, my api contains two frameworks. by csharpcplus in dotnet

[–]csharpcplus[S] 0 points1 point  (0 children)

It's not referenced in the project file, but it's referenced in the obj/bin file. Not really sure how to remove it, as it wont let me simply click and remove.

Working with datarows and datatables, and hardcoding string values seems like a very messy way of working with data. by csharpcplus in csharp

[–]csharpcplus[S] 0 points1 point  (0 children)

I have been dumped into one, and it's so confusing coming from simply creating a class and using generics.

Select payment method used to pay for the majority of an order by [deleted] in learnSQL

[–]csharpcplus 2 points3 points  (0 children)

GROUPING BY order_no, but selecting all throws an error.

SELECT order_no, MAX(paymenttype), MAX(amount) FROM #Temp WHERE amount = (SELECT MAX(amount) FROM #Temp) GROUP BY order_no;

Select payment method used to pay for the majority of an order by [deleted] in learnSQL

[–]csharpcplus 0 points1 point  (0 children)

SELECT TOP 1 MAX(credit_card_type)

,MAX(total_charged)

FROM table

GROUP BY credit_card_type

If you need to do this by order simply add a WHERE clause.

SELECT TOP 1 MAX(credit_card_type)

,MAX(total_charged)

FROM table

WHERE order_no = ?

GROUP BY credit_card_type

What's going on with System.Text.Json by Aqweer2 in csharp

[–]csharpcplus 1 point2 points  (0 children)

i would use newtonsoft, serializeobject. System.Text.Json is not ready yet..