Techie's Diary

Sometime while working with SQL Server we have a value which is in database but we are not aware which table or which column is containing that value. Try finding some specific strings in a database with a number of tables, each with many columns and tens of thousands of records is a difficult thing to do if one tries to look out manually. In this case we can obtain required information from the database by writing SQL query. Let’s write one stored procedure and then we can execute this stored procedure by providing search string. CREATE PROCEDURE Search_From_AllTables        @SearchValue NVARCHAR ( 500 ) -- Search string AS BEGIN        /**** Declare @searchQuery ****/        DECLARE @searchQuery NVARCHAR ( MAX ) = N''        /**** DROP [#TempResults] table if existing ****/        IF OBJECT_ID ( 'tempdb.dbo.#TempResults' ) IS NOT NULL        BEGIN               DROP TABLE dbo . #TempResults        END     

While working with Simple Modal jQuery plugin, you may get error ‘Object doesn't support property or method removeExpression' in IE9 browser, if you are using older version of Simple Modal plugin.  The error is due to the fact that support for dynamic properties has been removed in IE 9, so none of the getExpression, removeExpression, setExpression and recalc methods are supported. These methods exist in version 8, but using those raises exceptions. Solution: Upgrade your Simple Modal plugin with latest plugin, latest release at the time of writing this post is SIMPLEMODAL1.4.4 , and with that you’ll not get error anymore, or if you don’t want to upgrade the jQuery plugin then try to update your plugin code like this one . Hope that helps!!!

So now we have got the basic idea about Web API , now let’s do some comparison of Web API with WCF and web services. Web Service WCF Web API Web services are created as files with .asmx extension. WCF create with .svc extension Web API are simple class file with .cs(for C#) extension. Web API is inherited from “ApiController” and the class name must end with “Controller”. It is SOAP based service and returns data in XML form. It is also based on SOAP and returns data in XML form. Web API is HTTP based service and by default, it returns data in JSON or XML form. It supports only HTTP protocol. It supports various protocols like TCP, HTTP, HTTPS, Named Pipes, and MSMQ. It supports HTTP protocol. It can be hosted only on IIS. It can be hosted within the application or on IIS or using window service. It can be hosted within the application or on IIS. It is no

HTTP is not just for serving up web pages. It is also a powerful platform for building APIs that expose services and data. HTTP is simple, flexible, and ubiquitous. Almost any platform that you can think of has an HTTP library. The ASP.NET Web API shipped with ASP.NET MVC 4 and is a framework for building HTTP services. ASP.NET Web API is a framework for building web APIs on top of the .NET Framework. With the help of Web API, we can create RESTful  services which can be consumed by a broad range of clients including browsers and mobile devices. Web API Features: ·          Web API is an HTTP Service. ·          It uses HTTP as an Application protocol, not a transport protocol. ·          Web API is an ideal platform for building pure HTTP-based services where the request and response happen with HTTP protocol. ·          Web API can be hosted within the application or on IIS   and with Web API 2 you can host it on Cloud . ·          It is designed for a broad ran

While using “sqlite” one can encounter error “failed to find or load the registered .net framework data provider.” We can solve the issue by taking care of following things: Fix your DbProviderFactories entry in the config file (i.e. web.config or app.config) to reference the full (version and public key information) assembly name instead of the partial assembly name. A full reference allows .NET to search the GAC for SQLite. Here's a "full" reference example: < DbProviderFactories >   < add name = " SQLite Data Provider " invariant = " System.Data.SQLite "        description = " .Net Framework Data Provider for SQLite "        type = " System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0.27.1, Culture=neutral,PublicKeyToken=db937bc2d44ff139 " /> </ DbProviderFactories > However, if you're deploying to a production machine without access to the mach

There are requirements where we need to find out count of duplicate records in a table, we can do it by using GROUP BY, HAVING, ORDER BY and COUNT in one query. This query will returns the results with duplicate column and its count in descending order. SELECT Column_Name , COUNT (*) ItemCount FROM Table_Name GROUP BY Column_Name HAVING COUNT (*) > 1 ORDER BY COUNT (*) DESC