How to insert a string value with an apostrophe (single quote) in a column

 INSERT INTO testtable VALUES (1,'Naresh C'houlla')

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ‘houlla’.
Msg 105, Level 15, State 1, Line 1
Unclosed quotation mark after the character string ‘)

 INSERT INTO testtable VALUES (1,'Naresh C''houlla')

Windows Malicious Software Removal Tool and record screen

Windows Malicious Software Removal Tool without software installation.. 

type mrt in the Windows search bar or Windows + R and type mrt.. 

and record - windows + alt +r or windows + g 

Cannot create/shadow copy 'dll' when that file already exists.

 updating your web.config with the following entry:

<configuration>

   <system.web>

      <hostingEnvironment shadowCopyBinAssemblies="false" />

   </system.web>

</configuration>

Anti forgery token is meant for user "" but the current user is "loginusermainid"

 Login time, if we click ,multiple time we will get this exception. that time use application error and rediredt to after login page

protected void Application_Error(object sender, EventArgs e)

      {

           try

            {

                string controller = Request.RequestContext.RouteData.Values["controller"].ToString();

                string action = Request.RequestContext.RouteData.Values["action"].ToString();

                Exception exception = Server.GetLastError();

                if (exception != null)

                {

                    if (exception is HttpAntiForgeryException)

                    {

                        

                        Response.Redirect("~/Account/Dashboard");

                    }

                }

            }

            catch (Exception ex)

            {

             throw;

            }

        }

The JSON request was too large to be deserialized.

 <appSettings>

  <add key="aspnet:MaxJsonDeserializerMembers" value="150000" />

</appSettings>

iis service manager - the process cannot access the file because it is being used by another process

if you are doing publish in local or local server.. if you change your port number application will work.. published code run in  your server or local machine

An error occurred while trying to restore packages.

 %appdata%\NuGet\NuGet.Config

 <?xml version="1.0" encoding="utf-8"?>
<configuration>
<packageRestore>
<add key="enabled" value="True" />
<add key="automatic" value="True" />
</packageRestore>
<packageSources>
<add key="nuget.org" value="https://api.nuget.org/v3/index.json" protocolVersion="3" />
<add key="nuget.org" value="https://www.nuget.org/api/v2/" />
<add key="Package source" value="E:\Download" />
</packageSources>
<activePackageSource>
<add key="All" value="(Aggregate source)" />
</activePackageSource>
</configuration>

  

Unable to update the EntitySet 'TableName' because it has a DefiningQuery and no element exists in the element to support the current operation.

Table don't have a primary key.. add primary and update edmx..

unable to check out the current file. the file may be read only or locked

 Goto tools > Options > Source Control > Current source control  plug- in select None and try to add service Or project run in admin mode and add.. it will work

Foreach entity framework query

 employee.ForEach(em=>
                    {
                        em.sal= (em.sal !=null ?em.sal:0);
                    });