Follow us

This Thread may be Removed Anytime!

Twitter may remove this content at anytime! Save it as PDF for later use!

More from @mwaseemzakir

Muhammad Waseem

@mwaseemzakir

Apr 17

💡 NULL Operators Guide in C#

- Ternary Operator (? :)

- Null Forgiving Operator (!.)

- Null Conditional Operator (?.)

- Null Coalescing Operator (??)

- Null Coalescing Assignment Operator (??=) 🧵⏬

#dotnet

Ternary Operator or Conditional Operator(?.) is used to evaluate a condition and then we can do something on that basis for true and false

#dotnet

Null Forgiving or Null Suppression Operator (!.) is used to suppress all nullable warnings for preceding expression. It has no effect on runtime

#dotnet

Read 7 tweets

Muhammad Waseem

@mwaseemzakir

Mar 22

💡IEnumerable vs IQueryAble in .NET

1) Whatis IEnumerable
2) What is IQueryAble
3) Difference b/w them ⏬

#csharp #dotnet

IEnumerable and IQueryable interfaces are both used to work with collections of data and both support LINQ (Language Integrated Query)
#dotnet

𝐈𝐐𝐮𝐞𝐫𝐲𝐚𝐛𝐥𝐞

✅ IQueryable executes queries on the server side.

✅ It is designed specifically to work with LINQ

✅ It extends IEnumerable, which means it includes all of the functionality of IEnumerable.
#dotnet

Read 7 tweets

Muhammad Waseem

@mwaseemzakir

Mar 21

💡Tracking vs Non Tracking Queries in .NET
1) Tracking Queries
2) Non Tracking Queries
3) Identity Resolution
4) How to set tracking by default for context🧵🔽
#dotnet

𝐓𝐫𝐚𝐜𝐤𝐢𝐧𝐠 : By default all queries are tracked , so behind the seen a change tracker keeps working on each entity. If you want to perform Update/Delete then you should use tracking.
#dotnet

𝐍𝐨𝐧 𝐓𝐫𝐚𝐜𝐤𝐢𝐧𝐠 : If you just need read only data then you don't need your queries to keep tracking of change , you can simply go with no tracking and help the query run more speedy.
#dotnet

Read 7 tweets

Muhammad Waseem

@mwaseemzakir

Mar 20

💡Global Error Handling in .NET ?
1) Why we need it
2) Pros and cons
3) Code implementation🧵🔽

#dotnet

While working with .NET application we sometime come up with exception and we can deal with it in two ways , either by using try catch block in each class (controller level or service level) or we can define a centralized and global point to catch the exception.
#dotnet

♉ Pros of using Global Exception

1. It provides us a centralized error handling point and makes easier for us to manage.

2. Code readability is improved as we get rid of writing try-catch code in each method
#dotnet

Read 5 tweets

Muhammad Waseem

@mwaseemzakir

Mar 13

💡 Life of Query in EF

𝐒𝐭𝐞𝐩 𝟏 : The LINQ Query is processed by EF Core and build an representation that is processed by database provider, and the result is cached later on so we don't need to process it every time #dotnet

See thread 🧵⏬

𝐒𝐭𝐞𝐩 𝟐 : The result is passed to the db provider and db provider identifies which parts of query can be evaluated in db, these parts are then translated into query language (e.g. SQL) after that translated query is sent to db and db returns results (but not entity instances)

𝐒𝐭𝐞𝐩 𝟑 : For each item we check if it is tracking query EF checks the data in existing change tracker if found relevant entity is returned else new is created, its change tracking get set up and it is returned

For non tracking a new entity is always created and returned.

Read 5 tweets

Muhammad Waseem

@mwaseemzakir

Mar 12

💡 7 Tips to write better LINQ Queries

𝐔𝐬𝐞 𝐨𝐟 𝐀𝐬𝐍𝐨𝐓𝐫𝐚𝐜𝐤𝐢𝐧𝐠 : For read only queries e.g. (GetAll,GetById etc.) use AsNoTracking , when we use it entities are not tracked for change so it brings data more speedily. #dotnet

See thread 🧵🔽

𝐈𝐧𝐜𝐥𝐮𝐝𝐞 𝐧𝐞𝐜𝐞𝐬𝐬𝐚𝐫𝐲 𝐄𝐧𝐭𝐢𝐭𝐢𝐞𝐬 𝐚𝐧𝐝 𝐂𝐨𝐥𝐮𝐦𝐧𝐬 : While retrieving data from multiple table make sure to include only necessary tables and columns Use eager loading only when it is necessary.
#dotnet

𝐅𝐨𝐫 𝐥𝐚𝐫𝐠𝐞 𝐝𝐚𝐭𝐚 𝐮𝐬𝐞 𝐒𝐤𝐢𝐩 𝐚𝐧𝐝 𝐓𝐚𝐤𝐞 : Use skip and take to retrieve data from table for large collections because if we try to bring all data in single try it can take time that will give bad user experience takes next values.
#dotnet

Read 8 tweets

Share this page!

Enter Twitter Thread URL to Unroll

Muhammad Waseem

People who liked this thread also liked...

Try unrolling a thread yourself!

More from @mwaseemzakir

Muhammad Waseem

Muhammad Waseem

Muhammad Waseem

Muhammad Waseem

Muhammad Waseem

Muhammad Waseem

Did Thread Reader help you today?

Don't want to be a Premium member but still want to support us?

Send Email!