Search multiple tables ASP.NET MVC

Question

I have implemented as search function on my website that uses 1 table using the following function.

Search function

[HttpPost]
        public ActionResult Results(string SearchString)
        {
            using (var objCtx = new ApplicationDbContext())
            {
                var Restaurant = from u in objCtx.Restaurants
                           select u;


                if (!String.IsNullOrEmpty(SearchString))
                {
                    Restaurant = Restaurant.Where(s => s.Name.Contains(SearchString));
                }

                return View(Restaurant.ToList());
            }
        }

Is it possible to extend this function so that it can search through multiple tables without using a search engine such as Lucene.net?

Any help would be greatful.

MoustafaAAtta · Accepted Answer · 2014-02-27 17:48:41Z

3

You can query the tables then merge the iqueryable lists

var Restaurant = from u in objCtx.Restaurants
                       select u;

if (!String.IsNullOrEmpty(SearchString))
{
    Restaurant = Restaurant.Where(s => s.Name.Contains(SearchString));
}

// Second table.
var Restaurant2 = from u in objCtx.Restaurants2
                       select u;


if (!String.IsNullOrEmpty(SearchString))
{
    Restaurant2 = Restaurant2.Where(s => s.Name.Contains(SearchString));
}

return View(Restaurant.Union(Restaurant2).ToList());

or

return View(Restaurant.Concat(Restaurant2).ToList());

answered Feb 27, 2014 at 17:48

MoustafaAAtta

1,08113 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Search multiple tables ASP.NET MVC

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related