One thing you can do is go to the `Properties` window (while you have your DBML file open), and select the class generated for the table you&#39;re interested in from the dropdown list at the top of the `Properties` window.

![enter image description here][1]

Doing so should focus the DBML file visual designer on that table corresponding to that class. Doesn&#39;t work always, but it&#39;s quite helpful when it does work!


  [1]: http://i.stack.imgur.com/5DdXI.png

Is there any real difference between using `&lt;strong&gt;` and `&lt;em&gt;` instead of the CSS properties:

    font-weight: bold;
    font-style: italic;

Also, what is really the reason that both options exist? I could be wrong but didn&#39;t `&lt;strong&gt;` and `&lt;em&gt;` came on the scene quite a while after `font-weight` and `font-style` became standard CSS properties? If so, there must be some reason for them.

&lt;strong&gt; vs. font-weight:bold &amp; &lt;em&gt; vs. font-style:italic

What is the right way to embed an image into email using Rails?

What is the right way to embed image into email using Rails?

We have a design with 150+ tables and in the .dbml layout has lines everywhere and it&#39;s hard to find individual tables.

Is there a way to search in the dbml layout instead of scrolling around trying to locate a table (Ctrl+F don&#39;t work), Running Visual Studio 2010 Ultimate?

Find (search for) table in DBML designer quickly?

<p>We have a design with 150+ tables and in the .dbml layout has lines everywhere and it's hard to find individual tables.</p>
<p>Is there a way to search in the dbml layout instead of scrolling around trying to locate a table (Ctrl+F don't work), Running Visual Studio 2010 Ultimate?</p>


If I press &lt;kbd&gt;F5&lt;/kbd&gt;, my project runs but it doesn&#39;t &quot;see&quot; any of the changes that I made. I need to manually (re)build before pressing &lt;kbd&gt;F5&lt;/kbd&gt; for it to work.

It worked well previously. Any idea what I need to change?

Why doesn&#39;t F5 rebuild project before execution in Visual Studio?

What is the keyboard shortcut navigate back to the last cursor position in Visual Studio?

How to navigate back to the last cursor position in Visual Studio?

Visual Studio 2010 keeps defaulting to VB.NET projects instead of C#, I imported my saved settings from 2008 which defaulted to C# projects which did not resolve the problem..

I always accidentally create VB.NET projects then slap myself in the face as I then proceed to delete the project and recreate a C# version of it.

How do I default Visual Studio to C# projects instead of VB.NET?

I can&#39;t find it for some reason, feeling a little dumb. How do I know? I&#39;m using .net 4 with VS2010.


Which version of MVC am I using?

In [Eclipse][1] there is a shortcut, &lt;kbd&gt;Ctrl&lt;/kbd&gt;+&lt;kbd&gt;Shift&lt;/kbd&gt;+&lt;kbd&gt;F&lt;/kbd&gt;, that re-indents code and fixes comments and blank lines. Is there an equivalent for Visual Studio 2010?

  [1]: http://en.wikipedia.org/wiki/Eclipse_%28software%29


Is there a format code shortcut for Visual Studio?

I would like to search across projects for variable usages, or at least for strings.  I&#39;ve got [IndexYourFiles][1] which works well for text searches, but I have to re-index every now and then and would like an integrated solution.  

Is there any way that I can search across projects in IntelliJ IDEA? So far I have only been able to search within the currently-open project.  I&#39;m guessing IntelliJ can&#39;t do this natively; are there any plug-ins out there to support this?

Thanks.

  [1]: http://www.indexyourfiles.com/

IntelliJ IDEA global search

I find that **find_in_set** only search by a single string :- 

    find_in_set(&#39;a&#39;, &#39;a,b,c,d&#39;)

In the above example, &#39;a&#39; is the only string used for search.

Is there any way to use find_in_set kind of functionality and search by multiple strings, like :- 

    find_in_set(&#39;a,b,c&#39;, &#39;a,b,c,d&#39;)

In the above example, I want to search by three strings &#39;a,b,c&#39;.

One way I see is using **OR**

    find_in_set(&#39;a&#39;, &#39;a,b,c,d&#39;) OR find_in_set(&#39;b&#39;, &#39;a,b,c,d&#39;) OR find_in_set(&#39;b&#39;, &#39;a,b,c,d&#39;)

Is there any other way than this?

MySQL find_in_set with multiple search string

I&#39;m currently designing and implementing a RESTful API in PHP. However, I have been unsuccessful implementing my initial design.

    GET /users # list of users
    GET /user/1 # get user with id 1
    POST /user # create new user
    PUT /user/1 # modify user with id 1
    DELETE /user/1 # delete user with id 1

So far pretty standard, right?

My problem is with the first one `GET /users`. I was considering sending parameters in the request body to filter the list. This is because I want to be able to specify complex filters without getting a super long url, like:

    GET /users?parameter1=value1&amp;parameter2=value2&amp;parameter3=value3&amp;parameter4=value4

Instead I wanted to have something like:

    GET /users
    # Request body:
    {
        &quot;parameter1&quot;: &quot;value1&quot;,
        &quot;parameter2&quot;: &quot;value2&quot;,
        &quot;parameter3&quot;: &quot;value3&quot;,
        &quot;parameter4&quot;: &quot;value4&quot;
    }

which is much more readable and gives you great possibilities to set complex filters.

Anyway, `file_get_contents(&#39;php://input&#39;)` didn&#39;t return the request body for `GET` requests. I also tried `http_get_request_body()`, but the shared hosting that I&#39;m using doesn&#39;t have `pecl_http`. Not sure it would have helped anyway.

I found [this question](https://stackoverflow.com/questions/978061/http-get-with-request-body) and realized that GET probably isn&#39;t supposed to have a request body. It was a bit inconclusive, but they advised against it. 

**So now I&#39;m not sure what to do. How do you design a RESTful search/filtering function?**

I suppose I could use `POST`, but that doesn&#39;t seem very RESTful.

How to design RESTful search/filtering?

I have an array of objects:

    Object = {
       1 : { name : bob , dinner : pizza },
       2 : { name : john , dinner : sushi },
       3 : { name : larry, dinner : hummus }
    }

I want to be able to search the object/array for where the key is &quot;dinner&quot;, and see if it matches &quot;sushi&quot;.

I know jQuery has $.inArray, but it doesn&#39;t seem to work on arrays of objects. Or maybe I&#39;m wrong. indexOf also seems to only work on one array level.

Is there no function or existing code for this?

How to find a value in an array of objects in JavaScript?

I have a question about searching the JSON for the specific information. For example, I have this JSON file:

   

     {
    	&quot;people&quot;: {
    		&quot;person&quot;: [
    			{
    				&quot;name&quot;: &quot;Peter&quot;,
    				&quot;age&quot;: 43,
    				&quot;sex&quot;: &quot;male&quot;
    			}, {
    				&quot;name&quot;: &quot;Zara&quot;,
    				&quot;age&quot;: 65,
    				&quot;sex&quot;: &quot;female&quot;
    			}
    		]
    	}
    }

My question is, how can find a particular person by name and display that person&#39;s age with jQuery?
For example, I want to search the JSON for a person called Peter and when I find a match I want to display additional information about that match (about person named Peter in this case) such as person&#39;s age for example.

How to search JSON tree with jQuery

**Given:**

A table named `TABLE_1` with the following columns:

 - `ID`
 - `ColumnA`
 - `ColumnB`
 - `ColumnC`

I have SQL query where `TABLE_1` joins on itself twice based off of `ColumnA`, `ColumnB`, `ColumnC`. The query might look something like this:

    Select t1.ID, t2.ID, t3.ID
      From TABLE_1 t1
      Left Join TABLE_1 t2 On
           t1.ColumnA = t2.ColumnA
       And t1.ColumnB = t2.ColumnB
       And t1.ColumnC = t2.ColumnC
      Left Join TABLE_1 t3 On
           t2.ColumnA = t3.ColumnA
       And t2.ColumnB = t3.ColumnB
       And t2.ColumnC = t3.ColumnC
    ... and query continues on etc.

**Problem:**

I need that Query to be rewritten in LINQ. I&#39;ve tried taking a stab at it:

    var query =
        from t1 in myTABLE1List // List&lt;TABLE_1&gt;
        join t2 in myTABLE1List
          on t1.ColumnA equals t2.ColumnA
          &amp;&amp; t1.ColumnB equals t2.ColumnA
        // ... and at this point intellisense is making it very obvious
        // I am doing something wrong :(

How do I write my query in LINQ? What am I doing wrong?

LINQ to SQL: Multiple joins ON multiple Columns. Is this possible?

What is difference between .edmx and .dbml file in linq?In VS 2008 which datasource is best choice where edmx or dbml?Any problem will arise using edmx file in VS 2008?Can i use edmx in VS-2008? 

What is difference between .edmx and .dbml file in linq?

I get this error when writing to the database:

&gt; A dependent property in a ReferentialConstraint is mapped to a
&gt; store-generated column. Column: &#39;PaymentId&#39;.

    public bool PayForItem(int terminalId, double paymentAmount, 
          eNums.MasterCategoryEnum  mastercategoryEnum, int CategoryId, int CategoryItemId)
        {

            using (var dbEntities = new DatabaseAccess.Schema.EntityModel())
            {
                int pinnumber = 0;
                long pinid = 1; //getPinId(terminalId,ref pinnumber) ;
                var payment = new DatabaseAccess.Schema.Payment();
                payment.CategoryId = CategoryId;
                payment.ItemCategoryId = CategoryItemId;
                payment.PaymentAmount = (decimal)paymentAmount;
                payment.TerminalId = terminalId;
                payment.PinId = pinid;

                payment.HSBCResponseCode = &quot;&quot;;
                payment.DateActivated = DateTime.Now;
                payment.PaymentString = &quot;Payment&quot;;
                payment.PromotionalOfferId = 1;
                payment.PaymentStatusId = (int)eNums.PaymentStatus.Paid;

                //payment.PaymentId = 1;

                dbEntities.AddToPayments(payment);
                dbEntities.SaveChanges();
            }
            return true;
        }

The schema is:

![enter image description here][1]


  [1]: http://i.stack.imgur.com/ygkYW.png

A dependent property in a ReferentialConstraint is mapped to a store-generated column

What is the difference between `.Select()` and `.Where()` in Entity Framework?
Eg 

    return ContextSet().Select(x=&gt; x.FirstName == &quot;John&quot;)

vs

    ContextSet().Where(x=&gt; x.FirstName == &quot;John&quot;)

When should I use `.Select` vs `.Where`?

Difference between Select and Where in Entity Framework

I&#39;ve been receiving an error on one of my pages that the linq query has timed out as it is taking too long.  It makes the page unusable.

It&#39;s a reports page which is only accessed by administrators around once a day.  It&#39;s unavoidable to trim this query down at all, it just has to sort through a lot of data.

Solutions to fix this I&#39;ve read are by increasing the timeout property in the data context, but I&#39;d like to avoid doing that as it would change it for the entire website.

Is there any way to set a larger time out for individual pages?

Content Type	Original Author	Original Content on Stackoverflow
Question	Andreas	View Question on Stackoverflow
Solution 1 - Visual Studio	marc_s	View Answer on Stackoverflow

Find (search for) table in DBML designer quickly?

Visual Studio Problem Overview

Visual Studio Solutions

Solution 1 - Visual Studio

What is the right way to embed image into email using Rails?

<strong> vs. font-weight:bold & <em> vs. font-style:italic

Attributions