What is Difference between IEnumerable and IQueryable

 

IEnumerable
1. Enumerable represent data records in-memory collection. IEnumerable doesn’t move between items, it is forward only collection.
2. IEnumerable are found in a System.Collections Namespace.

IQueryable
1. When querying data from out-memory (like remote database, service) collections so you are use IQueryable.
2. IQueryable are found in a System.Linq Namespace.

Comments

Post a Comment

Popular posts from this blog

How to publish iPhone app on App store using Xamarin or visual studio.

Following steps required to publish iPhone app on Apple store using Xamarin or visual studio. # Need to arachive Xamarin.iOS build using Build menu or Right click the project .iOS project and select Archive menu from context menu popup. Once Archiving process done it show .ipa file in Archive windows. Before clicking on Sign and Distribute make sure you configured certificate and provisoning profile.If you did not setup earlier you can create using these steps. # Creating a Distribution Certificate and .p12 File A distribution certificate identifies your team/organization within a distribution provisioning profile and allows you to submit your app to the Apple App Store. . On your Mac go to the folder Applications > Utilities and open Keychain Access. On your Mac go to the folder Applications > Utilities and open Keychain Access. 2. Go to Keychain Access > Certificate Assistant > Request a Certificate from a Certificate Authority. Go to Keychain Access > Cert...
Read more

DMA - A safe way to migrate SQL Server database objects

Image
SQL Server database objects migration was not so easy earlier as of now with the help of DMA(Data Migration Assistant). The Data Migration Assistant (DMA) which is a free tool from Microsoft. DMA helps us to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database. DMA recommends performance and reliability improvements for your target environment and allows you to move your schema, data, and uncontained objects from your source server to your target server. The DMA assessment workflow detects Migration blocking issues,Partially supported or unsupported features,compatibility issues (Breaking changes,Behavior changes,Deprecated features) and suggests feature recommendations(Performance,Security,Storage). References :- https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-2017 https://channel9.msdn.com/Shows/Data-Exposed/First-Look-at-the-new-SQ...
Read more