{"id":396,"date":"2014-09-25T11:46:03","date_gmt":"2014-09-25T11:46:03","guid":{"rendered":"http:\/\/mairwa.com\/wordpress\/?p=396"},"modified":"2014-09-25T11:46:03","modified_gmt":"2014-09-25T11:46:03","slug":"ienumerable-vs-iqueryable","status":"publish","type":"post","link":"http:\/\/mairwa.com\/wordpress\/?p=396","title":{"rendered":"IEnumerable VS IQueryable"},"content":{"rendered":"

IEnumerable<\/h2>\n
    \n
  1. IEnumerable exists in System.Collections Namespace.<\/li>\n
  2. IEnumerable can move forward only over a collection, it can\u2019t move backward and between the items.<\/li>\n
  3. IEnumerable is best to query data from in-memory collections like List, Array etc.<\/li>\n
  4. While query data from database, IEnumerable execute select query on server side, load data in-memory on client side and then filter data.<\/li>\n
  5. IEnumerable is suitable for LINQ to Object and LINQ to XML queries.<\/li>\n
  6. IEnumerable supports deferred execution.<\/li>\n
  7. IEnumerable doesn\u2019t supports custom query.<\/li>\n
  8. IEnumerable doesn\u2019t support lazy loading. Hence not suitable for paging like scenarios.<\/li>\n
  9. Extension methods supports by IEnumerable takes functional objects.<\/li>\n<\/ol>\n

    IEnumerable\u00a0is the base interface for all non-generic collections that can be enumerated. For the generic version of this interface see\u00a0System.Collections.Generic.IEnumerable<T><\/a>.\u00a0IEnumerable\u00a0contains a single method,GetEnumerator<\/a>, which returns an\u00a0IEnumerator<\/a>.\u00a0IEnumerator<\/a>\u00a0provides the ability to iterate through the collection by exposing a\u00a0Current<\/a>\u00a0property and\u00a0MoveNext<\/a>\u00a0and\u00a0Reset<\/a>\u00a0methods.<\/p>\n

    It is a best practice to implement\u00a0IEnumerable\u00a0and\u00a0IEnumerator<\/a>\u00a0on your collection classes to enable the\u00a0foreach\u00a0(For Each\u00a0in Visual Basic) syntax, however implementing\u00a0IEnumerable\u00a0is not required. If your collection does not implement\u00a0IEnumerable, you must still follow the iterator pattern to support this syntax by providing a\u00a0GetEnumerator\u00a0method that returns an interface, class or struct. When using Visual Basic, you must provide an\u00a0IEnumerator<\/a>\u00a0implementation, which is returned by\u00a0GetEnumerator. When developing with C# you must provide a class that contains a\u00a0Current\u00a0property, and\u00a0MoveNext\u00a0and\u00a0Reset\u00a0methods as described byIEnumerator<\/a>, but the class does not have to implement\u00a0IEnumerator<\/a>.<\/p>\n

    IEnumerable Example<\/h2>\n
      \n
    1. MyDataContext dc = new MyDataContext ();<\/li>\n
    2. IEnumerable<Employee> list = dc.Employees.Where(p => p.Name.StartsWith(“S”));<\/li>\n
    3. list = list.Take<Employee>(10);<\/li>\n<\/ol>\n

      Generated SQL statements of above query will be :<\/h3>\n
        \n
      1. SELECT [t0].[EmpID], [t0].[EmpName], [t0].[Salary] FROM [Employee] AS [t0]<\/li>\n
      2. WHERE [t0].[EmpName] LIKE @p0<\/li>\n<\/ol>\n

        Notice that in this query\u00a0“top 10”<\/b>\u00a0is missing since IEnumerable filters records on client side<\/p>\n

        IQueryable<\/h2>\n
          \n
        1. IQueryable exists in System.Linq Namespace.<\/li>\n
        2. IQueryable can move forward only over a collection, it can\u2019t move backward and between the items.<\/li>\n
        3. IQueryable is best to query data from out-memory (like remote database, service) collections.<\/li>\n
        4. While query data from database, IQueryable execute select query on server side with all filters.<\/li>\n
        5. IQueryable is suitable for LINQ to SQL queries.<\/li>\n
        6. IQueryable supports deferred execution.<\/li>\n
        7. IQueryable supports custom query using CreateQuery and Execute methods.<\/li>\n
        8. IQueryable support lazy loading. Hence it is suitable for paging like scenarios.<\/li>\n
        9. Extension methods supports by IQueryable takes expression objects means expression tree.<\/li>\n<\/ol>\n

          The\u00a0IQueryable\u00a0interface inherits the\u00a0IEnumerable<\/a>\u00a0interface so that if it represents a query, the results of that query can be enumerated. Enumeration causes the expression tree associated with an\u00a0IQueryable\u00a0object to be executed. The definition of “executing an expression tree” is specific to a query provider. For example, it may involve translating the expression tree to an appropriate query language for the underlying data source. Queries that do not return enumerable results are executed when the\u00a0Execute<\/a>\u00a0method is called.<\/p>\n

          IQueryable Example<\/h2>\n
            \n
          1. MyDataContext dc = new MyDataContext ();<\/li>\n
          2. IQueryable<Employee> list = dc.Employees.Where(p => p.Name.StartsWith(“S”));<\/li>\n
          3. list = list.Take<Employee>(10);<\/li>\n<\/ol>\n

            Generated SQL statements of above query will be :<\/h3>\n
              \n
            1. SELECT TOP 10 [t0].[EmpID], [t0].[EmpName], [t0].[Salary] FROM [Employee] AS [t0]<\/li>\n
            2. WHERE [t0].[EmpName] LIKE @p0<\/li>\n<\/ol>\n

              Notice that in this query\u00a0“top 10”<\/b>\u00a0is exist since IQueryable executes query in SQL server with all filters.<\/p>\n","protected":false},"excerpt":{"rendered":"

              IEnumerable IEnumerable exists in System.Collections Namespace. IEnumerable can move forward only over a collection, it can\u2019t move backward and between the items. IEnumerable is best to query data from in-memory collections like List, Array etc. While query data from database, IEnumerable execute select query on server side, load data in-memory on client side and then filter data. IEnumerable is suitable… Read more →<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,7,11],"tags":[],"class_list":["post-396","post","type-post","status-publish","format-standard","hentry","category-c-vb","category-c","category-oop","xfolkentry"],"_links":{"self":[{"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/396","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=396"}],"version-history":[{"count":0,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/396\/revisions"}],"wp:attachment":[{"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=396"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=396"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=396"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}