GlobalConfiguration.Configuration.DependencyResolver not found WebAPI

In my recent project , I found an interesting issue thought of posting it in my blog. 
May be , this post will help other guys who are searching after the same issue.

GlobalConfiguration.Configuration.DependencyResolver not found

My project required dependency injection with Ninject. During registration of all the repositories to the kernel in Ninject configuration this issue came up.

I searched the reason and did'nt found the reason . Later after searching for one hour, I came to know the reason that the project was basically started as MVC project and required with WebAPI also.

Then the answer is simple , GlobalConfiguration is from the NameSpace  System.Web.Http of WebApi Which is missing.

To avoid this problem , 
Open Package Manager Console and type this in it

Install-Package Microsoft.AspNet.WebApi.WebHost

The issue will be resolved. (Don't forget to add the Namespace)

I hope this post may help you guys.

could not load file or assembly 'abcd' or one of its dependencies

I faced this problem in my recent project exception was

could not load file or assembly 'abcd' or one of its dependencies. an attempt was made to load a program with an incorrect format.

BadImageFormatException was unhandled:
Could not load file or assembly 'ProjectA, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. An attempt was made to load a program with an incorrect format.


I found out the solution which is not related to the code but it is because, of the assembly or dll.
My project was built in 64-bit but we had included a dll which was built on 32-bit.

Therefore, this exception occured to overcome this problem need changes in iis.

Step  -> 1
In IIS > select your pool refer below screen shots

Step -> 2
Select your application pool and right click -> select advanced settings 

Step -> 3 
Change the Enable 32 Bit Applications to True

Step -> 4
Restart IIS and check 

I hope it'll help others who are facing this same issue.

If you find any others solutions, please post here. 

---- Thank you

Simple Date search in LINQ c#

The main problem faced in my recent project is the date search in LINQ .

Generally, Date search we have to check each and every datepart individually.
Example is mentioned below

(t.LastModifiedDate.Value.Day >= receivedFromDate.Value.Day &&
t.LastModifiedDate.Value.Month >= receivedFromDate.Value.Month &&
t.LastModifiedDate.Value.Year >= receivedFromDate.Value.Year)
&&
(t.LastModifiedDate.Value.Day <= receivedToDate.Value.Day &&
t.LastModifiedDate.Value.Month <= receivedToDate.Value.Month &&
t.LastModifiedDate.Value.Year <= receivedToDate.Value.Year)

It will look for individual date part, where code looks very large.

Therefore, I was searching for other alternative for DateTime search
then got know about a function which is built in EntityFramework
System.Data.Entity for version 6 and above

Function name is DbFunctions 
Example is shown below

(DbFunctions.TruncateTime(t.ContractDate)>=
receivedFromDate.Value)
&&
(DbFunctions.TruncateTime(t.ContractDate)>=
receivedToDate.Value)

In earlier versions of Entity Framework the function name was

EntityFunctions.TruncateTime()


I hope it is very small tip but it may help guys who are needed with.

Windows phone 8 XMPP Send and receive message

Continued from my previous article. Please, find link here.

Sending XMPP message in windows phone 8 does not require any analysis. Because, it is a method built in with XMPP Client of the DLL.

Below is the syntax required to be followed for sending message.

private void SendXmppMessage(String Message, JId ReceiverJid)

        {

            ObjXmppClient.SendChatMessage(Message.Trim(), ReceiverJid);

        }

But to receive a message from other roster requires handler to initiate the message receiving asynchronously. The handler is OnNewConversationItem.

Syntax is mentioned below

ObjXmppClient.OnNewConversationItem += ObjXmppClient_OnNewConversationItem;

void ObjXmppClient_OnNewConversationItem(RosterItem item, bool bReceived, TextMessage msg)

        {

            if (bReceived)

            {

                //do your property settings

            }

        }

If bReceived ==true then message is received from other roster.

Else then message is sent by you to other roster.

Note : I am working on sample to send and receive files. I will update it soon.

It looks so simple to receive message now right? If yes , please, post a response or feedback or any update required.

I will be hoping to get good feedback and response.

In my next article, I will help you guys to get chat history from openfire server in Windows Phone 8.

Using CTE in sql

CTE in SQL

CTE is abbreviated as Common Table Expression.

CTE holds the query results temporarily later this results set can be manipulated for only next instance. 

Which means CTE is always followed by any DML i.e., Select,Insert,Update,Delete.
Only till the execution of the DML CTE will be able to hold the data (query results).

Please, view the below mentioned sample  with syntax

with cte as
(
    Select * from Table1 join Table2 on Table1.ColumnName=Table2.ColumnName
) 
Select * from cte

Pass CTE results to other CTE 

CTE data can be hold and passed to another CTE 

Example

with cte as
(
    Select * from Table1 join Table2 on Table1.ColumnName=Table2.ColumnName
) ,

cte2
(
    Select * from Table3 join cte on Table3.ColumnName=cte.ColumnName
) 
select * from cte2

Increment column value with simple update statement sql

To increment a column value in sql table with simple update statement is shown below.

DECLARE @incrementer bigint

SET @incrementer = 0

update

tablename

set @incrementer = columnname= @incrementer + 1

This can be achieved even with cursors but we all know the disadvantages of cursors in sql.

This query works even, if column is NULL.

This My first information in MyBlog - Krafting DotNet.