SQL database for multiple users [closed]

1

Well, I have a question. I'm developing a web application that will serve more than one user, however each user has different data recorded in the database, and this volume will be great since the system is for sales management.

I would like to know what it would be like for me to make the application bank, put a idUsuario on each item in the bank and search for it by filtering, or is there any way to bring more performance to the application?

Thank you!

    
asked by anonymous 03.06.2015 / 19:47

1 answer

1

If most queries within the system will involve the user parameter, yes, you will need to parameterize all tables with the Id of the user, because this is an Entity Framework design requirement.

To assist in parameterizing queries without having to populate the user every time, you can use the NuGet EntityFramework.DynamicFilters package % .

    
03.06.2015 / 23:44