`System.Data.SqlClient` is the .NET Framework Data Provider for SQL Server. ie .NET library for SQL Server.

I don&#39;t know where `providerName=SqlServer` comes from. Could you be getting this confused with the provider keyword in your connection string? (I know I was :) )

In the web.config you should have the `System.Data.SqlClient` as the value of the providerName attribute. It is the .NET Framework Data Provider you are using.

    &lt;connectionStrings&gt;
       &lt;add 
          name=&quot;LocalSqlServer&quot; 
          connectionString=&quot;data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true&quot; 
          providerName=&quot;System.Data.SqlClient&quot;
       /&gt;
    &lt;/connectionStrings&gt;

See
http://msdn.microsoft.com/en-US/library/htw9h4z3(v=VS.80).aspx

     WebConfigurationManager.ConnectionStrings[&quot;YourConnectionString&quot;].ProviderName;

I have a .dll(not my own) that has a delegate. This delegate Callback function is:  
&quot;CallBackFN(ushort opCOde, **IntPtr payload**, uint size, uint localIP)&quot;  

How can i convert IntPtr to Byte[]? I think that payload is actually Byte[]. If it&#39;s not Byte[] and it&#39;s something else would i lose some data?   

C# how to get Byte[] from IntPtr

I am using python 2.6.5
I want to write some japanese characters to a file.
I am getting this error &amp; I don&#39;t know how to change the encoding.

    Python 2.6.5 (r265:79063, Jun 12 2010, 17:07:01)
    [GCC 4.3.4 20090804 (release) 1] on cygwin
    &gt;&gt;&gt; s = u&#39;\u5E73\u621015&#39;
    &gt;&gt;&gt; with open(&quot;yop&quot;, &quot;wb&quot;) as f:
    ...   f.write( s + &quot;\n&quot; );
    ...
    Traceback (most recent call last):
      File &quot;&lt;stdin&gt;&quot;, line 2, in &lt;module&gt;
    UnicodeEncodeError: &#39;ascii&#39; codec can&#39;t encode characters in position 0-1: 
      ordinal not in range(128)
    &gt;&gt;&gt; type( s )
    &lt;type &#39;unicode&#39;&gt;



How to write unicode strings into a file?

We are using ASP.NET (Framework 2) and setting database connection strings (SQL2005) in web.config.

We are currently using &quot;`providerName=SqlServer`&quot;.

All our data accesses are done using `System.Data.SqlClient` - should we therefore change to `providerName=System.Data.SqlClient`? I find many examples of this providerName on the web, but very little explaining what providerName=SqlServer actually means.

Is there a difference? I&#39;m worried that the providerName we currently specify is actually referencing a legacy (and maybe slower) client, or is there an even more efficient client than SqlClient for use with ASP.NET?

SQL providerName in web.config

We are using ASP.NET (Framework 2) and setting database connection strings (SQL2005) in web.config.
We are currently using "<code>providerName=SqlServer</code>".
All our data accesses are done using <code>System.Data.SqlClient</code> - should we therefore change to <code>providerName=System.Data.SqlClient</code>? I find many examples of this providerName on the web, but very little explaining what providerName=SqlServer actually means.
Is there a difference? I'm worried that the providerName we currently specify is actually referencing a legacy (and maybe slower) client, or is there an even more efficient client than SqlClient for use with ASP.NET?

I&#39;m writing a `IHttpHandler` and I&#39;ll need to implement a `IsReusable` property. When I look at the [MSDN documentation][1] it says: 

&gt; Gets a value indicating whether another request can use the 
&gt; IHttpHandler instance.

This isn&#39;t very helpful. **In which situations should I use a reusable handler and in which situations should it not be reusable?**

Follow up questions:

 1. What is reuse?
 2. Can I maintain state (i.e. class variables) when `Reusable = true`??

  [1]: http://msdn.microsoft.com/en-us/library/system.web.ihttphandler.isreusable.aspx

What is the use for IHttpHandler.IsReusable?

is there a way to get the value of a property of a object based on its name?

For example if I have:

    public class Car : Vehicle
    {
       public string Make { get; set; }
    }

and

    var car = new Car { Make=&quot;Ford&quot; };

I want to write a method where I can pass in the property name and it would return the property value. ie:


    public string GetPropertyValue(string propertyName)
    {
       return the value of the property;
    }



How to get a property value based on the name

I receive error emails from my website whenever an exception occurs. I am getting this error:

&gt;The remote host closed the connection. The error code is 0x800704CD

and don&#39;t know why. I get about 30 a day. I can&#39;t reproduce the error either so can&#39;t track down the issue.

Website is ASP.NET 2 running on IIS7.

Stack trace:

&gt; at
&gt; System.Web.Hosting.IIS7WorkerRequest.RaiseCommunicationError(Int32
&gt; result, Boolean throwOnDisconnect) at
&gt; System.Web.Hosting.IIS7WorkerRequest.ExplicitFlush()
&gt; at
&gt; System.Web.HttpResponse.Flush(Boolean
&gt; finalFlush) at
&gt; System.Web.HttpResponse.Flush() at
&gt; System.Web.HttpResponse.End() at
&gt; System.Web.UI.HttpResponseWrapper.System.Web.UI.IHttpResponse.End()
&gt; at
&gt; System.Web.UI.PageRequestManager.OnPageError(Object
&gt; sender, EventArgs e) at
&gt; System.Web.UI.TemplateControl.OnError(EventArgs
&gt; e) at
&gt; System.Web.UI.Page.HandleError(Exception
&gt; e) at
&gt; System.Web.UI.Page.ProcessRequestMain(Boolean
&gt; includeStagesBeforeAsyncPoint, Boolean
&gt; includeStagesAfterAsyncPoint) at
&gt; System.Web.UI.Page.ProcessRequest(Boolean
&gt; includeStagesBeforeAsyncPoint, Boolean
&gt; includeStagesAfterAsyncPoint) at
&gt; System.Web.UI.Page.ProcessRequest() at
&gt; System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext
&gt; context) at
&gt; System.Web.UI.Page.ProcessRequest(HttpContext
&gt; context) at
&gt; ASP.default_aspx.ProcessRequest(HttpContext
&gt; context) at
&gt; System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
&gt; at
&gt; System.Web.HttpApplication.ExecuteStep(IExecutionStep
&gt; step, Boolean&amp; completedSynchronously)

The remote host closed the connection. The error code is 0x800704CD

I have a C# application that must run in x64 mode.  The problem is I try to create unit tests that run methods in the x64 application and the unit test project won&#39;t even build.  I get the following error when it tries to build.

&gt; Error loading C:\.....\bin\x64\Debug\....UnitTests.dll: Unable to load
&gt; the test container &#39;C:\.....\bin\x64\Debug\....UnitTests.dll&#39; or one
&gt; of its dependencies. If you build your test project assembly as a 64
&gt; bit assembly, it cannot be loaded. When you build your test project
&gt; assembly, select &quot;Any CPU&quot; for the platform. To run your tests in 64
&gt; bit mode on a 64 bit processor, you must change your test settings in
&gt; the Hosts tab to run your tests in a 32 bit process. Error details:
&gt; Could not load file or assembly
&gt; &#39;file:///C:\.....UnitTests\bin\x64\Debug\....UnitTests.dll&#39; or one of
&gt; its dependencies. An attempt was made to load a program with an
&gt; incorrect format.

I have tried to change the unit test to x64 and also Any CPU and still cannot get it to run.  Is there any fix for this?

How do I get unit tests to run on a x64 platform

I understand that in general a List is not thread safe, however is there anything wrong with simply adding items into a list if the threads never perform any other operations on the list (such as traversing it)?

Example:

	List&lt;object&gt; list = new List&lt;object&gt;();
	Parallel.ForEach(transactions, tran =&gt;
	{
		list.Add(new object());
	});

List.Add() thread safety

I have the following:

    CREATE NONCLUSTERED INDEX [MyTableIndex]
    ON [dbo].[tablename] ([tablename_ID],[tablename_Field1])
    INCLUDE ([Tablename_Field2],[Tablename_Field3])

I want to create an if statement to check if this exists. How do I do this?


How do I check if a nonclustered index exists in SQL Server 2005

I am trying to order by date. I want the most recent dates coming in first. That&#39;s easy enough, but there are many records that are null and those come before any records that have a date.

I have tried a few things with no success:

    ORDER BY ISNULL(Next_Contact_Date, 0)
    
    ORDER BY ISNULL(Next_Contact_Date, 999999999)
    
    ORDER BY coalesce(Next_Contact_Date, 99/99/9999)

How can I order by date and have the nulls come in last? The data type is `smalldatetime`.

SQL Server ORDER BY date and nulls last

How do I query DateTime database field within a certain range?

I am using SQL SERVER 2005

Error code below

    SELECT * 
      FROM TABLENAME 
     WHERE DateTime &gt;= 12/04/2011 12:00:00 AM 
       AND DateTime &lt;= 25/05/2011 3:53:04 AM

Note that I need to get rows within a certain time range.  Example, 10 mins time range.

Currently SQL return with Incorrect syntax near &#39;12&#39;.&quot;

Simple DateTime sql query

I know this has been asked to death, and I know why SQL Server doesn&#39;t let you do it.


But is there any workaround for this, other than using Extended Stored Procedures?

And please don&#39;t tell me to convert my function into a procedure...

So what I&#39;m really asking is: Is there ANY way to run a Stored Procedure from within a Function?


**EDIT:**

Point proven: there is a way around it, but it&#39;s so **WRONG** I wouldn&#39;t do it. 
I&#39;m gonna change it to a Stored Procedure and execute it elsewhere.


Execute Stored Procedure from a Function

I am involved in a data migration project. I am getting the following error when I try to insert data from one table into another table (SQL Server 2005):

&gt; Msg 8152, Level 16, State 13, Line 1  
&gt; String or binary data would be truncated.

The source data columns match the data type and are within the length definitions of the destination table columns so I am at a loss as to what could be causing this error.


SQL Server String or binary data would be truncated

I&#39;m trying to set up a connecting string in my web.config file (Visual Studio 2008/ASP.NET 3.5) to a local server (SQL server 2008).

In my web.config, how and where do I place the connection string?

Here&#39;s what web.config file looks like right now: http://imwired.net/aspnet/Online_web.config


Setting up connection string in ASP.NET to SQL SERVER

For given [`Connection`][1] instance how do I find out url that the `Connection` uses to connect the database ? Is it somewhere in `Properties` returned by [`Connection.getClientInfo()`][2] method?

If there you need me to provide clearer description all comments are welcome. Thank you


  [1]: http://download.oracle.com/javase/1.4.2/docs/api/java/sql/Connection.html
  [2]: http://download.oracle.com/javase/6/docs/api/java/sql/Connection.html#getClientInfo%28%29

How to get database url from java.sql.Connection?

How can I read a connection string from a `web.config` file into a public class contained within a class library?

I&#39;ve tried:

    WebConfigurationManager

    ConfigurationManager

But these classes are not recognized within my class library.

Read connection string from web.config

I am getting timeouts using the Entity Framework (EF) when using a function import that takes over 30 seconds to complete. I tried the following and have not been able to resolve this issue:

I added `Default Command Timeout=300000` to the connection string in the *App.Config* file in the project that has the EDMX file as suggested [here](https://stackoverflow.com/questions/1718739/entity-framework-with-mysql-timeout-expired-while-generating-model).

This is what my connection string looks like:

&lt;!-- language: xml --&gt;

    &lt;add 
    	name=&quot;MyEntityConnectionString&quot; 
    	connectionString=&quot;metadata=res://*/MyEntities.csdl|res://*/MyEntities.ssdl|
           res://*/MyEntities.msl;
           provider=System.Data.SqlClient;provider connection string=&amp;quot;
           Data Source=trekdevbox;Initial Catalog=StarTrekDatabase;
           Persist Security Info=True;User ID=JamesTKirk;Password=IsFriendsWithSpock;
           MultipleActiveResultSets=True;Default Command Timeout=300000;&amp;quot;&quot;
    	providerName=&quot;System.Data.EntityClient&quot; /&gt;

I tried setting the CommandTimeout in my repository directly like so:

    private TrekEntities context = new TrekEntities();
    
    public IEnumerable&lt;TrekMatches&gt; GetKirksFriends()
    {
        this.context.CommandTimeout = 180;
        return this.context.GetKirksFriends();
    }

What else can I do to get the EF from timing out? This only happens for very large datasets. Everything works fine with small datasets.

Here is one of the errors I&#39;m getting:

&gt; System.Data.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---&gt; System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

---

OK - I got this working and it&#39;s silly what happened. I had both the connection string with `Default Command Timeout=300000` and the CommandTimeout set to 180. When I removed the `Default Command Timeout` from the connection string, it worked. So the answer is to manually set the CommandTimeout in your repository on your context object like so:

    this.context.CommandTimeout = 180;

Apparently setting the timeout settings in the connection string has no effect on it.



Entity Framework Timeouts

    var connection = ConnectionFactory.GetConnection(
        ConfigurationManager.ConnectionStrings[&quot;Test&quot;]
        .ConnectionString, DataBaseProvider);

And this is my App.config: 

&lt;!-- language: lang-xml --&gt;

    &lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot; ?&gt;
    &lt;configuration&gt;
        &lt;connectionStrings&gt;
            &lt;add name=&quot;Test&quot; connectionString=&quot;Data Source=.;Initial Catalog=OmidPayamak;Integrated Security=True&quot; providerName=&quot;System.Data.SqlClient&quot; /&gt;
        &lt;/connectionStrings&gt;
    &lt;/configuration&gt;

But when my project runs this is my error:

&gt;Object reference not set to an instance of an object.

Content Type	Original Author	Original Content on Stackoverflow
Question	Ali	View Question on Stackoverflow
Solution 1 - asp.net	Adrian Toman	View Answer on Stackoverflow
Solution 2 - asp.net	Paul Volkov	View Answer on Stackoverflow

SQL providerName in web.config

asp.net Problem Overview

asp.net Solutions

Solution 1 - asp.net

Solution 2 - asp.net

How to write unicode strings into a file?

C# how to get Byte[] from IntPtr

Attributions