How can be dynamic this query of npoco

Multi tool use
Multi tool use












0















Instead of the adding search method to every class like this;



    public List<InvoiceDetail> SearchById(int Id)
{
return db.Query<InvoiceDetail>()
.Where(x => x.Id == Id)
.ToList();
}


How to add a method to base class like this;



    public virtual List<T> SearchById(int Id)
{
return db.Query<T>()
.Where(x => x.Id == Id)
.ToList();
}


"T does not contain a definition for Id"



Because Id is the definition of Detail entities.










share|improve this question




















  • 1





    See : docs.microsoft.com/en-us/dotnet/csharp/programming-guide/… - can you add a base class/interface constraint on allowed type of T

    – PaulF
    Jan 2 at 11:13
















0















Instead of the adding search method to every class like this;



    public List<InvoiceDetail> SearchById(int Id)
{
return db.Query<InvoiceDetail>()
.Where(x => x.Id == Id)
.ToList();
}


How to add a method to base class like this;



    public virtual List<T> SearchById(int Id)
{
return db.Query<T>()
.Where(x => x.Id == Id)
.ToList();
}


"T does not contain a definition for Id"



Because Id is the definition of Detail entities.










share|improve this question




















  • 1





    See : docs.microsoft.com/en-us/dotnet/csharp/programming-guide/… - can you add a base class/interface constraint on allowed type of T

    – PaulF
    Jan 2 at 11:13














0












0








0








Instead of the adding search method to every class like this;



    public List<InvoiceDetail> SearchById(int Id)
{
return db.Query<InvoiceDetail>()
.Where(x => x.Id == Id)
.ToList();
}


How to add a method to base class like this;



    public virtual List<T> SearchById(int Id)
{
return db.Query<T>()
.Where(x => x.Id == Id)
.ToList();
}


"T does not contain a definition for Id"



Because Id is the definition of Detail entities.










share|improve this question
















Instead of the adding search method to every class like this;



    public List<InvoiceDetail> SearchById(int Id)
{
return db.Query<InvoiceDetail>()
.Where(x => x.Id == Id)
.ToList();
}


How to add a method to base class like this;



    public virtual List<T> SearchById(int Id)
{
return db.Query<T>()
.Where(x => x.Id == Id)
.ToList();
}


"T does not contain a definition for Id"



Because Id is the definition of Detail entities.







c# npoco






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Jan 2 at 10:59







Crusel

















asked Jan 2 at 10:36









CruselCrusel

82




82








  • 1





    See : docs.microsoft.com/en-us/dotnet/csharp/programming-guide/… - can you add a base class/interface constraint on allowed type of T

    – PaulF
    Jan 2 at 11:13














  • 1





    See : docs.microsoft.com/en-us/dotnet/csharp/programming-guide/… - can you add a base class/interface constraint on allowed type of T

    – PaulF
    Jan 2 at 11:13








1




1





See : docs.microsoft.com/en-us/dotnet/csharp/programming-guide/… - can you add a base class/interface constraint on allowed type of T

– PaulF
Jan 2 at 11:13





See : docs.microsoft.com/en-us/dotnet/csharp/programming-guide/… - can you add a base class/interface constraint on allowed type of T

– PaulF
Jan 2 at 11:13












1 Answer
1






active

oldest

votes


















2














You can achieve this by creating a base class as:



public class BaseEntity
{
public int Id { get; set; }
}


Then make the appropriate entity classes inherit from BaseEntity as:



public class Detail : BaseEntity
{
//some props for Detail class only
}


Now for your search method you can use the where T : class constrain as:



public List<T> SearchById<T>(int id) where T : BaseEntity
{
return db.Query<T>()
.Where(x => x.Id == Id)
.ToList();
}





share|improve this answer

























    Your Answer






    StackExchange.ifUsing("editor", function () {
    StackExchange.using("externalEditor", function () {
    StackExchange.using("snippets", function () {
    StackExchange.snippets.init();
    });
    });
    }, "code-snippets");

    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "1"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54004799%2fhow-can-be-dynamic-this-query-of-npoco%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    2














    You can achieve this by creating a base class as:



    public class BaseEntity
    {
    public int Id { get; set; }
    }


    Then make the appropriate entity classes inherit from BaseEntity as:



    public class Detail : BaseEntity
    {
    //some props for Detail class only
    }


    Now for your search method you can use the where T : class constrain as:



    public List<T> SearchById<T>(int id) where T : BaseEntity
    {
    return db.Query<T>()
    .Where(x => x.Id == Id)
    .ToList();
    }





    share|improve this answer






























      2














      You can achieve this by creating a base class as:



      public class BaseEntity
      {
      public int Id { get; set; }
      }


      Then make the appropriate entity classes inherit from BaseEntity as:



      public class Detail : BaseEntity
      {
      //some props for Detail class only
      }


      Now for your search method you can use the where T : class constrain as:



      public List<T> SearchById<T>(int id) where T : BaseEntity
      {
      return db.Query<T>()
      .Where(x => x.Id == Id)
      .ToList();
      }





      share|improve this answer




























        2












        2








        2







        You can achieve this by creating a base class as:



        public class BaseEntity
        {
        public int Id { get; set; }
        }


        Then make the appropriate entity classes inherit from BaseEntity as:



        public class Detail : BaseEntity
        {
        //some props for Detail class only
        }


        Now for your search method you can use the where T : class constrain as:



        public List<T> SearchById<T>(int id) where T : BaseEntity
        {
        return db.Query<T>()
        .Where(x => x.Id == Id)
        .ToList();
        }





        share|improve this answer















        You can achieve this by creating a base class as:



        public class BaseEntity
        {
        public int Id { get; set; }
        }


        Then make the appropriate entity classes inherit from BaseEntity as:



        public class Detail : BaseEntity
        {
        //some props for Detail class only
        }


        Now for your search method you can use the where T : class constrain as:



        public List<T> SearchById<T>(int id) where T : BaseEntity
        {
        return db.Query<T>()
        .Where(x => x.Id == Id)
        .ToList();
        }






        share|improve this answer














        share|improve this answer



        share|improve this answer








        edited Jan 2 at 13:01

























        answered Jan 2 at 11:28









        IzzyIzzy

        3,96451946




        3,96451946
































            draft saved

            draft discarded




















































            Thanks for contributing an answer to Stack Overflow!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54004799%2fhow-can-be-dynamic-this-query-of-npoco%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            sE2 fiEm52S2e9OTLMI1M,PH2DuCcbZg8YTDH UBPhV7iDZY,pOh9sDe9JX,fDQsivOXX8H9PyJ0SWPnwIPtYgw0KzXZ0ujcjE,KS5
            XxH7mBr,MOIt2OnBTCoLgjqdeD9nhDWIHdV,V4l4BhuFncs0vBtpt6tew0sK8l0voPYfWqk8Ai,nnI2hv1J T,SJyrWF5

            Popular posts from this blog

            Monofisismo

            Angular Downloading a file using contenturl with Basic Authentication

            Olmecas