mvc4 PetaPoco like query throwing exception

Question

I am using petapoco. and making search query with like

please let me know there is right query or not?

var context = new PetaPoco.Database(Connection.connectionstring);

            SqlQuery =

            @"SELECT MenuId, MenuTitle, OrderNumber, CreatedDate, IsActive
            from Menu
            where MenuTitle LIKE @0, '%@MenuTitle%'";

            List<MenuPOCO> objMenuPoco = context.Query<MenuPOCO>
                (
                SqlQuery,
                new
                {
                    @MenuTitle = MenuTitle

                }).ToList();

            return objMenuPoco;

please let me know the syntax is right? I am getting 0 records in each search.

Regards

Ok got now. Correct is : List objMenuPoco = context.Query("SELECT * FROM Menu WHERE MenuTitle LIKE @0", "%" + MenuTitle + "%").ToList(); — dotnetexpert, Aug 16 '13 at 20:04

score 1 · Answer 1 · answered Aug 18 '13 at 10:00

1

var context = new PetaPoco.Database(Connection.connectionstring);

        SqlQuery =

        @"SELECT MenuId, MenuTitle, OrderNumber, CreatedDate, IsActive
        from Menu
        where MenuTitle LIKE @0";

        List<MenuPOCO> objMenuPoco = context.Query<MenuPOCO>(SqlQuery, "%" + MenuTitle + "%").ToList();

        return objMenuPoco;

answered Aug 18 '13 at 10:00

Larry.Z

3,694
1
20
17

see actual query i want to run this one : http://stackoverflow.com/questions/18402194/peta-poco-like-query-issue – dotnetexpert Aug 23 '13 at 11:54

mvc4 PetaPoco like query throwing exception

1 Answers1

Linked