Git Product home page Git Product logo

Comments (4)

mcshaz avatar mcshaz commented on July 29, 2024 1

@Tommixoft - if you use my fork of this project at https://github.com/mcshaz/Daarto it should work. download my fork and import it to your solution as a separate project, link your main app to the above project as a dependency, and uninstall the nuget package. You will still need to run the SQL to create the database and tables before starting your application, and of course have a working database connection string. All the SQL required to set up the DB is under the https://github.com/giorgos07/Daarto/tree/master/misc/database/IdentityDb/dbo/Tables folder.

As an aside, I wouldn't call EF garbage - it has its place, it is simply that the use scenarios are not universal, and reasons for avoiding it include a) a legacy project with lots of complex SQL already written, b) thorough knowledge of SQL and the time learning linq-to-entities would not be worth it to the developer, c) absolute performance, including running queries concurrently is important d) complete control of transaction scope is required.

from daarto.

Tommixoft avatar Tommixoft commented on July 29, 2024

yeah i too get this error. New to ASP .NET doing all i can to avoid using that garbage called EntityFramework..but so far no luck..every solution i tried-is not working, including this one... My database have no tables...so how it suppose to work? :)
And when uncommenting code i get error you talking about

       services.AddDefaultIdentity<IdentityUser>()
                    .AddDapperStores();

from daarto.

Tommixoft avatar Tommixoft commented on July 29, 2024

Thanks @mcshaz , will try, but i gave up and started to use EF + MySQL. and now finally have working Identity. But having now EF im forced to use it in every class... and be slave for it's overloaded rules :) for terrible idea that IDE should generate tables in db and so on. Maybe im old fashioned but i like when i can control EVERY thing, not to give control so plugins and don't even understand how they work :D With dapper you can see SQL query tweak it as you like. make complex queries. Easy. with EF i bet i will have to work HARD to make it do what i want :D
Thanks again.

from daarto.

mcshaz avatar mcshaz commented on July 29, 2024

@Tommixoft - If you do have the energy and want to help others trying to integrate dapper with MySQL, you could script the database schema that has been created for EF identity for MySql (as described at https://stackoverflow.com/questions/17190083/how-to-take-mysql-database-backup-using-mysql-workbench), and then upload the resultant sql to a git repo. Unlike EF, obviously Dapper is not SQL flavour agnostic, and so it is definitely possible that some of the SQL statements in the data access layer of this library do not work without modification.

from daarto.

Related Issues (19)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.