Resources No resource found - LINQ Fundamentals - Single() Vs SingleOrDefault() - Part TwoApr 05, 2018. In first part we discussed First() and FirstOrDefault() extension method, In this part we will discuss Single() and SingleOrDefault().
- LINQ Fundamentals - First() Vs FirstOrDefault()Apr 04, 2018. There are four famous concepts in LINQ, almost every C# developer knows about them and has used them in their daily development work.
- ASP.NET 3D-Chart Control Sample Web ApplicationMar 21, 2018. This article shows how to make a 3D Pie chart from a datatable
- Aggregate, The True LINQ Aggregator OperatorMar 08, 2018. Aggregate LINQ operator is unknown in the LinQs world. The goal of the project is to review the LinQ Aggregators operators (Count, LongCount, Min, Max, Sum and Average), and show all operators can be built with the Aggregate operator.
- Entity Framework Core Feature - Global Query FiltersMar 02, 2018. This feature is also refer as Model-level query filters. It allows to specify filter in the model level that are automatically applied to all queries that executed on the context on the specified type. It means that entity framework automatically adds the filter in where clause before executing the LINQ queries. Usually Global query filters are applied in OnModelCreating method of context. This filters are also automatically applied to LINQ queries involving the entity types referenced indirectly like included as navigation property.
- Using jQuery DataTable To Display SharePoint 2013 List Data On SharePoint Site PagesFeb 17, 2018. In this article, we will learn how to pass SharePoint List Data to a jQuery DataTable using REST API and display SharePoint list data on SitePages using DataTable.
- Introduction To LINQ With Entity Framework In Visual StudioFeb 08, 2018. LINQ queries are similar to SQL query created for developers to maintain standardized coding approach. It deals with the data objects therefore it is similar to OOPs.
- Linq To Excel In ActionJan 29, 2018. In this post, we will demonstrate how we use LinqToExcel library to query data from Excel.
- Bind Menu And Sub Menu Dynamically In ASP.NET MVC From Database Using LINQJan 12, 2018. Many times we need to create a menu for a simple application. We ususally get stuck on how to bind the menu. Here in this article we you will learn how to bind menu and sub menu dynamically in ASP.NET MVC from database using linq.
- Filtering jQuery Data Table Server Side Using MVC And Entity FrameworkNov 27, 2017. This article explains how to work with jquery Datatable on the server side and how to use Search Textbox to do serverside filtering using MVC and Entity Framework
- How To Use ServerSide Processing With jQuery DatatableOct 29, 2017. Create one WebService to Getdata(Here I am using asp.net WebService to get data). You can see my Solution Explorer . I have two web pages and one service, and the name of the service is webService.asmx.
- How To Use jQuery Datatable In AngularOct 24, 2017. In this article I am going to explain how to use and integrate the jQuery datatable with AngularJS. DataTables is a prebuild functionality and a plug-in for the jQuery JavaScript library. It is a highly flexible tool, based upon the foundations of progressive enhancement, and will add advanced interaction controls to any HTML table.
- Excel To XML Using LINQOct 11, 2017. In this article we will show you the easiest way to convert Excel data into Xml files. There is a certain way to convert Excel file to Xml, for example using Excel Library (Com Component)
- Overview Of Let In LINQOct 09, 2017. In general, Let allows create a local variable at the LinQ query. Let has the same operation as to build local variable in a loop. The example with let hast better performance than the without let example, because the first execute one time and second two time for each item.
- CRUD Operations In MVC Using Entity Framework With AJAX Call, jQuery, And All ValidationsSep 19, 2017. This article describes how to perform basic CRUD operations in an Asp.Net MVC application using Entity Framework with Ajax call and j query.
with using Datatable Grid ,Toaster messagebox and also Bootstrap css.
- Two Ways To Get Data From Entity FrameworkSep 15, 2017. In this article, you will learn about two basic ways to get data from Entity Framework and display data in angular UI-Grid using MVC application with Web API.
- Use Of Union, Intersect, Distinct And Except In LINQSep 01, 2017. Here, you will learn the uses of Union, Intersect, Except, and their differences, To get a clear picture, we will go with examples.
- Use Of Deferred And Immediate Query Execution In LINQAug 31, 2017. Here, you will see about query execution in linq and what is deffered query execution, what is immediate query execution and it's differences, we will see with example for better understanding.
- Responsive GridView Using DataTables Plug-inAug 24, 2017. In this article, we will learn how to make an ASP GridView responsive using jQuery based DataTables plug-in.
- Use Of Range, Repeat And Empty In LINQAug 21, 2017. Here, we are going to see the uses of the Range,Repeat and Empty keywords in LINQ and we also will discuss their differences.
- Element Operators In LINQAug 17, 2017. Here, we will learn about Element Operators, their uses, and various element operators.
- Use Of Into And Let In LINQAug 07, 2017. Here, we going to see the uses of Into and Let keywords in LINQ and their differences.
- DataTable In Xamarin iOSJul 27, 2017. In this article, you will learn how to Store Values Using DataTable in Xamarin iOS, using Xamarin Studio.
- Learn MVC : Using Angular And Web API And Deploy To IISJul 26, 2017. Open any MVC using Angular application in Visual Studio 2017. Here I am going deploy my previous application from “Learn MVC Using Angular Dynamic Control in DataTable”.
- Learn MVC Using Angular Dynamic Control In DataTableJul 26, 2017. In this article, we will learn MVC using Angular data binding for dynamic control in datatable from server side Web API using visual studio 2017.
- Change SharePoint ListView To jQuery Datatable Using JSLinkJul 21, 2017. Jslink is javascript link [ CSR - Client-side rendering] this feature was introduced in Sharepoint 2013 for customizing Sharepoint list forms Newform, displayform, editform. Using this feature you are able to change the overall look and feel of the sharepoint listp
- How To Use Joins, and Group By Clause In Entity Framework With LINQ C#Jul 15, 2017. In this article will be going to learn How to use Joins, and Group By Clause in Entity Framework with Linq C#
- Writing Complex Queries Using LINQ And LambdaJun 22, 2017. I am writing this article based on request by some developers regarding how to write some complex queries using LINQ & Lambda expression which consist of joins / groupby / aggregate functions
- Code Improvement Techniques In C#Jun 13, 2017. General code improvement technique over string.empty, string.Equals, string.Intern, StringBuilder, string.Format, case insensitive comparisons, using Block and Linq - First, FirstOrDefault, Single and SingleOrDefault. Main focus points are - what are the advantages and the purpose to use these.
- Learn MVC Using Angular WizardJun 04, 2017. In this article, you will learn MVC, using Angular DataTable.& Angular Wizard
- LINQ Basic To Advanced - MVC Demo ApplicationMay 16, 2017. Here, in this post, we are going to see some basic and advanced LINQ queries
- Learn MVC Using Angular DatatableMay 10, 2017. In this article, you will learn MVC, using Angular DataTable.
- What Is Deferred/ Lazy Loading And Eager Loading?Apr 28, 2017. In his article, you will learn about Deferred/ Lazy Loading and Eager Loading.
- A Brief Introduction To LINQApr 27, 2017. Introduction to LINQ.
- LINQ Extended JoinsApr 24, 2017. This article illustrates LINQ extended joins.
- Aggregate Function With LINQ In C#Apr 11, 2017. In this article, we going to see about how to use the aggregate function with LINQ.
- AngularJS DataTable With Web APIMar 30, 2017. In this article, you will get to know about AngularJS DataTable with Web API.
- Bind SharePoint List Data Into JQuery Datatable Using Content Search Web Part (CSWP) In SharePoint Server 2013Mar 06, 2017. In this article, I have explained how to create a jQuery datatable using content search web part (CSWP) to bind data in SharePoint server 2013.
- Bulk Upload In .NET CoreJan 30, 2017. In this article, you will learn about bulk uploading in .NET Core, using SQLBulkCopy without any DataTable.
- LINQ To SQL - CRUD OperationsJan 19, 2017. In this article, we will see LINQ to SQL CRUD Operations.
- Get Data From Multiple Tables Using Parameters While Combining LINQ ExpressionsJan 11, 2017. In this article, you will learn how to get data from mutliple tables using parameters when combining LINQ expressions in ASP.NET MVC 5.
- Convert DateTime To String Format Using IQueryableJan 10, 2017. In this article, you will learn how to convert DateTime to string (yyyy/mm/dd) format in ViewModel/Whatever class with IQueryable.
- Overview Of Concurrency In LINQ To SQLJan 10, 2017. In this article, you will learn about concurrency in LINQ to SQL.
- Lazy Loading And Eager Loading In LINQ To SQLJan 08, 2017. In this article, you will learn about Lazy Loading and Eager Loading in LINQ to SQL.
- Identity Cache In LINQ To SQLJan 08, 2017. In this article, we will see what identity cache is and its impact on LINQ to SQL queries.
- Compile Queries And Execute SQL Queries Using LINQ To SQLJan 08, 2017. In this article, you will learn how to compile queries and execute SQL queries, using LINQ to SQL.
- Single Table Inheritance In LINQ To SQLJan 07, 2017. In this article, we will see single table inheritance in LINQ to SQL.
- How To View LINQ To SQL Generated SQL Queries And Using Stored Procedures With LINQ To SQL Jan 02, 2017. In this article, you will learn how to view LINQ to SQL generated SQL queries and use stored procedures with LINQ to SQL.
- Stored Procedure With Output Parameters In LINQ To SQL And What SQLMetal IsJan 02, 2017. In this article, you will learn how to call a stored procedure with output parameters using LINQ to SQL.
- How To Use LINQ To SQL For Retrieving Data From SQL Server DatabaseJan 01, 2017. In this article, we will learn how to use LINQ to SQL to retrieve data from the SQL server database.
- CRUD Operations Using LINQ To SQLJan 01, 2017. In this article, you will learn about CRUD operations using LINQ to SQL.
- Introduction To LINQDec 26, 2016. In this article you will learn an introduction to LINQ.
- More On C# DataTableNov 30, 2016. This article describes what DataTable is, and its uses.
- Introduction To Generic IEqualityComparerNov 20, 2016. In this article, you will learn about Generic IEquality Comparer.
- Data Binding To JSON Data In AngularJS DatatableSep 23, 2016. In this article, you will learn about Data Binding to JSON Data in AngularJS Datatable.
- Data Grouping In AngularJS Datatable Using ASP.NET MVC 5Sep 16, 2016. In this article you will learn about Data Grouping in AngularJS datatable, using ASP.NET MVC 5.
- Bind Add Update Delete Data Using MVC Entity Framework And LINQAug 29, 2016. In the article, you will learn how to add, update, and delete data, using Entity Framework and LINQ. This is for the beginner users like me in MVC.
- LINQ to SQL - Basic Guide To Perform Fetch, Filter, Insert, Update And DeleteAug 25, 2016. In this article, you will learn the basic guide to perform fetch, filter, insert, update and delete in LINQ to SQL.
- Diving Into Visual Studio 2015: Debugging Improvements (Tool Window Support for LINQ and Lambda) - Day SixMay 29, 2016. In this article, you will learn about Debugging Improvements In Visual Studio 2015.
- LINQ to SQL Using Visual StudioMay 18, 2016. In this article you will learn about LINQ to SQL using Visual Studio.
- Export To Excel Data By LINQ to SQLApr 11, 2016. In this article we will see how to get data from LINQ to SQL query and export to excel.
- LINQ - Partitioning OperatorsApr 04, 2016. In this article you will learn about Partitioning Operators in LINQ. We will learn about LINQ Partitioning Operators: Skip, SkipWhile and Take, TakeWhile.
- Stored Procedure with LINQ to SQLMar 30, 2016. In this article you will learn how to work with stored procedure with LINQ to SQL.
- An Overview Of LINQMar 30, 2016. In this article you will get an overview of LINQ.
- Some Useful LINQ Query OperatorsMar 24, 2016. In this article you will get to know about some useful LINQ Query Operators.
- Nullable Types And Null Coalescing Operator In C#Feb 27, 2016. In this article you will learn about nullable types and the null coalescing operator in C#. We will also see its use in LINQ queries.
- jQuery Datatable With Server Side DataFeb 22, 2016. In this article we will learn how to work with jQuery Datatables with server side data.
- SQL Join Query With LINQFeb 22, 2016. In this article, I will show you how to make your query in SQL and the same query in Linq.
- Lookup In LINQFeb 06, 2016. In this article I am going to discuss what lookup in LINQ is and will compare it withthe dictionary.
- Beginners Guide For Expression Trees In C# - Understanding ExpressionsFeb 02, 2016. In this article you will get a beginners guide for Expression Trees in C#.
- LINQ: Handling Of Array, List Object And GROUP BY Feb 02, 2016. In this article you will learn about handling of array, List Object and GROUP BY.
- Create Dynamic LINQ Using ExpressionsFeb 02, 2016. In this article you will learn how to create Dynamic LINQ using Expressions.
- Joins In LINQFeb 01, 2016. In this article I am going to discuss different types of joins in LINQ.
- Fetch RSS Feed Content From LINQ To XMLJan 30, 2016. In this article we are going to fetch content from LINQ to XML classes and manipulate XML atom feed and get their elements.
- How To Bind GridView Using LINQ To SQLJan 25, 2016. In this article I will cover the basics of creating DBML (LINQ to SQL ) class to get data and fill into the ASP GridView Control to fill, bind, and show the data.
- JQuery DataTable - Paging, Sorting, Searching In ASP.NET from Code Behind Jan 25, 2016. In this article you will learn about Paging, Sorting, Searching with JQuery DataTable in ASP.NET.
- Bind GridView Using DataTableJan 23, 2016. In this article we will see how to bind GridView Control from DataTable.
- Introduction To LINQJan 16, 2016. In this article you will learn about an introduction of LINQ and styles of writing LINQ queries.
- Export Files In Excel Using EPPlus And LINQJan 13, 2016. In this article I have demonstrated how to export file in Excel format using LINQ to SQL and EPPlus dll in an easy way.
- CRUD Operation With GridView Using LINQ And Lambda ExpressionsJan 06, 2016. In this Article, I am going to explain the DML Operation on GridView using LINQ to SQL Classes.
- Evolution Of Microsoft Data Access TechnologiesDec 31, 2015. This article beams on how Microsoft data access technologies evolved over the period of time.
- Work With LINQ TO SQL To Perform CRUD OperationDec 25, 2015. In this article I am explaining the step to work with LINQ to SQL for performing CRUD Operation.
- Paging Sorting Searching In ASP.NET MVC 5Dec 25, 2015. In this article we will learn how to do Sorting, Paging and Searching In ASP.NET MVC 5.
- Work With LINQ To SQLDec 24, 2015. In this article I am explaining the steps to work with LINQ to SQL for displaying the data in DataGridView.
- Using JQuery DataTableDec 06, 2015. In this article I will explain how to use JQuery DataTable.
- Use LINQ To SQL On Web FormNov 29, 2015. In this article I will explain how to use LINQ TO SQL on web form.
- Convert DataReader To DataTableNov 18, 2015. In this article we will learn how we can convert Microsoft ADOMD DataReader to DataTable.
- Using jQuery DataTable In SharePoint 2013 Nov 01, 2015. Here you will see how can we use jQuery DataTable in SharePoint 2013.
- Querying Wikipedia In ASP.NET Using LINQ-to-WikiOct 28, 2015. In this article you will learn querying Wikipedia in ASP.NET using LINQ-to-Wiki.
- Generating An MD5 Hash From A String Using LINQOct 27, 2015. In this article you will learn how to generate an MD5 Hash from a String Using LINQ.
- ADO.NET Technique With ASP.NETOct 13, 2015. In this article, I will explain ADO.NET concepts that include DataTable, DataSet, DataReader and DataAdapter.
- CRUD Operations Using LINQ to SQL In ASP.NETSep 23, 2015. In this article I will show you step by step road map of creating an ASP.NET application.
- CRUD Operation Using LINQ To XML DocumentsSep 21, 2015. This article is about creating an ASP.NET website having CRUD operation using LINQ to XML documents.
- Best LINQ BookSep 14, 2015. So you want to learn LINQ programming? This article talks about LINQ resources and one of the best book I have read on LINQ.
- 3 Ways to Convert DataTable to JSON String in ASP.NET C#Aug 19, 2015. This article explains how to convert a DataTable to JSON in ASP.NET C#.
- CRUD Operations With LINQ to SQL in ASP.NetJul 28, 2015. In this article you will learn about CRUD operations with LINQ.
- ASP.Net MVC CRUD Operations Using jQuery JSON and LINQ To SQL ClassJul 25, 2015. In this article you will learn about MVC CRUD operations with jQuery JSON.
- Show Database Values in Table Using MVC RazorJul 16, 2015. This article explains how to retreive values from a database using a Stored Procedure and bind the data to a DataTable using a MVC Razor view.
- Populate Excel Files From Data SourceJul 03, 2015. This article shows how to use Visual Basic .NET, together with Excel Interops, to connect to a data source and extract information to be imposed to an existing Excel model. In other words, how is it possible to write a simple Excel reporting software.
- Dynamic LINQ Query In C# Using Predicate BuilderJun 23, 2015. This article explains how to create a dynamic LINQ query in c# using Predicate Builder.
