Problem with converting int to string in Linq to entities

var items = from c in contacts select new ListItem { Value = c.ContactId, //Cannot implicitly convert type 'int' (ContactId) to 'string' (Value). Text = c.Name }; var items = from c in contacts select new ListItem { Value = c.ContactId.ToString(), //Throws exception: ToString is not supported in linq to entities. Text = c.Name }; … Read more

Has Microsoft confirmed their stance on LINQ to SQL end-of-life?

I’m trying to make an educated decision about what ORM to use for a number of legacy applications I’m responsible for porting to MVC 2. The ORMs I’ve looked at are LINQ to SQL, LINQ to Entities and nHibernate. L2S seemed to be the easiest, but I’ve found numerous articles and blog entries stating that Microsoft would no longer be updating it after .NET 3.5. With that in mind, I’ve been working with Entities a bit, but have found that it is cumbersome and overcomplicated for the small applications I’m working with (same with nHibernate). I recently purchased “Pro ASP.NET MVC 2 Framework” by Steven Sanderson, in which he chose to use LINQ to SQL as his ORM, at one point stating:

How to add a default “Select” option to this ASP.NET DropDownList control?

I am a new ASP.NET developer and I am trying to learn Linq-To-Entities. I am trying to bind a DropDownList with the Linq statement for retrieving the list of status in the Status Entity. Everything is working fine. However, I am trying now to add “Select” option to the DropDownList but It doesn’t work with me.
Could you please tell me how to fix this?