The only difference is the name. 

These can be used interchangeably.

See the documentation of [`SqlConnectionStringBuilder.InitialCatalog`][1], under remarks:

&gt; This property corresponds to the **&quot;Initial Catalog&quot;** and **&quot;database&quot;** keys within the connection string.

(emphasis mine)


  [1]: http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnectionstringbuilder.initialcatalog.aspx

I tried to translate the following Python code to Go 

    import random

    list = [i for i in range(1, 25)]
    random.shuffle(list)
    print(list)

but found my Go version lengthy and awkward because there is no shuffle function and I had to implement interfaces and convert types.

What would be an idiomatic Go version of my code?

shuffle array in Go

I am looking for a simple shell (+curl) check that would evaluate as true or false if an URL exists (returns 200) or not. 



How to check if an URL exists with the shell and probably curl?

What is the main difference between `Initial Catalog` and `Database` Keyword in a connection string?

Difference between Initial Catalog and Database keyword in connection string

<p>What is the main difference between <code>Initial Catalog</code> and <code>Database</code> Keyword in a connection string?</p>


i&#39;m using ADO.NET to get some information from the database on a server,  
so this is what i do:

    string conStr = &quot;Data Source=myServer\SQLEXPRESS;Initial Catalog=DBName;User ID=myUser;Password=myPassword&quot;;
    
    SqlConnection conn = new SqlConnection(conStr);
    
    conn.Open();
    // do stuff
    conn.Close();

but after calling **Open** method i noticed that **conn.ConnectionString** is losing the password so it becomes:

    &quot;Data Source=myServer\SQLEXPRESS;Initial Catalog=DBName;User ID=myUser;&quot;

which causes exception with any SqlCommand afterwords  
how to fix this?   
Note:The strange thing is that does not happen always    
Edit: i don&#39;t think it has anything to do with the command it self but anyway  

    SqlCommand command = new SqlCommand(&quot;select GetDate()&quot;, conn);
    SqlDataReader reader = command.ExecuteReader();



ConnectionString loses password after connection.Open

Can I execute multiple queries and return their results executing a `SqlCommand` just once?

How do I return multiple result sets with SqlCommand?

I have following code for specifying parameters for SQL query. I am getting following exception when I use `Code 1`; but works fine when I use `Code 2`. In `Code 2` we have a check for null and hence a `if..else` block. 

Exception:  

&gt; *The parameterized query &#39;(@application\_ex\_id nvarchar(4000))SELECT  E.application\_ex\_id A&#39; expects the parameter &#39;@application\_ex\_id&#39;, which was not supplied.*

**Code 1**:

    command.Parameters.AddWithValue(&quot;@application_ex_id&quot;, logSearch.LogID);

**Code 2**:

    if (logSearch.LogID != null)
    {
             command.Parameters.AddWithValue(&quot;@application_ex_id&quot;, logSearch.LogID);
    }
    else
    {
            command.Parameters.AddWithValue(&quot;@application_ex_id&quot;, DBNull.Value );
    }


**QUESTION**

1. Can you please explain why it is unable to take NULL from logSearch.LogID value in Code 1 (but able to accept DBNull)? 

2. Is there a better code to handle this?


**Reference**:

1.  https://stackoverflow.com/questions/4555935/how-to-assign-null-to-a-sqlparameter
2. https://stackoverflow.com/questions/13306275/datatype-returned-varies-based-on-data-in-table
3. https://stackoverflow.com/questions/13265704/conversion-error-from-database-smallint-into-c-sharp-nullable-int?lq=1
4. https://stackoverflow.com/questions/4488727/what-is-the-point-of-dbnull/9632050#9632050  
 
CODE

        public Collection&lt;Log&gt; GetLogs(LogSearch logSearch)
        {
            Collection&lt;Log&gt; logs = new Collection&lt;Log&gt;();

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();

                string commandText = @&quot;SELECT  *
                    FROM Application_Ex E 
                    WHERE  (E.application_ex_id = @application_ex_id OR @application_ex_id IS NULL)&quot;;
                    
                using (SqlCommand command = new SqlCommand(commandText, connection))
                {
                    command.CommandType = System.Data.CommandType.Text;

                    //Parameter value setting
                    //command.Parameters.AddWithValue(&quot;@application_ex_id&quot;, logSearch.LogID);
                    if (logSearch.LogID != null)
                    {
                        command.Parameters.AddWithValue(&quot;@application_ex_id&quot;, logSearch.LogID);
                    }
                    else
                    {
                        command.Parameters.AddWithValue(&quot;@application_ex_id&quot;, DBNull.Value );
                    }

                    using (SqlDataReader reader = command.ExecuteReader())
                    {
                        if (reader.HasRows)
                        {
                            Collection&lt;Object&gt; entityList = new Collection&lt;Object&gt;();
                            entityList.Add(new Log());

                            ArrayList records = EntityDataMappingHelper.SelectRecords(entityList, reader);

                            for (int i = 0; i &lt; records.Count; i++)
                            {
                                Log log = new Log();
                                Dictionary&lt;string, object&gt; currentRecord = (Dictionary&lt;string, object&gt;)records[i];
                                EntityDataMappingHelper.FillEntityFromRecord(log, currentRecord);
                                logs.Add(log);
                            }
                        }

                        //reader.Close();
                    }
                }
            }

            return logs;
        }

Exception when AddWithValue parameter is NULL

I am creating a project in which I need to run 2-3 SQL commands in a single SQL connection.
Here is the code I have written: 

    SqlConnection con = new SqlConnection(@&quot;Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\project.mdf;Integrated Security=True&quot;);
    con.Open();
    SqlCommand cmd = new SqlCommand(&quot;select *  from &quot; + mytags.Text + &quot; &quot;, con);
    SqlDataReader rd = cmd.ExecuteReader();
    if (rd.Read())
    {
        con.Close();
        con.Open();
        SqlCommand cmd1 = new SqlCommand(&quot;insert into &quot; + mytags.Text + &quot; values (&#39;fname.lname@gmail.com&#39;,&#39;&quot; + TextBox3.Text + &quot;&#39;,&#39;&quot; + TextBox4.Text + &quot;&#39;,&#39;&quot; + TextBox5.Text + &quot;&#39;,&#39;&quot;+mytags.Text+&quot;&#39;)&quot;, con);
        cmd1.ExecuteNonQuery();
        label.Visible = true;
        label.Text = &quot;Date read and inserted&quot;;
    }
    else
    {
        con.Close();
        con.Open();
        SqlCommand cmd2 = new SqlCommand(&quot;create table &quot; + mytags.Text + &quot; ( session VARCHAR(MAX) , Price int , Description VARCHAR(MAX), Date VARCHAR(20),tag VARCHAR(10))&quot;, con);
        cmd2.ExecuteNonQuery();
        con.Close();
        con.Open();
        SqlCommand cmd3 = new SqlCommand(&quot;insert into &quot; + mytags.Text + &quot; values (&#39;&quot; + Session + &quot;&#39;,&#39;&quot; + TextBox3.Text + &quot;&#39;,&#39;&quot; + TextBox4.Text + &quot;&#39;,&#39;&quot; + TextBox5.Text + &quot;&#39;,&#39;&quot; + mytags.Text + &quot;&#39;)&quot;, con);
        cmd3.ExecuteNonQuery();
        label.Visible = true;
        label.Text = &quot;tabel created&quot;;
        con.Close();
    }
            
I have tried to remove the error and I got that the connection is not going to else condition. Please review the code and suggest if there is any mistake or any other solution for this.

How to run multiple SQL commands in a single SQL connection?

I have to insert about 2 million rows from a text file.

And with inserting I have to create some master tables. 

What is the best and fast way to insert such a large set of data into SQL Server?



Content Type	Original Author	Original Content on Stackoverflow
Question	ravi	View Question on Stackoverflow
Solution 1 - ado.net	Oded	View Answer on Stackoverflow

Difference between Initial Catalog and Database keyword in connection string

ado.net Problem Overview

ado.net Solutions

Solution 1 - ado.net

How to check if an URL exists with the shell and probably curl?

shuffle array in Go

Attributions