What is C#?

By -

C# is an object oriented, type safe and managed language that is compiled by .Net framework to generate Microsoft Intermediate Language.

Comments

Post a Comment

Popular posts from this blog

Enable HTTP Transport Security (HSTS) in IIS 7

By -
Q.  What is the best way to turn on   HTTP Strict Transport Security   on an IIS 7 web server? Ans:  This can be done by adding following block in Web.Config:               <system.webServer>                     <httpProtocol>                          <customHeaders>                               <add name ="X-CustomName" value="MyCustomValue"/>                                               </customHeaders>                    </httpProtocol>             </system.webServer> We have to configure ...
Read more

Difference Between Delete & Truncate in Sql Server

By -
INTRODUCTION While working on database, we are using Delete and Truncate without knowing the differences between them and when to use them . In this article we will discuss the difference between Delete and Truncate in Sql. Delete Delete is a DML command. Delete statement is executed using a row lock,each row in the table is locked for deletion. We can specify filters in where clause. It deletes specified data if where condition exists. Delete activities a trigger because the operation are logged individually. Slower than Truncate because it Keeps logs Truncate Truncate is a DDL command. Truncate table always lock the table and page but not each row.As it removes all the data. Cannot use Where condition.  It Removes all the data. Truncate table cannot activate a trigger because the operation does not log individual row deletions. Faster in performance wise, because it doesn't keep any logs. Note Delete and Truncate both can be rolled back when used with Tr...
Read more

Add Connection String in Web.Config File

By -
First option can be used for windows authentication and second option is for SQL server authentication. 1. <connectionStrings>     <add name="CustConnectionString" connectionString="Data Source=localhost; Integrated Security=SSPI; Intial Catalog=LocalTestDB" providerName="System.Data.sqlClient"/> </connectionStrings> 2. <connectionStrings>    <add name="CustConnectionString" connectionString="Data Source=localhost; uid=sa; pwd =" providerName="System.Data.sqlClient"/> </connectionStrings>
Read more