More then one element exception

احمد صدقی

7y1.1k.NET

I have 2 tables in my database, one is for company and another is for Branch. When i crate a branch i must be select my company, so in that case i would like to take dropdown in my branch form. in dropdown i bind company id and company name from m_com(table)

foreach (var item in brnch)
            {
                Company company = new Company();
                company.com_nam = item.com_nam;
                company.com_id = item.com_id;
                br.comModel.Add(company);
            }

when i click on submit button com_id return with " , " eg: ",05 ". so in that case i get error of more then one variable exception.

public ActionResult Create(Branch model)
        {
            if (ModelState.IsValid)
            {
                var temp = Request.Form["com_id"].ToString();
                string strNew = temp.Replace(" , ", " ");
                m_br brpany = new m_br();
                var br = erkDB.m_br.OrderByDescending(x => x.br_id).SingleOrDefault().br_id;

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Salman Beg7y ago
Accepted answer
Hey.
As you are using SingleOrDefault, So in SingleOrDefault, either single or no record should be exists. But in your case it conatins more than one record and due to that reason it is showing more than one element exception. In place of SingleOrDefault, you can use FirstOrDefault. FirstOrDefault will give you the first record irrespective of how many record present.
Thanks.
+1
احمد صدقی7y ago
Now I get another error after replace singleordefault to firstordefault:

An exception of type 'System.Data.Entity.Infrastructure.DbUpdateException' occurred in EntityFramework.dll but was not handled in user code

Additional information: An error occurred while updating the entries. See the inner exception for details.
+1
احمد صدقی7y ago
Salman Beg
can you please take my teamviewer?
+1
احمد صدقی7y ago
the problem is some thing else, plese read my discription
0
Muthu Kumar7y ago
Hi,

Please check below links,

https://stackoverflow.com/questions/15021257/invalidoperationexception-sequence-contains-more-than-one-element

https://stackoverflow.com/questions/22691622/sequence-contains-more-than-one-element-singleordefault-not-helping/22691701
0

More then one element exception

Salman Beg