Just press &lt;kbd&gt;F4&lt;/kbd&gt;.

This will pop up the `Add Reference` dialog.


----------
![Add reference to linqpad][1]


  [1]: http://i.stack.imgur.com/Raw0A.png

You can also use the menu option to access the popup window to add references.

- Notice the &gt;&gt; arrows in menu bar. Click on it. 

- Go to *Query* menu. Find *References and Properties*. Click on it.


Following is example image from LINQPad 5:

[![enter image description here][1]][1]


  [1]: https://i.stack.imgur.com/zIWL8.png

**This doesn&#39;t apply to your case but may be helpful for others that had the same issue as me**. My issue was with a &quot;missing&quot; system type (`Task&lt;T&gt;`) since LinqPad didn&#39;t had the *using* it by default. One way to add it on LinqPad is pressing `F4` &gt; `Namespace Imports` tabs and adding at the bottom of the list `System.Threading.Tasks` then press `Ok`. 

You can also set this new list as the default for the new queries pressing `Set as default for new queries`

[![Go by shortcut][1]][1]

Other way to access this tab is by the top menu `Query` &gt; `Namespace Imports`

[![Go by the query menu][2]][2]


  [1]: https://i.stack.imgur.com/F3L5k.png
  [2]: https://i.stack.imgur.com/iGvAq.png

I had to do &lt;kbd&gt;fn&lt;/kbd&gt; and &lt;kbd&gt;F4&lt;/kbd&gt; at the same time.

How can I randomize lots of rows in Excel?  

    For example I have an excel sheet with data in 3 rows. 
    1 A dataA
    2 B dataB
    3 C dataC
    
    I want to randomize the row order. For example
    2 B dataB
    1 A dataA
    3 C dataC

I could make a new column and fill it with random numbers using =RAND() and sort based on that column. 

But is this the best way to do it? The RAND equation will provide up to [a million random numbers][1] and I have a quarter of a million rows so it seems like it would work.  

Thanks 

I searched for a bit and while [this answer about randomizing columns][2] is close it seems like way overkill. 


  [1]: http://support.microsoft.com/kb/86523
  [2]: https://stackoverflow.com/questions/10651553/randomize-columns

How to randomize Excel rows

My application crashed with the reason:

&gt; -[MyClassName copyWithZone:]  unrecognized selector sent to instance

I have two classes. Let&#39;s say Class1 and Class2.

Class1 looks like:

###Class1.h

    @interface Class1 : NSObject {
        NSString *imagemd5CheckSum;
        UIImage *image;
        NSData *fileChunkData;
    }

    @property (nonatomic, copy)NSString *imagemd5CheckSum;
    @property (nonatomic, copy)UIImage *image;
    @property (nonatomic, copy)NSData *fileChunkData;

    @end


###Class1.m

    @implementation Class1

    @synthesize image;
    @synthesize fileChunkData;
    @synthesize imagemd5CheckSum;

    -(id) init{
        [self setImage:nil];
        [self setFileChunkData:nil];
        [self setImagemd5CheckSum:@&quot;&quot;];

        return self;
    }

    -(void)dealloc{
        [imagemd5CheckSum release];
        [image release];
        [fileChunkData release];

        fileChunkData = nil;
        imagemd5CheckSum = nil;
        image = nil;

        [super dealloc];
    }
    @end

**

&gt; Class2 looks like

**

###Class2.h
*********

    #import &quot;Class2.h&quot;
    @interface Class2 : NSObject {
        Class1 *obj1;
        Class1 *obj2;
        Class1 *obj3;
    }

    @property (nonatomic, copy)Class1 *obj1;
    @property (nonatomic, copy)Class1 *obj2;
    @property (nonatomic, copy)Class1 *obj3;

    @end

###Class2.m
********

    @implementation Class2

    @synthesize obj1,obj2,obj3;

    -(id) init{
        [self setObj1:nil];
        [self setObj2:nil];
        [self setObj3:nil];

        return self;
    }

    -(void)dealloc{
        [obj1 release];
        [obj2 release];
        [obj3 release];

        obj1 = nil;
        obj2 = nil;
        obj3 = nil;

        [super dealloc];
    }
    @end

###Crashed Situation

    Class2 *class2 = [[Class2 alloc] init];

    Class1 *class1 = [[Class1 alloc] init];

    [class1 setImagemd5CheckSum:@&quot;this is md5&quot;];
    [class1 setImage:myimage];
    [class1 setFileChunkData:myData];

    [class2 setObj1:class1]; // This line is crashed..

...

When I called `[class2 setObj1:class1];`, the application crashed with reason:

&gt; -[Class1 copyWithZone:]  unrecognized selector sent to instance

How can I fix this problem?


-[MyClassName copyWithZone:] unrecognized selector sent to instance

Is there a posibility to add a reference to an assembly in LINQPad?

I have some types in my assembly and I would like to use them in my LINQPad queries.

How to add a reference to an assembly in LINQPad to access custom types?

<p>Is there a posibility to add a reference to an assembly in LINQPad?</p>
<p>I have some types in my assembly and I would like to use them in my LINQPad queries.</p>


I&#39;ve been having trouble using the `TransactionScope` to wrap multiple database queries into a transaction, I am using SqlBulkCopy with batchsize 500. When I increased the batch size to 1000 I am getting the error:

&gt; The transaction associated with the current connection has completed
&gt; but has not been disposed. The transaction must be disposed before the
&gt; connection can be used to execute SQL statements.

This is the code I am using:

    using (var scope = new TransactionScope())
	{
		using (var connection = (SqlConnection)customerTable.OpenConnection())
		{
			var table1BulkCopy = new SqlBulkCopy(connection)
			{
				BatchSize = BATCH_SIZE,
				DestinationTableName = TableName1
			};
		   
			table1BulkCopy.WriteToServer(table1DataTable);
		   
			var table2BulkCopy = new SqlBulkCopy(connection)
			{
				BatchSize = BATCH_SIZE,
				DestinationTableName = TableName2
			};
			
			table2BulkCopy.WriteToServer(table2DataTable);
						 
			var table3BulkCopy = new SqlBulkCopy(connection)
			{
				BatchSize = BATCH_SIZE,
				DestinationTableName = TableName3
			};
		   
			table1BulkCopy.WriteToServer(table3DataTable);
											
			var table4BulkCopy = new SqlBulkCopy(connection)
			{
				BatchSize = BATCH_SIZE,
				DestinationTableName = TableName4
			};
		   
			table4BulkCopy.WriteToServer(table4DataTable);
		   
			scope.Complete();
		}
	}

Error - The transaction associated with the current connection has completed but has not been disposed

I have a WP7 game that uses RESTsharp to communicate with my MVC4 RESTful server, but I often have issues making requests that work and therefore I want to debug where it fails.

This is an example where the Constructor on my `GameController` is hit, but the `Post` method is not hit, and I don&#39;t understand why.

Client code: 

    public void JoinRandomGame()
    {
      client = new RestClient
      {
          CookieContainer = new CookieContainer(),
          BaseUrl = &quot;http://localhost:21688/api/&quot;,
      };
            
      client.Authenticator = GetAuth();

      RestRequest request = new RestRequest(Method.POST)
      {
          RequestFormat = DataFormat.Json,
          Resource = &quot;game/&quot;
                
      };

      client.PostAsync(request, (response, ds) =&gt;
      {});
    }

Server code:

        public void Post(int id)
        {
            if (ControllerContext.Request.Headers.Authorization == null)
            {
                //No auth
            }
            if (!loginManager.VerifyLogin(ControllerContext.Request.Headers.Authorization.Parameter))
            {
                //Failed login
            }

            string username;
            string password;
            LoginManager.DecodeBase64(ControllerContext.Request.Headers.Authorization.Parameter, out username, out password);
            gameManager.JoinRandomGame(username);
        }

My routes are like this 

           routes.MapHttpRoute(
                name: &quot;gameAPI&quot;,
                routeTemplate: &quot;api/game/{gameId}&quot;,
                defaults: new
                {
                    controller = &quot;game&quot;,
                    gameId = RouteParameter.Optional
                }             
            );

How do you debug MVC 4 API routes?

    string strName = &quot;John&quot;;
    public enum Name { John,Peter }
    
    private void DoSomething(string myname)
    {
    case1:
         if(myname.Equals(Name.John) //returns false
         {
            
         }
    
    case2:
         if(myname == Name.John) //compilation error
         {
            
         }
    
    case3:
         if(myname.Equals(Name.John.ToString()) //returns true (correct comparision)
         {
            
         }
    }

when I use `.Equals` it is reference compare and when I use `==` it means value compare. 

Is there a better code instead of converting the enum value to `ToString()` for comparison? because it destroys the purpose of value type enum and also, `ToString()` on enum is deprecated??

how to compare string with enum in C#

I have some utility functions and Pagination function. I want to create classes named Utility and Pagination for these functions respectively, so that I can use these class function in more than one controllers.

So where can I put these class in my folder structure, and how can I access then?

Where can I put custom classes in ASP.NET MVC?

When calling [Any()][1] on a null object, it throws an ArgumentNullException in C#. If the object is null, there definitely aren&#39;t &#39;any&#39;, and it should probably return false.  

Why does C# behave this way?

  [1]: http://msdn.microsoft.com/en-us/library/bb337697 &quot;Microsoft Documentation&quot;

Why doesn&#39;t Any() work on a c# null object

I have a problem with committing changes in LinqPad. I am using Oracle database over IQ driver in LinqPad. I can retrieve data but I don&#39;t know how to submit changes to database. 

I retrieve data from database:
 
     var items = Asyncqueue.Where(x =&gt; ids.Any(y=&gt; y == x.Asyncqueueid));
     // then I have to fix data 

I have tried to set submit action like this:
  
     Asyncqueue.SetSubmitAction(items, SubmitAction.Update);





 

Content Type	Original Author	Original Content on Stackoverflow
Question	miron	View Question on Stackoverflow
Solution 1 - .Net	sloth	View Answer on Stackoverflow
Solution 2 - .Net	SSD	View Answer on Stackoverflow
Solution 3 - .Net	Luxant	View Answer on Stackoverflow
Solution 4 - .Net	thedanotto	View Answer on Stackoverflow

How to add a reference to an assembly in LINQPad to access custom types?

.Net Problem Overview

.Net Solutions

Solution 1 - .Net

Solution 2 - .Net

Solution 3 - .Net

Solution 4 - .Net

-[MyClassName copyWithZone:] unrecognized selector sent to instance

How to randomize Excel rows

Attributions