![]() The main overall impression I feel between XPO and EFCore is that EFCore integrates with my applications, whereas I feel like I have to integrate my applications with XPO. AddNewEmpDetails ( Name varchar (50), City varchar (50), Address varchar (50) ) as begin Insert into Employee. Create the stored procedure to map the above parameters. The more I use it, the more I have the impression that Microsoft has thought of everything. Let's consider we have the following values that need to be inserted into the SQL database using a stored procedure with the help of dapper ORM. After as shown into the image and type in search box 'dapper'. Here are the steps: Right click on Solution ,find Manage NuGet Package manager and click on it. Now next step is to add the reference of Dapper ORM into our created MVC Project. ![]() In spite of this, my preference goes anyway to EFCore: its object model is elegant, coherent and more important : non intrusive. Step 2 : Add The Reference of Dapper ORM into Project.But it is only a question of query formulation. On the other hand, the generation of SQL XPO is particularly powerful, that of EFCore seems very slightly behind. In addition, EFCore has a migration model that is particularly adapted and well thought out. EFCore adapts to any type of class of entities, no matter how rich, of a quasi-transparent material (yes, it is possible), and will thus easily satisfy the needs of both schools that are facing each other: those that incorporate their persistence logic in the business layer, and those that separate it completely. Although XPO is attractive and easy to use with its built-in designer, all XPO objects are linked to an ancestor, which makes working with disconnected objects particularly difficult. WonderfulTonatiuh's Experience Having practiced both XPO and EFCore, I can say that EFCore is much easier to use, at least for people who know what a DBMS is.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |