I am pasting this so I can find it latter, so many times I've had to re-write this by hand.

<select name="State"> 
<option value="" selected="selected">Select a State</option> <option value="AL">Alabama</option> 
<option value="AK">Alaska</option> <option value="AZ">Arizona</option> 
<option value="AR">Arkansas</option> <option value="CA">California</option> 
<option value="CO">Colorado</option> <option value="CT">Connecticut</option> 
<option value="DE">Delaware</option> <option value="DC">District Of Columbia</option> 
<option value="FL">Florida</option> <option value="GA">Georgia</option> 
<option value="HI">Hawaii</option> <option value="ID">Idaho</option> 
<option value="IL">Illinois</option> <option value="IN">Indiana</option> 
<option value="IA">Iowa</option> <option value="KS">Kansas</option> 
<option value="KY">Kentucky</option> <option value="LA">Louisiana</option> 
<option value="ME">Maine</option> <option value="MD">Maryland</option> 
<option value="MA">Massachusetts</option> <option value="MI">Michigan</option> 
<option value="MN">Minnesota</option> <option value="MS">Mississippi</option> 
<option value="MO">Missouri</option> <option value="MT">Montana</option> 
<option value="NE">Nebraska</option> <option value="NV">Nevada</option> 
<option value="NH">New Hampshire</option> <option value="NJ">New Jersey</option> 
<option value="NM">New Mexico</option> <option value="NY">New York</option> 
<option value="NC">North Carolina</option> <option value="ND">North Dakota</option> 
<option value="OH">Ohio</option> <option value="OK">Oklahoma</option> 
<option value="OR">Oregon</option> <option value="PA">Pennsylvania</option> 
<option value="RI">Rhode Island</option> <option value="SC">South Carolina</option> 
<option value="SD">South Dakota</option> <option value="TN">Tennessee</option> 
<option value="TX">Texas</option> <option value="UT">Utah</option> 
<option value="VT">Vermont</option> <option value="VA">Virginia</option> 
<option value="WA">Washington</option> <option value="WV">West Virginia</option> 
<option value="WI">Wisconsin</option> <option value="WY">Wyoming</option>
</select>

Today I was working on a project in which I was converting the model from LINQ2SQL to Entity Framework 4.3.  I was going through the regular steps of converting the different calls such as InsertOnSubmit to Add when I ran into a problem with a User Defined function that had been added to the LINQ2SQL dbml model.

Usually the process of adding a user defined function is to simply right click the Entity Framework designer and within the wizard that appears selecting your stored procedure / user defined function from up under the stored procedure heading.  The problem was that nothing appeared there for me.  After about 15 minutes of messing around, I finally realized what the problem was, I simply lacked the permissions on the function.  To fix this you just have to do the following:

1. Right Click on the User Defined Function within Management Studio and select properties.

2. Select the permissions settings and then click the search button.

3. Add the user and the assign him the apropriate permissions, click ok and then your functions should show up.