Warning: mysqli_query(): (HY000/1021): Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device") in C:\ClientSites\blog.cheapwindowshosting.com\httpdocs\wp-includes\wp-db.php on line 2033

WordPress database error: [Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device")]
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (101, 112, 124, 141, 149, 160, 167, 191, 203) ORDER BY t.name ASC

Alexia Pamelov | Windows ASP.NET Hosting | Review & Comparison | Page

Author Archives: Alexia Pamelov

ByAlexia Pamelov

Cheap Windows Hosting – ASP.NET AJAX Control Toolkit v15.1.4 Hosting

CheapWindowsHosting.com | Cheap windows ASP.NET AJAX control Toolkit v15.1.4 hosting. The AJAX Control Toolkit contains a rich set of controls that you can use to build highly responsive and interactive Ajax-enabled ASP.NET Web Forms applications. The ASP.NET AJAX Control Toolkit is an open-source project built on top of the Microsoft ASP.NET AJAX framework. It is a joint effort between Microsoft and the ASP.NET AJAX community that provides a powerful infrastructure to write reusable, customizable and extensible ASP.NET AJAX extenders and controls, as well as a rich array of controls that can be used out of the box to create an interactive Web experience.

The ASP.NET AJAX Control Toolkit is designed to provide a rich infrastructure for you to write your own ASP.NET AJAX extenders and controls, but it also provides a number of exceptional controls that can be used right out of the box by developers without any previous AJAX experience.

Cheap Windows Hosting – ASP.NET AJAX Control Toolkit v15.1.4  Hosting

ahp

There are literally thousands of ASP.NET AJAX Control Toolkit v15.1.4 hosting companies to choose from and evaluating them can be difficult. The first question you will want to ask a potential hosting company is what types of hosting plans they offer. There are likely to be several choices from starter type packages to the platinum version with all the bells and whistles. To get best ASP.NET AJAX Control Toolkit v15.1.4 hosting provider that meets with your needs, we highly recommend you to host with ASPHostPortal.com

ASPHostPortal.com is one of the best and professional ASP.NET AJAX Control Toolkit v15.1.4 hosting providers. Many people are really amazed by their superb web hosting experience and their service up time is far above 99.9% up time as guarantee. They also have a full time customer care team. The helpline is managed by professional workers. Online web forms are given quick responses depending on the query that is raised. Email support will enable you to get in touch with a web hosting professional quickly. All these customer support programs are designed to ensure that problems are dealt with before they escalate.

They are extremely confident regarding all of its services and right so as the reviews prove that none of their claims are false. Consumers can easily sign up for the service and in case they incur any problems they have 24/7 customer and technical support both over the phone and online to help them through this process. They also offer a 30-day with money back guarantee.

Cheap windows ASP.NET AJAX Control Toolkit v15.3 with ASPHostPortal.com

aspp-e1428978237554ASPHostPortal.com is offering a Best and Cheap ASP.NET AJAX Control Toolkit v15.1.4 Hosting plain. For their cheap plan is only from $5.00 a month with incredible features and outstanding support. One click Script installer to install all your favorite ASP, PHP and Javascript/Ajax scripts. Daily backup also included with all shared hosting packages.

Their robust, ASP.NET AJAX Control Toolkit v15.1.4 hosting plan with super speed and adequate allocated resources. Very suitable for individuals, college students and businesses which need good response time without compromising quality. For all their service, They also give you Uptime and 30 Days money back guarantee.

[su_box title=”ASP.NET AJAX’s Stunning Features” box_color=”#d54717″]
Currently, the ASP.NET Ajax suite contains such components and packages : Microsoft Now Launched Ajax Library 4.0, Microsoft Ajax Library 3.5, A server framework, ASP.NET 5.0 Ajax Templates, and ASP.NET Ajax Preview.
  • JavaScript extension is an enhanced system that is used to perform reflection on user end and emulate object-oriented construction such as classes, namespaces and interfaces.
  • The Microsoft AJAX Library is integrated with JavaScript Library that offers the features for the client portion of the ASP.NET Ajax Framework.
  • The AJAX Library allows clients to access the ASP.NET membership, Authentication, Roles and Profile services.
  • The Document Object Model can be used to display data dynamically and interactively.
  • JavaScript can be used to combine all these technologies together.
  • ASP.NET AJAX allows web developers to create web applications in ASP.NET and update data on the website directly without a reloading page.
  • With ASP.NET AJAX, the designers are allowed to take advantage of AJAX techniques to create dynamic ASP.NET websites with rich user interfaces.
[/su_box]
ByAlexia Pamelov

Cheap Windows SilverLight 6 Hosting 2016 Review

CheapWindowsHosting.com | Cheap and affordable silverlight 6 hosting. Microsoft Silverlight is a free web-browser plug-in that enables interactive media experiences, rich business applications and immersive mobile apps.Microsoft Silverlight is a powerful tool for creating and delivering rich Internet applications and media experiences on the Web. Silverlight 6 builds on the foundation of Silverlight 4 for building business applications and premium media experiences. Silverlight 6 introduces more than 40 new features, including dramatic video quality and performance improvements as well as features that improve developer productivity.

Cheap and Affordable SilverLight 6 Hosting

aspportalASPHostPortal.com | The top recommended Silverlight 6 Hosting Provider. Cheap and affordable Hosting features including:

[su_button url=”http://asphostportal.com/Silverlight-6-Hosting” background=”#0b9dde” color=”#ffffff” radius=”round” icon=”icon: hand-o-up” text_shadow=”0px 0px 0px #6479d0″]ASPHostPortal.com[/su_button]


  1. Unlimited Sites, 5 GB Disk Space,  60 GB Bandwidth only $ 5.00/Mo
  2. IIS 8.5 with URL-Rewrite, ASP.NET MVC Framework.
  3. Compatible with nopCommerce, DNN, Magento and more other ASP.NET web applications.
  4. 100% Satisfaction Promise with 30 Days Money Back Guarantee!

 

hflHostForLIFE.eu | Professional Silverlight 6 Provider & fully ASP.NET support. We can easily deploy the most popular ASP.NET, CMS & Blog system such as BlogEngine, DotNetNuke. The best ASP.NET hosting feature including :

[su_button url=”http://hostforlife.eu/European-Silverlight-6-Hosting” background=”#0b9dde” color=”#ffffff” radius=”round” icon=”icon: hand-o-up” text_shadow=”0px 0px 0px #6479d0″]HostForLIFE.eu[/su_button]


  1. Unlimited Domain, Unlimited Disk Space, Unlimited Bandwidth only €3.00/Mo
  2. IIS 8.5 with URL-Rewrite, ASP.NET MVC Framework.
  3. 100% Satisfaction Promise with 30 Days Money Back Guarantee!

 

ukwinhostUKWindowsHostASP.NET | The best Silverlight 6 Provider & fully ASP.NET support. One of top and recommended ASP.NET Hosting Providers ! ASP.NET Hosting feature plan including:
 
[su_button url=”http://ukwindowshostasp.net/UK-Silverlight-6-Hosting” background=”#0b9dde” color=”#ffffff” radius=”round” icon=”icon: hand-o-up” text_shadow=”0px 0px 0px #6479d0″]UKWindowsHostASP.NET[/su_button]

  1. Unlimited Domains
  2. Dedicated Pool
  3. 99.99% Uptime Guarantee & 24/7 Live Support
  4. Support WordPress, Drupal and etc
  5. FREE Instant Setup

What makes them as the Cheap and Affordable SilverLight 6 Hosting?

[su_service title=” Trust Level” icon=”icon: check-square-o” icon_color=”#63dee6″ size=”36″]

It’s the configuration in IIS for your websites. The best flexible option is Full Trust that you don’t worry the websites cannot run successfully in the shared web host. And the balanced option between security and flexibility is Medium if you’re experienced on joomla debugging, deployment and you’re sensitive on the security and server reliability.[/su_service]

[su_service title=”Powerful Control panel” icon=”icon: check-square-o” icon_color=”#63dee6″ size=”36″]

The control panel should be easy to configure asp.net stuff such as .net versions switch, trust level management and script map etc.

[/su_service]

[su_service title=”Database ” icon=”icon: check-square-o” icon_color=”#63dee6″ size=”36″]

They are consider more about the supported SQL Server version and limitation. The preferred SQL Server is 2008 however most of web hosts support Express edition only. Actually it’s completely enough for websites hosted with shared web hosting. [/su_service]

[su_service title=”Customer support ” icon=”icon: check-square-o” icon_color=”#63dee6″ size=”36″]

No matter if you’re asp.net newbie or developer, you can’t avoid bothering the hosting support. 24 x 7 live support is always expected.[/su_service]

ByAlexia Pamelov

Windows ASP.NET Hosting – Tips for Instagram Marketing

1111CheapWindowsHosting.com | Cheap windows ASP.NET hosting review and comparison. Instagram has become one of the most powerful tools for sharing the visual story of a brand. With over 300 million active users, the app has surpassed Twitter as a social media platform. And why wouldn’t it? With an increasingly visual thirsty audience, Instagram gives brands a golden opportunity to interact with their audience in a more personal and intimate way.

Instagram is not only a great tool to establish brand identity and keep customers updated with latest company news, the app can also be used to share special offers, product launches and behind-the-scenes images with the audience.

There might be 50+ tips and tricks to use Instagram for marketing, but we have extracted the top 3 from the lot so you can get on board quickly and easily.

Use Hashtags

Hashtags are the driving force of Instagram. They’re one of the main ways of how the audience can find your brand through mobile Instagram searches. There are more than a few ways to use hashtags strategically to drive audience and increase brand awareness.

  • General Hashtags – By using general hashtags you amplify the chances of being found for your particular products. For example. if you own a fast food chain and you post an image of your mouth-watering burger, include tags such as #burger, #beef, #bbqsauce in the caption.
  • Brand Specific Hashtags – It is a good strategy to include your brand’s name in some of your hashtags. In fact, if your brand is running a new marketing campaign, you can create a hashtag for that particular campaign to increase promotion and awareness.
  • Trending Hashtags – Instagram trends spread like wildfire. If you find a trending hashtag that resonates with your brand, use it in your post and it might be seen by thousands of consumers within a few minutes.

Leverage User Generated Content

When consumers are loyal to a brand, they absolutely love to share their experience. One great way to involve them in your marketing campaign is to ask them to share their pictures while using your product and include relevant hashtags. This will not only make them feel valued but also give a boost to your marketing efforts. Furthermore, it gives you a break from having to come up with fresh content twice or thrice a day.

Share Exclusive Deals

Although it’s great to post deals and special offers throughout all social networks, posting Instagram-only offers, contents, deals, and discount codes will give your audience a good reason to connect with your brand specifically on Instagram.

Instagram is a fairly new platform for most brands, but it’s strong potential for consumer engagement makes it an imperative part of their social media marketing strategy. Once you implement these tips to gain an active following, you will realize the power of visual marketing.

Best ASP.NET Hosting Recommendation

ASPHostPortal is the only ASP.NET hosting company who provide ANYTIME money back guarantee. If you are not satisfied with the ASPHostPortal service, you can request to get money back at any time. This is not only an advertisement or term, but also helps your purchase be completely worry-free and risk-free.

ByAlexia Pamelov

Cheap Windows ASP.NET 5 Hosting Company

CheapWindowsHosting.com | Cheap and Reliable  Windows ASP.NET Hosting. When you install .NET 5 Preview it will actually be installed as .NET, partly to maintain (in-place) compatibility with previous versions (4, 4.5, 4.5.1, 4.5.2 and 5). This means that if you have one of the above mentioned frameworks installed on your computer, this installer will upgrade them to 5 while if you have older frameworks installed like 3.5, 2.0, 1.1 etc., then it will run alongside them.

Important note: Before downloading and installing this preview version, please remember that Visual Studio 2015 Preview and .NET 5 Preview are for testing and feedback purposes only and not for a production environment.

There are three key areas to look at:

  • Open Source .Net Framework Packages
  • Support for Code page encodings
  • Improvements to event tracing

How To Choose Cheap Windows ASP.NET 5 Hosting Company ?

Choosing a quality ASP.NET hosting provider is not an easy job for most users, especially those newbies. Therefore, our editors have done the hard work for you and finally named the companies above as the best ASP.NET web hosting companies. All of above 3  ASP.NET hosting above offer the latest Microsoft technologies such as:

1. The latest Windows Server 2012 edition with IIS 8.5
2. The latest ASP.NET version
3. Support MSSQL 2008/2008 R2/2012/2014 on their hosting environment
4. Support Full Trust Hosting
5. Dedicated Application Pool

Cheap Windows ASP.NET 5 Hosting Company

[su_box title=”ASPHostPortal – Best ASP.NET Hosting ” style=”glass”]

Founded in 2008, it is a fast growing web hosting company operated in New York, NY, US, offering the comprehensive web hosting solutions on Windows Hosting and they have a brilliant reputation in the ASP.NET development community for their budget and developer-friendly hosting which supports almost all the latest cutting-edge Microsoft technology. ASPHostPortal have various shared hosting plan which start from Host Intro until Host Seven. But, there are only 4 favorite plans which start from Host One, Host Two, Host Three, and Host Four. Host One plan start with $5.00/month. Host Two start with $9.00/month, Host Three is the most favorite plan start from $14.00/month and Host Four start with $23.00/month. All of their hosting plan allows user host unlimited domains, unlimited email accounts, at least 1 MSSQL and 1 MySQL database. ASPHostPortal is the best ASP.NET Hosting, check further information at http://www.asphostportal.com

[/su_box]

[su_box title=”HostForLIFE – A Superior ASP.NET Hosting Provider” style=”glass”]

HostForLIFE, specializing in offering affordable and manageable ASP.NET hosting services, releases three plans for the clients – Classic Plan, Budget Plan, Economy Plan and Business Plan regularly starting at €3.00/mo, €5.50/mo, €8.00/mo and €11.00/mo separately. And also, the 30-day money back guarantee is offered to the clients who wish to cancel their accounts and get a refund. HostForLIFE supports Windows 2012/2008, ASP.NET 2.0/3.5SP1/4.0/4.5.1/5 as well as IIS8.5/ IIS8. It offers various versions of Microsoft SQL Databases, including MS SQL 2014, MS SQL 2012, MS SQL 2012R2 and MS SQL 2008. Each database comes with at least 500MB disk space. Furthermore, the webmasters can install the software by using one-click app installer. Besides, it is worth mentioning that the webmasters can get a full control of their websites through the users-friendly ASP.NET control panel of HostForLIFE. By using the top-level data center HostForLIFE delivers average 99.99% uptime to each hosted website.

[/su_box]

[su_box title=”DiscountService.biz –Premium ASP.NET Hosting Service Provider” style=”glass”]

DiscountService.biz is Microsoft Gold Partner, which means they are the first one to know the latest Microsoft technology and test Microsoft product before being released to the public. The engineers from DiscountService fully understand the needs of Microsoft developer, when signing up their service, their customer could choose the version of platform to better support their application. IIS ASP.NET security from DiscountService is also at FULL Trust level. The price of DiscountService is at $7.00/month.

[/su_box]

Summary

Under the overall consideration, ASPHostPortal, HostForLIFE and DiscountService.biz are 3 first-rank cheap windows ASP.NET hosting providers because of their affordable price, rich features, excellent performance and reliable support. Another piece of good news is that they have been listed as the cheap windows ASP.NET Hosting companies 2016

ByAlexia Pamelov

Cheap Windows Hosting – Best PrestaShop v1.6.1.4 Hosting For e-Commerce

CheapWindowsHosting.com | Cheap and best PrestaShop v1.6.1.4 hosting. PrestaShop is an open source eCommerce solution. It comes with a variety of tools necessary for building a successful online shop. To create an online store with PrestaShop you need reliable web hosting services.

What is New in PrestaShop v1.6.1.4?

The latest version of PrestaShop is 1.6.1.4. The new features of PrestaShop v1.6.1.4 listed below.

Fixed bugs:

  • [-] CORE : (c243c8a) Fix ObjectModel error management on validation
  • [-] CORE : (508e1cd) Fix AdminTab PHP 7 compatibilty
  • [-] CORE : (355a4a7) Report of https://github.com/PrestaShop/PrestaShop/pull/3673
  • [-] CORE : (0a07da9) fix #PSCSX-7007, notice in searchcron
  • [-] CORE : (13285fd) Fix PSCSX-6953, bad upload error check
  • [-] TESTS : (b826568) removed tests for prestafraud module [-] BO : (c35d896) Fixed bug in HTMLTemplateInvoice prevents problems with invoice prefixs
  • [-] BO : (e71bdaa) fixed translation bug in prestashop addons modal
  • [-] BO : (48d9da7) Fixed upgrade index specific_price table [-] FO : (0eecc7a) Fix #PSCSX-7021, bad specific base price for combinations
  • [-] FO : (40717fa) Fix #PSCSX-7021, bad impact price / currency
  • [-] FO : (0bd1bdc) Fix robots.txt rules for default language URLs
  • [-] FO : (ed08594) Fix quantity discount table wont appear again after swith on combination without quantity discount

Improved/changed features:

  • [*] PROJECT : (bcbec89) Improve PHP 7 compatibility
  • [*] BO : (ad3c187) #PSCSX-6251 on product order add unit product price without tax
  • [*] BO : (06502f9) Dont restrict orders listing to addresses join [*] CORE : (94846bd) Fix #PSCSX-7015, Uploader setAcceptFiles case sensitive [*] FO : (83c7ee1) #PSCSX-5582 update price from discount when changing quantity

16288-01

Choosing Cheap PrestaShop v1.6.1.4 Hosting?

How to choose the Cheap PrestaShop v1.6.1.4 hosting? Choosing the Cheapest  PrestaShop v1.6.1.4 hosting is not a simple task especially with low price offers. You need to take a large number of factors into consideration, including the PrestaShop v1.6.1.4 compatibility, usability, features, speed, reliability, price, company reputation, etc. Therefore, we have established this PrestaShop v1.6.1.4 review site, which is designed to help you find the Cheap European PrestaShop v1.6.1.4 hosting within minutes, based on our specialized editors’ PrestaShop v1.6.1.4 hosting experience and real customers’ feedback.

The Best and Cheap PrestaShop v1.6.1.4 Hosting Review

After review 50+ web hosting provider we found the best and cheap PrestaShop v1.6.1.4 hosting, As many webmasters ask about where and how to choose one of the best PrestaShop v1.6.1.4 hosting provider. In this post, we display the best PrestaShop v1.6.1.4 hosting providers, including ASPHostPortalUKWindowsHostASP.NET and DiscountService.biz , which enjoy high reputation in this field.

[su_spoiler title=”ASPHostPortal.com” style=”fancy” icon=”folder-1″]

The ASPHostPortal.com’s ASP.NET hosting platform on Windows 2012 and Windows 2008 is compatible with PrestaShop v1.6.1.4 hosting. Of course, you can feel very comfortable with their hosting service. Their Cheap PrestaShop v1.6.1.4 hosting plan is starting from $5.00/mo only. And with their promo code, you can get free domain too. Not only that, they also offer 30 days money back guarantee. Their servers are 99.99% uptime, it is important think that you need for your PrestaShop site, so your site is never down. ASPHostPortal.com provides PrestaShop-optimized managed hosting solutions for online merchants of all sizes. Since 2008, they’ve been committed to delivering superior performance, reliability, security, and support to their clients. Every PrestaShop hosting deployment is engineered from the ground up to be responsive, scalable, and cost-effective.

[/su_spoiler]

[su_spoiler title=”UKWindowsHostASP.NET” style=”fancy” icon=”folder-1″]

UKWindowsHostASP.NET is an advanced web hosting company specializing in PrestaShop eCommerce hosting solutions. UKWindowsHostASP.NET combines the fastest, most reliable hardware in the industry with the highest performing infrastructure, to create an optimal environment for hosting eCommerce sites. Backed by a superior 24/7 customer support team, the UKWindowsHostASP.NET platform maintains an unsurpassed level of quality, innovation and performance in order to provide customers reassurance that his/her eCommerce store will be supported by the hardware and resources needed to maximize revenue.

[/su_spoiler]

[su_spoiler title=”DiscountService.biz” style=”fancy” icon=”folder-1″]

Their cloud and dedicated web hosting packages offer flexible, fast and secure support for your PrestaShop site hosted in DiscountService.biz , state of the art Australia data centers. With reliable handling for any volume of traffic their PrestaShop web hosting is fast, dependable and secure.

[/su_spoiler]

ByAlexia Pamelov

Cheap Windows Hosting – Simple Tips Optimize Your WordPress Website

CheapWindowsHosting.com | Today, I would like to share with you thirteen quick tips on how you can optimize your website and decrease page loading times. If you follow these techniques and best practices, your website will load much quicker. The time it takes your website to load influences how successful it will be. If your website is slow, visitors will turn away in droves. They might even click the back button before your website loads. Website performance will also influence your rankings in search engines. In addition to being ranked higher, many website owners report seeing an increase in search engine spider crawling after speeding up their design.

Before applying these techniques to your website, I encourage you to check the speed of your website using a free performance service such as GTMetrix, YSlow or Google PageSpeed Insights. These services will inform you of your page loading time and the overall file size of your page. They also offer tips

[su_spoiler title=”Choose the Right Hosting Plan” style=”fancy” icon=”folder-2″]

The first step in optimizing your website correctly is to choose the right hosting plan. You are fighting a losing battle if your server is taking an age to process HTTP requests and MySQL commands. Performance services such as GTMetrix will advise you of the exact response time of your server. I recommend testing the response time of your own website against similar websites. For example, if you run a photography blog, see how your server response time compares to other photography blogs within your niche. Hosting companies are not always the cause. You may be with a great hosting company but see poor response times because your chosen hosting plan is underpowered. Customers using shared hosting plans, for example, are more likely to face slow loading times as hundreds of websites are hosted on the same server. However, any type of hosting plan will suffer from insufficient RAM and CPU throttling. Therefore, you need to pay attention to what your website needs to run smoothly. Do not be a cheapskate and go for the cheapest option. Choose a hosting plan that can handle traffic spikes efficiently.

[/su_spoiler]

[su_spoiler title=”Monitor Your Plugins” style=”fancy” icon=”folder-2″]

Before you install any plugin on your website, ask yourself “Is this plugin necessary?”. Plugins are one of the biggest causes of WordPress websites being slow. The more plugins you install without research, the more likely you will face performance issues; however the sheer number of plugins you have installed is not the reason a WordPress website can slow down. Certain plugins are known for causing websites to be slow. There are many reasons for this including bad coding, calls to external servers and persistent calls and updating of your WordPress database. Pay close attention to how much CPU plugins use too. Many plugins can bottleneck your CPU due to persistent processes. If this happens, your whole server could go down.

[/su_spoiler]

[su_spoiler title=”Empty Your Trash” style=”fancy” icon=”folder-2″]

WordPress 4.4.1 introduced the WordPress trash system. Whenever content is deleted, be it a comment, post, page, media etc; it is sent to trash. From here, the content can either be restored or deleted permanently. It is effectively a fail-safe system that helps you recover anything that was deleted accidentally (in much the same way the recycling bin works in your computer). Trash can take up a lot of unnecessary room in your website’s database. The bigger the database, the longer it is to retrieve information from it. By default, WordPress will automatically delete trash after thirty days. This can be reduced by modifying the wp-config.php file. For example, you could reduce this to seven days by adding the following:

define ('EMPTY_TRASH_DAYS', 7);

You can completely disable the trash system by adding this to your wp-config.php file.

define ('EMPTY_TRASH_DAYS', 0);

[/su_spoiler]

[su_spoiler title=”Optimize Your Images for the Web” style=”fancy” icon=”folder-2″]

Images can help break up long pieces of text and can help your articles be shared more frequently on social media services; however they also take up a lot of storage. Therefore, pages that contain many images can take a long time to load. It is therefore in your best interests to optimise your images for the internet before you upload them to your website. Most photo editing applications, such as Photoshop, allow you to do this via the “Save for Web” option. A good plugin to optimize images that have already been uploaded is WP Smush.it. It utitlizes the Smush.it API to optimize JPEG images, strip meta data from JPEGs and convert GIF images to PNG. You should however be aware that the plugin uses up a lot of resources when it is converting images, therefore your website may be slow whilst it is running. If you do not want to sacrifice image quality, check out Lazy Load. The plugin ensures that images are only loaded when the area becomes visible to the user. This will greatly reduce page loading times. [/su_spoiler]

[su_spoiler title=”Enable Browser Caching” style=”fancy” icon=”folder-2″]Some of the largest files on your website rarely change. This includes CSS files, Javascript files, your website logo etc. One way to take advantage of this is to enable browser caching. Browser caching allows internet users to speed up the loading time of their favourite websites by storing a cached copy of your website locally. This reduces calls to your server and saves the user from downloading the same files again. You can enable browser caching by adding the following code to your .htaccess file:

## EXPIRES CACHING ##
<IfModule mod_expires.c>
ExpiresActive On
ExpiresByType image/jpg "access 1 year"
ExpiresByType image/jpeg "access 1 year"
ExpiresByType image/gif "access 1 year"
ExpiresByType image/png "access 1 year"
ExpiresByType text/css "access 1 month"
ExpiresByType text/html "access 1 month"
ExpiresByType application/pdf "access 1 month"
ExpiresByType text/x-javascript "access 1 month"
ExpiresByType application/x-shockwave-flash "access 1 month"
ExpiresByType image/x-icon "access 1 year"
ExpiresDefault "access 1 month"
</IfModule>
## EXPIRES CACHING ##

The code above specifies how long a particular file type should be stored. Files will simply be downloaded again if they have expired.

[/su_spoiler]

[su_spoiler title=”Install a Cache Plugin” style=”fancy” icon=”folder-2″]

Caching plugins allow you to publish static HTML files instead of dynamic files. This greatly reduces the time a page takes to load as there are no PHP or MySQL commands to execute. Additional caching features include minification, caching of feeds, Gzipping, Content Delivery Network (CDN) support, and much more. Caching your pages is one of the most effective ways of improving your page loading times, with many plugins promising an improvement of at least ten times. Popular caching plugins include WP Super Cache, W3 Total Cache and WP Fastest Cache. All three plugins are available free. [/su_spoiler]

ASPHostPortal.com – Best and Cheap Web Hosting Recommendation

ASPHostPortal.com was launched in 2008. They are one of the best Windows Hosting in United States is ASPHostPortal.com. This company currently supports Windows Server 2012 hosting with ASP.NET 5/ 4.5 / 4.5.1 / 4.5.2, MVC 5.1 / 5.1.1 / 5.1.2/6, Visual Studio 2012, WebSockets, IIS 8.5, Wordpess 4.4.1 and support the latest Microsoft technology. All of its Windows hosting services are 100% compatible with ASP.NET 5. The price of ASPHostPortal.com ASP.NET 5 hosting packages is quite competitive, especially the Host One which we may recommend most here. Going through this promotional link directly and you will get FREE DOMAIN or DOUBLE SQL SPACE, the Host One Windows hosting package is $5.00/mo. This company offers money back guarantee if any of the clients fail to get the desired results. If the company does not work up to the expectations in a certain month, and the valid refund period is 30 days. In addition, the customer service is based on US and the representatives are working 24/7.

ByAlexia Pamelov

Cheap Windows Hosting – 10 Tips SEO Tutorial For Beginners in 2016

CheapWindowsHosting.com | Today we will learn about SEO. Do you know SEO? Nowdays almost people know about SEO, but there’s some people don’t know about that, so today we will tell you about SEO for beginner. Lets see it.

What is SEO?

Search Engine Optimisation ( SEO ) in 2016 is a technical, analytical and creative process to improve the visibility of a website in search engines, with the aim of driving more potential customers to it. SEO is the acronym for search engine optimisation. Search engine optimisation is the process of optimising your website and its content so that it can easily be indexed by search engines.

As a beginner to search engine optimization (SEO) you need to understand that there is no magic way to rank your web site in the first page of Google, Bing or Yahoo. Search engines are governed by complex algorithms and it takes a lot of effort to ‘convince’ them that your web site or page deserves one of the top spots.

Nevertheless, there are certain rules you can follow to optimize your web site and provide the bots with the necessary signals.  While the web is floated with SEO tips and advice these are explained in a theoretical level and not how they can be applied in practice. In my opinion, this is why most web site owners are confused and they either give up with SEO or simply do not get the expected results.

google-boost-your-web-site

1. Page Titles and description

Page titles

Page titles are a very important aspect of SEO and this is why it is first on the list. My findings the last couple of months show that page titles are more important than ever especially for Google SEO. Exact page titles for low volume keywords can give you a competitive advantage in search results but this is something I will discuss in another post. For now the most important characteristics of a page title are:

  • Each page needs to have a unique page title that accurately describes the page’s content.
  • Be brief and descriptive.
  • Help the user understand what the page is about

Home page title: The title for your homepage can list the name of your website/business and could include other bits of important information like the physical location of the business or maybe a few of its main focuses or offerings. For example:

title

Post/other pages title:

Title of other posts/pages of your web site should accurately describe what the page is about and be attractive for the searcher.

ff

Description

A page’s description meta tag is also very important. It gives users, Google and other search engines a summary of what the page is about. Google may choose to show what you type in the description as a snippets for your page or may decide to use a part of your page’s content. In other words it does not mean that what you write in the description will show in the snippet. The guidelines for writing a good description are:

  • Always provide a unique description for all pages, post, products of your website.
  • Keep the size between 150-160 characters.
  • Avoid repeating the title in the description
  • Don’t add too many keywords
  • Try to use the description as a way to ‘advertise’ your page to the reader so that they click on your title and visit the page.

You can see from the examples above how I use the description tag for my pages.

2. Permanent link structure

The permanent link structure is a term used to describe the format of URLS for pages (categories/tags) or individual posts of a web site. It is shown in the browser address bar and in the search results (below the page title).

g

Guidelines for optimized link structure

  • Make Urls simple and easy to understand for search engines and users
  • Use hyphens ‘ – ‘ to separate the words that make up a url
  • Avoid lengthy Urls with unnecessary information
  • Use words that describe what the page is about but avoid keyword stuffing

Examples of BAD url structures

  • http://www.example.com/UK/123213/5005.html
  • http://www.example.com/socialmedianews
  • http://www.example.com/id=7&sort=A&action=70

Examples of GOOD url structures

  • http://www.example.com/social-media-news
  • http://www.example.com/2002/12/social-media-news

3. Internal links

When we talk about internal links we mean links in a page that point to other pages within the web site i.e. not external links. In the example below when you click on the link with anchor “increase the intensity” you will be redirected to a page with-in the web site to find out more information on how to increase the intensity of an exercise.

d

Internal linking is a very important factor for web site SEO but still many web site owners are not using it correctly. The rules to follow for internal links are simple:

  • Link related articles together either by using keyword anchor text or by using the full article title
  • Make sure that the links are useful both for the user and easy to understand by search engines.
  • Don’t make links for search engines only. An internal link should help the user navigate the site better.
  • Do not use terms like ‘click here’ or ‘[..]’ for internal linking.
  • Don’t overdo it. 4-5 internal links per page are enough (create more if really necessary)

Don’t always link old posts from new posts but every couple of weeks go back and link newer posts from older posts. It’s not an easy task to do especially if you have a lot of posts but it’s a very valuable tool for on-site SEO.

4. Text formatting and the use of H1, H2 and H3

Don’t just publish text on your web site without first doing some basic formatting. This is not good for the user experience and works against your SEO efforts. General guidelines for formatting a post or page on your web site:

  • Use H1 tags for the title of your post
  • Use H2 tags for the main headings of your post.
  • Use BOLD and Italics to draw users attention
  • Don’t use H2 tags for all your headings
  • Write small paragraphs
  • Use a font size that is easy to read

When formatting your posts always have in mind the user experience. Can the user identify the main sections of your post (H2 tags) just by looking at the page? Is the text easy to read even on other devices

bgjh

5. The 404 Page

SEO is about improving the user experience and a proper 404 page contributes to that goal. The 404 page is the page shown when a user is looking for a page on your site that doesn’t exist or mistypes a URL or follows a broken link. When the 404 page is not configured looks like this:

page-not-found-invalid

This is not useful for the user and negatively impacts the user experience.

A properly configured 404 page should:

  • Give some info to the user of what happened rather than displaying “Not found”
  • Have a design consistent with the rest of the website
  • Give options to the user to navigate to other pages of the site.

If you are using a professional theme (like Thesis), it takes care of the 404 page. This is how my 404 page looks like:

page-not-foud-custom

6. Image Optimization

Images are sometimes necessary to enhance the user experience but care should be taken not to create other side effects like problems with page load speed or slow response. Especially after the success of Pinterest many webmasters started using more images in their posts. If you do decide to use images, mind the following:

  • Use Alt Text to describe the image. You can add keywords but don’t overdo it.
  • Use keywords in image filenames (separated with dashes). Avoid using filenames like image1.jpg or person1.jpg. Instead use meaningful names with dashes. For example woman-working-out.jpg
  • Keep all image files in a dedicated folder in your site i.e. www.mydomain.com/images/
  • Optimize the image size. The smaller the size of the image (in KB) the faster is your web site. You can use this free tool from Yahoo to make your image size smaller without losing the quality.

7. Page Speed

Google has many times said that page speed is a ranking factor and yet many webmasters don’t optimize their web sites for speed. Their aim (Google’s) is to provide the searcher with the most accurate results in the fastest possible way. It is certain that page speed (as a ranking factor) will gain more importance in the next couple of years.

Fast web sites improve the user experience and it is a factor to encourage the visitor to come again. In addition, a web site that loads in less than 8 seconds is more likely to:

  • Rank better in search results
  • Get more page visits per user
  • Get more conversions

How to tackle the page speed problem?

  • Remove any unnecessary plug-ins (if you are using WordPress) or java script from the pages.
  • Optimize the size of your images
  • Use a caching service or plug-in (I use WP Super cache and W3Total Cache).
  • Go to http://www.webpagetest.org/ and test how many seconds it takes for your pages to load from different locations, internet speed and browsers. The analysis report at the end will also tell you which components of your page take too long to load so that you can remove them.
  • Go to Google Page Speed Service  to analyze your web site and get performance recommendations.
  • If you have a lot of images on your site and you cannot improve performance with the recommendations given by the tools mentioned above you can consider using a CDN (Content Delivery Network) service such as Cloud Flare or Amazon Cloud Front

8. Google authorship

What is Google authorship status?

It’s a way to bind your content with your Google+ profile. When you do that successfully your picture appears in the Google search results next to your content (see example with my picture above)

How Google authorship status relates to Search Engine Optimization?

  • It improves the credibility of a web site in both the minds of users and search engines.
  • Studies have shown that more people are likely to click a link from the search results if the author is verified.
  • You increase the chances of getting natural links (people are more likely to link to your web site or page if you are verified).
  • There is also a confirmed hidden benefit from authorship status which gives you additional listings in the SERPS.

9. Mobile friendly web sites

A significant number of searches performed each day are through mobile devices. Many studies over the last 6 months identified that the number of searches using smartphones is steadily increasing especially when it comes to making online purchases.

I am sure that if you have a look at your analytics data you will see a good percentage of your daily visits coming from mobile. In the example demonstrated below, almost 30% of the traffic is from mobile with Apple products (iPhone, iPod and iPad) being on the top positions

mobile-visits-stats

It’s not in the scope of this post to go in detail into mobile SEO but there some simple steps to follow to ensure that you web site is mobile friendly.

  • First thing to do is understand the difference between a mobile friendly web site and a native Android, iPhone or Windows Mobile app. After talking with a number of webmasters I realized that many people fail with their mobile strategy because they do not understand this difference and because they have not yet realized the enormous potential of mobile markets.
  • A mobile friendly web site is optimized for viewing on the mobile browser (i.e. Chrome on android or Safari on iPhone).  A native android (iPhone or Windows Mobile app) is an application that can be downloaded from the mobile markets (Google Play or Apple Store). I will cover this with more details in another post but for SEO purposes you must provide a mobile friendly version for your users coming through mobile browsers.
  • The easiest way to create a mobile friendly web site is to use a plugin (if you are using WordPress) or a service (there are free and paid) which will optimize your web site for mobiles.

10. User Sitemap

A sitemap is a list of all posts/pages of your web site.  You need 2 types of sitemaps. First an xml sitemap to submit to Google, Bing and other search engines and second an html sitemap to help visitors find your content easier. It is recommended to place a link to your user sitemap from the main menu.

ByAlexia Pamelov

Cheap and Affordable Joomla 3.4.8 Hosting

CheapWindowsHosting.com | Cheap and Affordable Joomla 3.4.8 hosting, Looking for the cheap and affordable joomla 3.4.8 hosting plan? Following are top recommendation based 99% existing satisfied clients feedback. We selected upon plan features, server availability, support availability and true editorial experience. Our sole purpose is to help register the best .net hosting service for your online business.

Cheap and Affordable Joomla 3.4.8 Hosting

aspportalASPHostPortal.com | The top recommended Joomla 3.4.8 Hosting Provider. Cheap and affordable Hosting features including:

[su_button url=”http://asphostportal.com/Joomla-3-4-8-Hosting” background=”#0b9dde” color=”#ffffff” radius=”round” icon=”icon: hand-o-up” text_shadow=”0px 0px 0px #6479d0″]ASPHostPortal.com[/su_button]


  1. Unlimited Sites, 5 GB Disk Space,  60 GB Bandwidth only $ 5.00/Mo
  2. IIS 8.5 with URL-Rewrite, ASP.NET MVC Framework.
  3. Compatible with nopCommerce, DNN, Magento and more other ASP.NET web applications.
  4. 100% Satisfaction Promise with 30 Days Money Back Guarantee!

 

hflHostForLIFE.eu | Professional Joomla Hosting Provider & fully ASP.NET support. We can easily deploy the most popular ASP.NET, CMS & Blog system such as BlogEngine, DotNetNuke. The best ASP.NET hosting feature including :

[su_button url=”http://hostforlife.eu/European-Joomla-348-Hosting” background=”#0b9dde” color=”#ffffff” radius=”round” icon=”icon: hand-o-up” text_shadow=”0px 0px 0px #6479d0″]HostForLIFE.eu[/su_button]


  1. Unlimited Domain, Unlimited Disk Space, Unlimited Bandwidth only €3.00/Mo
  2. IIS 8.5 with URL-Rewrite, ASP.NET MVC Framework.
  3. 100% Satisfaction Promise with 30 Days Money Back Guarantee!

 

ukwinhostUKWindowsHostASP.NET | The best Joomla Hosting Provider & fully ASP.NET support. One of top and recommended ASP.NET Hosting Providers ! ASP.NET Hosting feature plan including:
[su_button url=”http://ukwindowshostasp.net/UK-Joomla-348-Web-Hosting” background=”#0b9dde” color=”#ffffff” radius=”round” icon=”icon: hand-o-up” text_shadow=”0px 0px 0px #6479d0″]UKWindowsHostASP.NET[/su_button]

  1. Unlimited Domains
  2. Dedicated Pool
  3. 99.99% Uptime Guarantee & 24/7 Live Support
  4. Support WordPress, Drupal and etc
  5. FREE Instant Setup

What makes them as the Cheap and Affordable Joomla 3.4.8 Hosting?

[su_service title=” Trust Level” icon=”icon: check-square-o” icon_color=”#63dee6″ size=”36″]

It’s the configuration in IIS for your websites. The best flexible option is Full Trust that you don’t worry the websites cannot run successfully in the shared web host. And the balanced option between security and flexibility is Medium if you’re experienced on joomla debugging, deployment and you’re sensitive on the security and server reliability.[/su_service]

[su_service title=”Powerful Control panel” icon=”icon: check-square-o” icon_color=”#63dee6″ size=”36″]

The control panel should be easy to configure asp.net stuff such as .net versions switch, trust level management and script map etc.

[/su_service]

[su_service title=”Database ” icon=”icon: check-square-o” icon_color=”#63dee6″ size=”36″]

They are consider more about the supported SQL Server version and limitation. The preferred SQL Server is 2008 however most of web hosts support Express edition only. Actually it’s completely enough for websites hosted with shared web hosting. [/su_service]

[su_service title=”Customer support ” icon=”icon: check-square-o” icon_color=”#63dee6″ size=”36″]

No matter if you’re asp.net newbie or developer, you can’t avoid bothering the hosting support. 24 x 7 live support is always expected.[/su_service]

 
ByAlexia Pamelov

Cheap Windows Hosting – Entity Framework and handling Exceptions

CheapWindowsHosting.com | Cheap and affordable windows hosting. In this tutorial we will learn about Logging database operations in Entity Framework and handling Exceptions.

Entity Framework (EF) is an object-relational mapper that enables .NET developers to work with relational data using domain-specific objects. It eliminates the need for most of the data-access code that developers usually need to write.

If you are using the EF6 and want to log the database operations, analyze them, then, this is the right place for you.

When I was developing one WebApi project, what I was searching for is an output each query performed by Entity framework should be logged with time. Also, exception if there is any. So, in this section, you will learn how to log commands and queries to the database generated by Entity framework.

There are two ways using code

  • Simple Method
using (MyDatabaseEntities context = new MyDatabaseEntities())
     {
         context.Database.Log = s => System.Diagnostics.Debug.WriteLine(s);
          // query the database using EF here.
      }

This will log the database operations in the output window. What it does is it writes the operations performed byEntityFramework to the output window. It gives awesome traces.

Have a look :

1

  • IDbCommandInterceptor

This uses the IDbCommandInterceptor Interface. This is in-built in Entity framework 6.

Note: This is available in Entityframework 6 and later.

Interface looks like this:

namespace System.Data.Entity.Infrastructure.Interception
{
  /// <summary>
  /// An object that implements this interface can be registered with 
  /// <see cref="T:System.Data.Entity.Infrastructure.Interception.DbInterception"/> to
  ///             receive notifications when Entity Framework executes commands.
  /// 
  /// </summary>
  /// 
  /// <remarks>
  /// Interceptors can also be registered in the config file of the application.
  ///             See http://go.microsoft.com/fwlink/?LinkId=260883 
  ///             for more information about Entity Framework configuration.
  /// 
  /// </remarks>
  public interface IDbCommandInterceptor : IDbInterceptor
  {
    /// <summary>
    /// This method is called before a call to 
    /// <see cref="M:System.Data.Common.DbCommand.ExecuteNonQuery"/> or
    ///             one of its async counterparts is made.
    /// 
    /// </summary>
    /// <param name="command">The command being executed.</param>
    /// <param name="interceptionContext">
    /// Contextual information associated with the call.</param>
    void NonQueryExecuting(DbCommand command, DbCommandInterceptionContext<int> interceptionContext);

    /// <summary>
    /// This method is called after a call to 
    /// <see cref="M:System.Data.Common.DbCommand.ExecuteNonQuery"/>  or
    /// one of its async counterparts is made. 
    /// The result used by Entity Framework can be changed by setting
    /// <see cref=
    /// "P:System.Data.Entity.Infrastructure.Interception.DbCommandInterceptionContext`1.Result"/>.
    /// 
    /// </summary>
    /// 
    /// <remarks>
    /// For async operations this method is not called until after the async task has completed
    ///             or failed.
    /// 
    /// </remarks>
    /// <param name="command">The command being executed.</param>
    /// <param name=
    /// "interceptionContext">Contextual information associated with the call.</param>
    void NonQueryExecuted(DbCommand command, DbCommandInterceptionContext<int> interceptionContext);

    /// <summary>
    /// This method is called before a call to 
    /// <see cref="M:System.Data.Common.DbCommand.ExecuteReader(System.Data.CommandBehavior)"/> or
    /// one of its async counterparts is made.
    /// 
    /// </summary>
    /// <param name="command">The command being executed.</param>
    /// <param name="interceptionContext">Contextual information associated with the call.
    /// </param>
    void ReaderExecuting(DbCommand command, 
  DbCommandInterceptionContext<DbDataReader> interceptionContext);

    /// <summary>
    /// This method is called after a call to 
    /// <see cref="M:System.Data.Common.DbCommand.ExecuteReader(System.Data.CommandBehavior)"/> or
    /// one of its async counterparts is made. 
    /// The result used by Entity Framework can be changed by setting
    /// <see cref=
    /// "P:System.Data.Entity.Infrastructure.Interception.DbCommandInterceptionContext`1.Result"/>.
    /// 
    /// </summary>
    /// 
    /// <remarks>
    /// For async operations this method is not called until after the async task has completed
    ///             or failed.
    /// 
    /// </remarks>
    /// <param name="command">The command being executed.</param>
    /// <param name="interceptionContext">
    /// Contextual information associated with the call.</param>
    void ReaderExecuted(DbCommand command, 
    	DbCommandInterceptionContext<DbDataReader> interceptionContext);

    /// <summary>
    /// This method is called before a call to 
    /// <see cref="M:System.Data.Common.DbCommand.ExecuteScalar"/> or
    ///             one of its async counterparts is made.
    /// 
    /// </summary>
    /// <param name="command">The command being executed.</param>
    /// <param name="interceptionContext">
    /// Contextual information associated with the call.</param>
    void ScalarExecuting(DbCommand command, DbCommandInterceptionContext<object> interceptionContext);

    /// <summary>
    /// This method is called after a call to 
    /// <see cref="M:System.Data.Common.DbCommand.ExecuteScalar"/> or
    /// one of its async counterparts is made. 
    /// The result used by Entity Framework can be changed by setting
    /// <see cref=
    /// "P:System.Data.Entity.Infrastructure.Interception.DbCommandInterceptionContext`1.Result"/>.
    /// 
    /// </summary>
    /// 
    /// <remarks>
    /// For async operations this method is not called until after the async task has completed
    ///             or failed.
    /// 
    /// </remarks>
    /// <param name="command">The command being executed.
    /// </param><param name="interceptionContext">
    /// Contextual information associated with the call.</param>
    void ScalarExecuted(DbCommand command, DbCommandInterceptionContext<object> interceptionContext);
  }
}

Let’s derive this interface to the DatabaseLogger class.

FYI, I have added my log information into database. You may insert into file, Excel, anything you want.

You need not worry about the methods Interface itself is very self explanatory. It has 6 methods, which you can see I have derived and check comments to understand each scenario.

//this file is used to log the database operations it checks
//the query execution time and than insert if it takes more than one second.
 //to disable it remove its registry from TeamPassDbContext default constructor
 public class DatabaseLogger : IDbCommandInterceptor
 {
     static readonly ConcurrentDictionary<DbCommand,
     DateTime> MStartTime = new ConcurrentDictionary<DbCommand, DateTime>();

     public void NonQueryExecuted(DbCommand command,
     DbCommandInterceptionContext<int> interceptionContext)
     {
         //executed state
         Log(command, interceptionContext);
     }

     public void NonQueryExecuting(DbCommand command,
     DbCommandInterceptionContext<int> interceptionContext)
     {
         //executing state
         OnStart(command);
     }

     public void ReaderExecuted(DbCommand command,
     DbCommandInterceptionContext<DbDataReader> interceptionContext)
     {
         //reader executed state
         Log(command,interceptionContext);
     }

     public void ReaderExecuting(DbCommand command,
     DbCommandInterceptionContext<DbDataReader> interceptionContext)
     {
         //reader executing state
         OnStart(command);
     }

     private static void Log<T>(DbCommand command,
     DbCommandInterceptionContext<T> interceptionContext)
     {
         DateTime startTime;
         TimeSpan duration;
         //Removing from dictionary and calculating time
         MStartTime.TryRemove(command, out startTime);
         if (startTime != default(DateTime))
         {
             duration = DateTime.Now - startTime;
         }
         else
             duration = TimeSpan.Zero;

         const int requestId = -1;

         var parameters = new StringBuilder();
         foreach (DbParameter param in command.Parameters)
         {
             parameters.AppendLine(param.ParameterName + " " +
             param.DbType + " = " + param.Value);
         }

         var message = interceptionContext.Exception == null ?
         $"Database call took {duration.TotalSeconds.ToString("N3")} sec.
         RequestId {requestId} \r\nCommand:\r\n{parameters + command.CommandText}" :
         $"EF Database call failed after {duration.TotalSeconds.ToString("N3")} sec.
         RequestId {requestId} \r\nCommand:\r\n{parameters.ToString() +
         command.CommandText}\r\nError:{interceptionContext.Exception} ";

         //Ignoring some queries which runs perfectly
         if (duration.TotalSeconds>1 || message.Contains("EF Database call failed after "))
         {
             //The time taken is more or it contains error so adding that to database
             using (DbContext dbContext = new DbContext())
             {
                 //using error model class
                 Error error = new Error
                 {
                     TotalSeconds = (decimal)duration.TotalSeconds,
                     Active = true,
                     CommandType = Convert.ToString(command.CommandType),
                     CreateDate = DateTime.Now,
                     Exception = Convert.ToString(interceptionContext.Exception),
                     FileName = "",
                     InnerException = interceptionContext.Exception == null ?
                     "" : Convert.ToString(interceptionContext.Exception.InnerException),
                     Parameters = parameters.ToString(),
                     Query = command.CommandText,
                     RequestId = 0
                 };
                 //Adding to database
                 dbContext.Errors.Add(error);
                 dbContext.SaveChanges();
             }

             //var errorFileUrl = ;
             //File.WriteAllLines(, message);
         }
     }

     public void ScalarExecuted
     (DbCommand command, DbCommandInterceptionContext<object> interceptionContext)
     {
         //Log and calculate after executed
         Log(command, interceptionContext);
     }

     public void ScalarExecuting
     (DbCommand command, DbCommandInterceptionContext<object> interceptionContext)
     {
         //adding to dictionary when executing
         OnStart(command);
     }
     private static void OnStart(DbCommand command)
     {
         //adding to dictionary when executing
         MStartTime.TryAdd(command, DateTime.Now);
     }
 }

Now, I am registering this class to dbcontext. What it does is, It tells entity framework to use this class for logging database operations.

public DbContext(): base("name=connectionstring")
       {
           //TODO remove this when don't need to log anything
           DbInterception.Add(new DatabaseLogger());
       }

Everything is set up now. You can make an Error model class like this. (This is the code-first model class.)

public class Error
  {
      [Key]
      [Required]
      public int ErrorId { get; set; }
      public string Query { get; set; }
      public string Parameters { get; set; }
      public string CommandType { get; set; }
      public decimal TotalSeconds { get; set; }
      public string Exception { get; set; }
      public string InnerException { get; set; }
      public int RequestId { get; set; }
      public string FileName { get; set; }
      public DateTime CreateDate { get; set; }
      public bool Active { get; set; }
  }

You can see the error logs here

2

Technically, there are many approaches to log your database operations. But, I think this should be centralized to reduce the load. That is why I used this approach.