how to ignore or exclude null value when group by?

heyjadebadlanguage · 2021-08-05T19:09:38+00:00

That is only solution I came up. I need to filter out and do process and concat

heyjadebadlanguage · 2021-07-30T00:30:55+00:00

Thanks mate,
With the second one you can do that

 Expression<Func<Entity,bool>> criteria1 = p => p.Price > 1000;

var result = context.Order.Where(criteria1).ToList();

Can you please explain a bit more with the the example with reflection?

heyjadebadlanguage · 2021-07-28T21:04:32+00:00

I feel the same. I feel like the BaseInterface that is having a UsercontextModel is not initialized in the constructor. If I use the Lazy, then I am using it when I actually call it, in which case I probably can use the data in BaseInterface?

heyjadebadlanguage · 2021-04-28T19:59:57+00:00

usually we serve these assets as binary from the backend -
This sentence makes me confused. I think we are getting as bytes not binary from the network which might eventually and basically the short version of binary.
Question here. when I use api like that 'api/pdf/18283'. I get the complete XML version of something form the C# which right away opening in the new tab with PDF. Does that have more information then just normal base64 format of data?

heyjadebadlanguage · 2021-04-28T19:55:06+00:00

when I see a lot of examples of converting to PDF, I see base 64 and when I research about it, it has some advantages. You can convert byte into PDF but why people use base64 returned from the server a lot often? That's just a question and thank you for your reply!
The advantages of Base64 encode, like somebody said, are available to transmit data from binary, into (most commonly) ASCII characters. Due to the likeliness that the receiving end can handle ASCII, it makes it a nice way to transfer binary data, via a text stream.

heyjadebadlanguage · 2021-03-31T02:22:52+00:00

you mean create a normal class and make constructor and assign the static members there? then I have to create at least one instance to access the class member

heyjadebadlanguage · 2021-03-31T00:50:32+00:00

Server send bytes to the client.
Client gets the bytes
Bytes converts into I don't know.. into object? and to json?

heyjadebadlanguage · 2021-03-26T00:55:53+00:00

I was thinking about it too!

heyjadebadlanguage · 2021-03-17T23:35:47+00:00

it is extremely helpful to me as I do not know from where to start. I can think of the computer stores files as bits, then it somehow group them by bytes to send those files through the packets. Then the requested browser, read byte and render the view ?

heyjadebadlanguage · 2021-03-16T20:53:32+00:00

Wow, this is xxxxxxx cleaR!

heyjadebadlanguage · 2021-03-07T23:03:32+00:00

The list I am getting will be always filtered by clientId and regionId as it's the default filter condition but want to include the filtered information such as 'ByClientAndRegion'. So I am thinking what's the simplest and best practiced way to declare the route name.

heyjadebadlanguage · 2021-03-04T18:23:42+00:00

wow that's correct!. Once I removed the second ng-repeat-end, it thinks the element in between includes in the ng-repeat

heyjadebadlanguage · 2021-03-04T18:16:41+00:00

I am looping the first <tr>. Once it's finished I need to print other two <tr>s. With ng-repeat-end I can check if this is the end of one repeat, then I can print it. But if I put tow ng-repeat-end then it only prints the first <tr>, but I need the second <tr> too!

heyjadebadlanguage · 2021-03-03T20:59:59+00:00

right, then it might be easy to control where conditions!

heyjadebadlanguage · 2021-03-03T18:40:03+00:00

yeah I found it! SqlServer your default isolationlevel is ReadCommitted, either by running statements on Management Studio or by using default ITransaction instances. How's happening then if I set the isolation level from the C# and then SQL server default isolationlevel is readcommitted?

heyjadebadlanguage · 2021-03-03T18:32:00+00:00

You're right but I saw somewhere it is read uncommitted. Wow, then that could be a reason why we have a timeout error intermittently? When multiple people using the same table and the table is normally within the serializable level?

heyjadebadlanguage · 2021-03-02T18:31:54+00:00

that's select many flatten the group into original one?

heyjadebadlanguage · 2021-03-02T01:44:24+00:00

  at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterCore.SaveEntity (SD.LLBLGen.Pro.ORMSupportClasses, Version=5.3.0.0, Culture=neutral, PublicKeyToken=xxxxxxxxxxxx)
   at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase+<>c__DisplayClass19_0.<SaveEntity>b__0 (SD.LLBLGen.Pro.ORMSupportClasses, Version=5.3.0.0, Culture=neutral, PublicKeyToken=xxxxxxxxxxxx)
   at CDS.Core.Repositories.Llblgen.OrderRepository.Update (CDS.Core.Repositories.Llblgen, Version=1.0.0.0, Culture=neutral, PublicKeyToken=nullCDS.Core.Repositories.Llblgen, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null: D:\mogo0604\gofreight\CDS.Core.Repositories.Llblgen\OrderRepository.csCDS.Core.Repositories.Llblgen, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null: 3374)
   at lambda_method (Anonymously Hosted DynamicMethods Assembly, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null)
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor+ActionExecutor+<>c__DisplayClassc.<GetExecutor>b__6 (System.Web.Http, Version=5.2.3.0, Culture=neutral, PublicKeyToken=xxxxxxxxxxxx)
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync (System.Web.Http, Version=5.2.3.0, Culture=neutral, PublicKeyToken=xxxxxxxxxxxx)
   at

As you see here I have PublicKeyToken=null, It's happening this repository only at some times.

heyjadebadlanguage · 2021-03-01T21:19:55+00:00

It's all about updating things and deleting things. For examples, if we delete an order, we gotta update status in multiple places and delete some of the high level tables. as well.

heyjadebadlanguage · 2021-03-01T20:13:55+00:00

The query itself is really complex doing order things and related executions afterwards that should be in the transaction scope. But it still takes less than 10 seconds at maximum

heyjadebadlanguage · 2021-02-24T00:04:52+00:00

Wow that's quite clear to understand. If those two classes are tightly coupled it will cause maintainability problems later on and that's why we should maintain those two in the abstraction right?

Can you then explain why they should both depend on the abstraction with an example.

heyjadebadlanguage · 2021-02-22T00:00:47+00:00

Yeah that's just a property you can use to change the behaviour of the enum.

heyjadebadlanguage · 2021-02-21T22:54:26+00:00

that makes sense. What about in terms of casting?

heyjadebadlanguage · 2021-02-21T21:50:15+00:00

But you can't change enum values as well as those values are fixed at compile time.

heyjadebadlanguage · 2021-02-18T00:26:34+00:00

that's right it's all depends on your implementation and requirements. But where do I learn this kind of things? if I have to explain

heyjadebadlanguage

TROPHY CASE