Resources No resource found - Pull Distinct Data Using LINQ-to-XMLNov 06, 2012. Today, in this article let’s play around with one of the interesting and most useful concepts in XML.
- 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.
- How To Insert Bulk Records Into SQL Server Using XML Data TypeMar 11, 2018. Sometimes, there is a need to insert bulk records into a database. In some cases, we have multiple unique records and that all needs to be inserted into the database. Instead of hitting the database for each record, we need to insert bulk records into database.
- 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.
- Liquid Templates In Logic AppsMar 05, 2018. Azure Logic Apps support basic JSON transformations through native data operation actions such as Compose or Parse JSON. For advanced JSON transformations, we can use Liquid templates with our logic apps. Microsoft has released the support of Liquid Templates to transform JSON and XML objects.
- 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.
- Web Services Using C# - Creating Web ServicesFeb 19, 2018. An XML Web service should be identified by a namespace that is controlled by its company. For example, a company's Internet domain name could be used as part of the namespace. Although many XML Web service namespaces look like URLs, they need not point to actual resources on the Web.
- 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.
- How Can You Integrate A JSON Framework With iOSFeb 01, 2018. JavaScript Object Notation, or JSON in short, is commonly used for representing structural data and data interchange in client-server applications, serving as an alternative to XML. It has grown in popularity as it is simple to use and human-readable. It is technically a part of the JavaScript language and provides a way to serialize JavaScript objects. It is supported in a wide variety of programming languages. A lot of the services used every day have JSON-based APIs.
- How To Validate XML Using XSD In C#Jan 29, 2018. Extensible Markup Language (XML) is used to describe data. The XML standard is a flexible way to create information formats and electronically share structured data via the public Internet, as well as via corporate networks. The XML tags are not pre-defined in XML. You will have to create tags according to your needs.
- 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.
- Generating XML Root Node Having Colon-Via SerializationDec 20, 2017. This article discusses some of the issues faced while generating an XML on the fly with some defined schema.
- Documenting ASP.NET Core 2.0 Web APIDec 20, 2017. Documents generated by Swagger can include XML documentation.
- What XSLT Transformation Is And How To Use ItDec 12, 2017. XSLT (Extensible Stylesheet Language Transformations) is a language for transforming XML documents into other XML documents. Sometimes the user wants to some kind of xml structure instead of whole xml; In that case we can use XSLT transformation. This article gives us idea about this.
- Convert XML File To Excel FileNov 27, 2017. Here, we are going to learn to read XML files in C# WindowsForm applications. We are going to make a small single-form application which takes an XML file from the user and convert XML Data to Excel Data and Returns an Excel File.
- Creating CRUD API In ASP.NET Core 2.0Nov 17, 2017. ASP.NET Core gives a unified mechanism for creating MVC and Web API application. The key difference is that Web API will return JSON (or XML) and HTTP status codes instead of views, in order to communicate with the client.
- Create App Using Xamarin.Android Using C# - Part FourNov 17, 2017. Xamarin.Android has native user interface controls. These controls can be easily added to Xamarin.Android apps using the Android Designer or programatically via XML layout files. Xamarin.Android exposes all of the user interface object properties and methods in C#.
- 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.
- Xamarin.Forms - Create MVVM Data Binding Application Oct 07, 2017. Xamarin Forms Platform using Create MVVM Data Binding application using xml and c# code
- 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.
- Construct Readable XML Output From SQL Query From Two Or More Tables Using “For XML PATH” StatementSep 04, 2017. In my previous article I discussed about how to get a XML format output from query and process that by using XML AUTO statement, and I give different types of “for XML”.
- How To Perform Web Scraping Using Python ProgramSep 04, 2017. Web Scraping (also known as Screen Scraping, Web Data Extraction, Web Harvesting etc.) is a process to scrap (extract) data from web pages, web document, HTML document or XML document in a structured manner and then store in database, text file as a spreadsheet , as a XML , or in whatever file format we want to save in.
- 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.
- Working With JSON In SQL Server 2016Aug 28, 2017. JSON (JavaScript Object Notation) is a lightweight data interchange format. It is language independent, easy to understand and self-describing. It is used as an alternative to XML. JSON is a very popular data interchange format nowadays. Most modern services return the data into the JSON text.
- Transform XML Output Of SQL Query To HTML Using "For XML" AUTO Statement With XSLT In C#Aug 21, 2017. Normally, we execute the query using ExecuteNonQuery statement and fill the output into data table. This article describes how to transform the XML output of SQL query statements using FOR XML AUTO to HTML using XSLT.
- 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.
- Accessing XML Data From XML Document In C# Console ApplicationAug 09, 2017. In this article, I am going to give the best way to access XML data from XML document and also how to find common record node counts.
- 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.
- 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#
- Working With XML In Windows PowerShellJun 23, 2017. In this article, you will learn about XMLs In Windows PowerShell.
- 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
- Implementation Of XML Serialization And Data Contract Serialization Utility In .NETJun 17, 2017. Basic Idea about DeSerializer and Serializer; advantages and disadvantages of XmlSerializer and DataContractSerializer; implementation XML and DataContract Serializer/ De-Serializer.
- 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.
- LINQ Basic To Advanced - MVC Demo ApplicationMay 16, 2017. Here, in this post, we are going to see some basic and advanced LINQ queries
- How To Use And Bind Chart Control In ASP.NET With XML DataMay 07, 2017. In this tutorial, I will show you how to use and bind Chart Control and its relevant properties in ASP.NET, using C# with XML data source.
- 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.
- Create WCF Web Service In Visual Studio 2015Apr 18, 2017. In this article, you will learn how to create your first REST based XML Web Service in Visual Studio 2015.
- 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.
- Parse/Read XML Having Nested Nodes To Display As A List In ASP.NET MVCMar 03, 2017. In this article, you will learn how to parse/read XML having nested nodes, to display as a List in ASP.NET MVC.
- Creating Dialog Fragment Using Xamarin AndroidJan 31, 2017. This article explains how to create Dialog Fragment using the Login System UI design and understanding of C# codes and XML files.
- Create User Interface Programmatically In Android ApplicationsJan 22, 2017. In this article, we will learn to create a user interface using code. So far, we have seen all the UI's that you have created, using XML file. But we can create the user interface programmatically.
- 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.
- Overview Of Concurrency In LINQ To SQLJan 10, 2017. In this article, you will learn about concurrency in LINQ to SQL.
- 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.
- 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.
- Password Strength Indicator With NuGet PackageJan 03, 2017. In this article, you will learn about the password strength indicator using jQuery and XML + NuGet Package.
- 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 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.
- CRUD Operations Using LINQ To SQLJan 01, 2017. In this article, you will learn about CRUD operations 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.
- Introduction To LINQDec 26, 2016. In this article you will learn an introduction to LINQ.
- XML Manipulation In C#Dec 12, 2016. This article describes how to add, delete, update, and select nodes in XML in C#.
- Introduction To Generic IEqualityComparerNov 20, 2016. In this article, you will learn about Generic IEquality Comparer.
- 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.
- Display XML Data As HTML Using XSLT In ASP.NET MVCAug 28, 2016. This article describes how to display XML data as HTML using XSLT in ASP.NET 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.
- Opening file from location: AppxManifest.xml failed with error: Access is denied.Aug 14, 2016. How to solve error, opening file from location: AppxManifest.xml failed with error: Access is denied.
- Closed XML To Read Excel Files In ASP.NET C#Aug 11, 2016. In this article, you will learn, how to close XML to read Excel files in ASP.NET C#.
- Open XML SDK To Read Workbook With Multiple WorksheetsAug 11, 2016. In this article, you will learn how to open XML SDK to read a workbook with multiple worksheets.
- Different Ways Of Reading XML Files In ASP.NET C#Aug 10, 2016. In this article, you will learn about different ways of reading XML files in ASP.NET C#.
- XML CRUD (Create Read Update Delete) Operation Using MVCJul 28, 2016. This article includes a step by step tutorial to learn CRUD operation in XML file, using MVC in Visual Studio.
- Read Excel Files Using Open XML SDK In ASP.NET C#Jun 17, 2016. In this article you will learn how to read excel files using open XML SDK in ASP.NET C#.
- From Zero To Hero In JSON With C#Jun 09, 2016. In this article, you will learn about JSON with C#.
- Getting Started With ASP.NET Web Services - Part OneJun 08, 2016. In this article, you'll learn about how we can create ASP.NET Web Services.
- 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.
- Voice of a Developer: Parse JSON - Part 28May 18, 2016. In this article you will learn how to parse JSON in JavaScript. This is part 28 of the article series.
- LINQ to SQL Using Visual StudioMay 18, 2016. In this article you will learn about LINQ to SQL using Visual Studio.
- Itextsharp In C#May 15, 2016. In this article you will learn how to create documents and reports based on data from database or XML file and Merge or split.
- Display Live RSS Feeds In XML Viewer Web Part Using Custom XSLTMay 15, 2016. In this article you will learn how to display Live RSS Feeds in XML Viewer Web Part using Custom XSLT.
- SQLite CRUD Operation In WinJS: Windows AppsMay 10, 2016. In this article, we are going to learn SQLite CRUD (Create, Read, Update, Delete) operations in WinJS project with the help of Class Library and Windows Runtime Component.
- Has JSON Overtaken XMLMay 10, 2016. This article gives you the overview of JSON and how it is used in the current data transmission in the modern world between applications and UI.
- Read XML file in WinJS Project using Windows Runtime ComponentMay 07, 2016. In this article, we are going to learn how to read XML file in WinJS project.
- Inserting List of Records into Single SQL Column As XML File In ASP.NET MVCApr 24, 2016. In this article we will learn how to insert list of records into SQL table single column as XML files in ASP.NET MVC.
- What is XML And How To Use XML in PHPApr 14, 2016. This article shows an overview of XML and how to use XML in PHP.
- How To Paste JSON As Classes Or XML As Classes in Visual StudioApr 13, 2016. In this article, I will explain you how to paste JSON or XML as classes in Visual Studio.
- Convert Generic List Into XML In ASP.NET MVCApr 12, 2016. In this article we will learn how to convert generic list which is created from model class Into XML In ASP.NET MVC
- 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.
- Read XML File In Windows 10 Universal AppApr 11, 2016. In this article we are going to see how to load local HTML files in Windows 10 universal app.
- Create Fragments From XML File In AndroidApr 05, 2016. This article is for Fragments, the most important part of Android Application Development. Here, I am describing the first step of adding Fragments in Android.
- 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.
- XML Data Type In SQL ServerFeb 24, 2016. In this article we will read about xml data type and also some advantages and limitations of xml data type over relational data types.
- Create a Custom Code Snippet In Visual Studio 2015Feb 22, 2016. In this article, we will look into steps to be followed for creating and registering a custom code snippet for C# in VS 2015.
- 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.
- Create RSS Feeds For Your Blog or WebsiteFeb 18, 2016. In this article you will learn how to create RSS feeds for your blog or website.
- Lookup In LINQFeb 06, 2016. In this article I am going to discuss what lookup in LINQ is and will compare it withthe dictionary.
