mvc4 PetaPoco 之类的查询抛出异常 [英] mvc4 PetaPoco like query throwing exception

问题描述

我正在使用 petapoco.并使用 like

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;

请让我知道语法是否正确?我在每次搜索中得到 0 条记录.

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

问候

推荐答案

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;

这篇关于mvc4 PetaPoco 之类的查询抛出异常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！