FreeSql is a powerful O/RM component, supports .NET Core 2.1+, .NET Framework 4.0+, Xamarin, And AOT.

English |中文

📚 Documentation

🚀 Quick start

staticIFreeSqlfsql=newFreeSql.FreeSqlBuilder().UseConnectionString(FreeSql.DataType.Sqlite,@"Data Source=document.db").UseAutoSyncStructure(true)//automatically synchronize the entity structure to the database.Build();//be sure to define as singleton modeclassSong{[Column(IsIdentity=true)]publicintId{get;set;}publicstringTitle{get;set;}publicstringUrl{get;set;}publicDateTimeCreateTime{get;set;}publicICollection<Tag>Tags{get;set;}}classSong_tag{publicintSong_id{get;set;}publicSongSong{get;set;}publicintTag_id{get;set;}publicTagTag{get;set;}}classTag{[Column(IsIdentity=true)]publicintId{get;set;}publicstringName{get;set;}publicint?Parent_id{get;set;}publicTagParent{get;set;}publicICollection<Song>Songs{get;set;}publicICollection<Tag>Tags{get;set;}}

🔎 Query

//OneToOne、ManyToOnefsql.Select<Tag>().Where(a=>a.Parent.Parent.Name=="English").ToList();//OneToManyfsql.Select<Tag>().IncludeMany(a=>a.Tags, then=>then.Where(sub=>sub.Name=="foo")).ToList();//ManyToManyfsql.Select<Song>().IncludeMany(a=>a.Tags, then=>then.Where(sub=>sub.Name=="foo")).Where(s=>s.Tags.Any(t=>t.Name=="Chinese")).ToList();//Otherfsql.Select<YourType>().Where(a=>a.IsDelete==0).WhereIf(keyword!=null, a=>a.UserName.Contains(keyword)).WhereIf(role_id>0, a=>a.RoleId==role_id).Where(a=>a.Nodes.Any(t=>t.Parent.Id==t.UserId)).Count(outvartotal).Page(page,size).OrderByDescending(a=>a.Id).ToList()

fsql.Select<Song>().Where(a=>new[]{1,2,3}.Contains(a.Id)).ToList();fsql.Select<Song>().Where(a=>a.CreateTime.Date==DateTime.Today).ToList();fsql.Select<Song>().OrderBy(a=>Guid.NewGuid()).Limit(10).ToList();fsql.Select<Song>().ToList(a=>new{a.Id,Tags=fsql.Select<Tag>().ToList(),SongTags=fsql.Select<SongTag>().Where(b=>b.TopicId==a.Id).ToList()});

🚁 Repository

[Transactional]publicvoidAdd(){varrepo=ioc.GetService<BaseRepository<Tag>>();repo.DbContextOptions.EnableCascadeSave=true;varitem=newTag{Name="testaddsublist",Tags=new[]{newTag{Name="sub1"},newTag{Name="sub2"}}};repo.Insert(item);}

💪 Performance

Elapsed: 00:00:00.6733199; Query Entity Counts: 131072; ORM: DapperElapsed: 00:00:00.4554230; Query Tuple Counts: 131072; ORM: DapperElapsed: 00:00:00.6846146; Query Dynamic Counts: 131072; ORM: DapperElapsed: 00:00:00.6818111; Query Entity Counts: 131072; ORM: FreeSql*Elapsed: 00:00:00.6060042; Query Tuple Counts: 131072; ORM: FreeSql*Elapsed: 00:00:00.4211323; Query ToList<Tuple> Counts: 131072; ORM: FreeSql*Elapsed: 00:00:01.0236285; Query Dynamic Counts: 131072; ORM: FreeSql*

Elapsed: 00:00:00.6707125; ToList Entity Counts: 131072; ORM: FreeSql*Elapsed: 00:00:00.6495301; Query Entity Counts: 131072; ORM: Dapper

👯 Contributors

💕 Donation

🗄 License