Comments (4)
@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.
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.
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.
@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)
- Unit of work implementation needed HOT 5
- UsersTable:GetUsersInRoleAsync - ApplicationUser.Id is Role.Id
- Adaptive for PostgreSQL
- Where I can get ApplicationRole & ApplicationUser? The example from README.md is obsolet?
- Missing parameter in UserTable.UpdateAsync
- Maybe we should be able to get a list with all users in it HOT 2
- UsersTable override doesn't work HOT 3
- String should be TKey in DapperStoreOptionsExtentions to use different ID type
- Database schema (dbo) is hardcoded
- Cannot override table names
- Getting List of Roles
- RemoveFromRoleAsyc Not working in UserStore
- Move IdentityResult return value to IdentityTable classes?
- Improve DB connection efficiency
- DapperStoreOptions creates unused SqlServerDbConnectionStore
- IdentityBuilderExtensions.AddStores ignores AddUsersTable option if implementation is UserOnlyStore
- How it's suppose to work if DB have no tables? HOT 1
- Upgrade to .NET Core 6.0 HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
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.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from daarto.