Asp.Net MVC

What is Full-Text Search? Implementing SQL Server Full-Text Search In An ASP.NET MVC Websites With Entity Framework

Hello Busy MVC Developers! Today here, I am going to introduce What is Full-Text Search in SQL Server? and How do we can implement modern products searching options in ASP.NET MVC eCommerce websites with Entity Framework for .NET MVC developers. What is Full-Text Search in ASP.NET eCommerce Websites? In easy terms, Full-Text Search depends on the indexing of character information, creating it lots faster to perform matches against the index than the scans needed by the SQL statements that use sort predicate. Full-Text looking is additionally plenty more flexible than using sort predicate, that solely supports the wildcard operator. [...]

By | 2017-07-03T15:39:40+00:00 April 24th, 2017|Asp.Net MVC, E-Commerce, SQL Server|

How to Make ComplexType of Dynamic Query in Entity Framework?

 Introduction: This article applies to those developers who use visual studio tools and Entity Framework for developing an MVC application, Here I am going to explain my problem which I face during the development of an MVC application using Entity Framework. Problem: Earlier when I write a simple procedure for my application, I easily make the ComplexType without any problem. but after sometimes I need to make that procedure dynamic, I have made the change in procedure. So that, it returns the result what I expect. But problem is that entity framework doesn't provide me complexType for a dynamic procedure. [...]

By | 2017-07-03T15:57:30+00:00 March 3rd, 2017|Asp.Net MVC|

Schedule Windows Service or Console App using Microsoft SQL JOB

First of all, What is a SQL JOB? Let me explain, a JOB is a specified series of actions that SQL server agent performs. Use JOBs to define an administrative task and it can be run one or many as times and monitored either success or failure. A SQL JOB can run on one local or multiple remote servers. That's it. NOW! Suppose we want to run windows application on a specific time interval. Especially, There is one way to create a job scheduling using Quartz and here I am going to introduce one another way which is not commonly [...]

By | 2017-04-03T11:53:07+00:00 February 14th, 2017|Asp.Net, Asp.Net MVC|

What is ASP.NET Core? Advantage(Pros) of ASP.NET Core Technology

Introduction to ASP.NET Core: The asp.net core is new Modular web framework of Microsoft and .net community which run with windows.Net Framework and cross platform like Mac, Linux. Asp.Net Core is open source and support cross platform with introducing CLI (Command Line Application (dotnet.exe)). Asp.Net core (In Past known as vNext) is base on ASP.NET core and we can develop and deploy on Windows, Mac, and Linux. And ASP.NET core also used in Mobile, Cloud, IOT based Solution and Mobile Back-end. Asp.Net core also provides Cloud base environment. [...]

By | 2017-09-08T11:26:25+00:00 January 28th, 2017|Asp.Net, ASP.NET Core, Asp.Net MVC|

ASP.NET MVC Verify if Minification of CSS is Working Properly or Not?

In this article we are discussing how to verify minification of CSS is working or not in Asp.Net MVC. First of all, what is Minification in Asp.Net? Minification is the technique you can use in ASP.NET to improve request load time. Minification improves loading time by reducing the number of requests to the server. Hence it reducing the size of requested CSS and JavaScripts. Minification performs a lot of different coding optimizations to CSS, such as removing unnecessary white space, comments and shortening variable names to one character. Now, Our main issue is How to verify if minification of CSS [...]

By | 2017-07-03T16:28:13+00:00 January 28th, 2017|Asp.Net MVC|

Retrieve more than 1000 Records from Microsoft Dynamics GP customer

Here is the trick for MS Dynamics GP programming. The first thing, there is no any paging facility provide in Microsoft GP. And Microsoft GP API calls return 1000 record, but what if you want to load all the data. Let's we take one example for deeply understand.   Suppose, If you have 10,000 customer records in the RM00101 table, you will only receive the first 1000 of them when you call the GetCustomerList method with no criteria, now, what to do if you want to receive remaining data.   Here is the sample C# code for Customer List [...]

By | 2017-07-03T16:45:56+00:00 January 20th, 2017|Asp.Net, Asp.Net MVC, Microsoft Dynamics GP|

Challenges in Microsoft Dynamics GP integration with Magento

Introduction In this article, I am going to put some light on different ways to connect Microsoft dynamics GP from Magento, Magento is using PHP language. So, I am going to show different integration options available for a PHP developer to integrate with Microsoft Dynamics GP. Microsoft Dynamics GP provides two types of web services Legacy Service Native Service Why has MS Dynamics GP two services? First of all, what ASMX web service? Basically, ASMX web services are easy to use and are hosted on Microsoft Internet Explorer (IIS). This web service is developed in 2001-2002 when .net framework 1.1. Now [...]

By | 2017-07-04T10:21:24+00:00 October 12th, 2016|API Integration Services, Asp.Net MVC, Microsoft Dynamics GP|

Enable theme customization dynamically in ASP.Net MVC

Introduction for Theme Customization in ASP.Net MVC In ASP.Net MVC Theme Customization Dynamically, User able to customize the theme on the website through custom theme's settings from the admin panel to change the theme color, backgrounds, side panels, custom menus, portfolios and more functionality of the website using LESS file in ASP.Net MVC. For example, To set two types of colors, one is a light colored theme and another is a dark colored theme. User able to change theme color using Less files and it will be reflected in the whole theme in ASP.Net MVC. Here we are using LESS [...]

By | 2017-09-20T11:59:25+00:00 October 8th, 2016|Asp.Net, Asp.Net MVC, CSS, Theme Customization|

Preview website on dummy DNS – Website Testing without DNS Migration

In this article, I will show you how to test and preview website on your local network or local PC without registering a domain name or worrying about DNS migration time. This is the time-saving trick for preview website on dummy DNS without affecting to website data or designing. Here we are going to mention all the steps to create dummy domain name system(dummy DNS) without registration with the screenshot. So that you can check the live website preview on local DNS, most important for showing your developed website to clients and share URL through which client able to test [...]

By | 2017-07-03T20:07:59+00:00 October 4th, 2016|Asp.Net, Asp.Net MVC, nopCommerce, Tips and Tricks|

Deadlock in the Entity Framework(EF6) Issue Resolved – SQL Server Solution

How to prevent and resolve deadlock problem in SQL Server? In this article, I will share how do I solve entity framework deadlock issue. Recently, I faced one common but a big issue related to deadlock in the entity framework(EF6). we are working on the entity framework as data access layered project. Project based on job scheduling using background services, having SQL server operations like add, update, delete etc. Using SQL server transaction of entity framework(EF) which is update data in more than 10 tables in a single transaction. So that, we are driving SQL server data from those [...]

By | 2017-11-14T16:46:46+00:00 October 3rd, 2016|Asp.Net, Asp.Net MVC|