文件列表:

LICENSE (1058, 2017-10-27)
src (0, 2017-10-27)
src\DotNet (0, 2017-10-27)
src\DotNet\Chloe.Extension (0, 2017-10-27)
src\DotNet\Chloe.Extension\Chloe.Extension.bat (45, 2017-10-27)
src\DotNet\Chloe.Extension\Chloe.Extension.csproj (2922, 2017-10-27)
src\DotNet\Chloe.Extension\Chloe.Extension.nuspec (915, 2017-10-27)
src\DotNet\Chloe.Extension\DbActionBag.cs (2940, 2017-10-27)
src\DotNet\Chloe.Extension\DbContextAsyncExtension.cs (2455, 2017-10-27)
src\DotNet\Chloe.Extension\DbContextExtension.cs (4400, 2017-10-27)
src\DotNet\Chloe.Extension\DbHelper.cs (1130, 2017-10-27)
src\DotNet\Chloe.Extension\DbSessionExtension.cs (7396, 2017-10-27)
src\DotNet\Chloe.Extension\IgnoreFieldsResolver.cs (1612, 2017-10-27)
src\DotNet\Chloe.Extension\ParameterTwoExpressionReplacer.cs (1738, 2017-10-27)
src\DotNet\Chloe.Extension\Properties (0, 2017-10-27)
src\DotNet\Chloe.Extension\Properties\AssemblyInfo.cs (1266, 2017-10-27)
src\DotNet\Chloe.Extension\QueryAsyncExtension.cs (5617, 2017-10-27)
src\DotNet\Chloe.Extension\QueryExtension.cs (14847, 2017-10-27)
src\DotNet\Chloe.Extension\Utils.cs (2460, 2017-10-27)
src\DotNet\Chloe.MySql (0, 2017-10-27)
src\DotNet\Chloe.MySql\Chloe.MySql.bat (41, 2017-10-27)
src\DotNet\Chloe.MySql\Chloe.MySql.csproj (3223, 2017-10-27)
src\DotNet\Chloe.MySql\Chloe.MySql.nuspec (1002, 2017-10-27)
src\DotNet\Chloe.MySql\ChloeMySqlCommand.cs (3016, 2017-10-27)
src\DotNet\Chloe.MySql\ChloeMySqlConnection.cs (1858, 2017-10-27)
src\DotNet\Chloe.MySql\ChloeMySqlDataReader.cs (4907, 2017-10-27)
src\DotNet\Chloe.MySql\DbContextServiceProvider.cs (774, 2017-10-27)
src\DotNet\Chloe.MySql\DbExpressionHelper.cs (2747, 2017-10-27)
src\DotNet\Chloe.MySql\DbExpressionTranslator.cs (730, 2017-10-27)
src\DotNet\Chloe.MySql\DbParamCollection.cs (2821, 2017-10-27)
src\DotNet\Chloe.MySql\ISqlBuilder.cs (1894, 2017-10-27)
src\DotNet\Chloe.MySql\MySqlContext.cs (6633, 2017-10-27)
src\DotNet\Chloe.MySql\Properties (0, 2017-10-27)
src\DotNet\Chloe.MySql\Properties\AssemblyInfo.cs (1256, 2017-10-27)
src\DotNet\Chloe.MySql\SqlGenerator.cs (28192, 2017-10-27)
src\DotNet\Chloe.MySql\SqlGenerator_AggregateHandlers.cs (2071, 2017-10-27)
... ...

# Chloe Chloe is a lightweight Object/Relational Mapping(ORM) library. The query interface is similar to LINQ.You can query data like LINQ and do any things(Join Query | Group Query | Aggregate Query | Insert | Batch Update | Batch Delete) by lambda with Chloe.ORM. **Documentation**: [http://www.52chloe.com/Wiki/Document](http://www.52chloe.com/Wiki/Document "http://www.52chloe.com/Wiki/Document") .NET交流群:325936847,只要您**愿意**,即可加入 **Source code of 'www.52chloe.com'**: [https://github.com/shuxinqin/Ace](https://github.com/shuxinqin/Ace "https://github.com/shuxinqin/Ace") # NuGet Install Command | | .NET Framework | .NET Core | | ------------ | --------------- | ---------- | | SqlServer | Install-Package Chloe.SqlServer | Install-Package ChloeCore.SqlServer | | MySql | Install-Package Chloe.MySql | Install-Package ChloeCore.MySql | | Oracle | Install-Package Chloe.Oracle | - | | SQLite | Install-Package Chloe.SQLite | Install-Package ChloeCore.SQLite | # Usage * **Entity** ```C# public enum Gender { Man = 1, Woman } [Table("Users")] public class User { [Column(IsPrimaryKey = true)] [AutoIncrement] public int Id { get; set; } public string Name { get; set; } public Gender? Gender { get; set; } public int? Age { get; set; } public int? CityId { get; set; } public DateTime? OpTime { get; set; } } public class City { [Column(IsPrimaryKey = true)] public int Id { get; set; } public string Name { get; set; } public int ProvinceId { get; set; } } public class Province { [Column(IsPrimaryKey = true)] public int Id { get; set; } public string Name { get; set; } } ``` * **DbContext** ```C# IDbContext context = new MsSqlContext(DbHelper.ConnectionString); IQuery q = context.Query(); ``` * **Query** ```C# IQuery q = context.Query(); q.Where(a => a.Id > 0).FirstOrDefault(); q.Where(a => a.Id > 0).ToList(); q.Where(a => a.Id > 0).OrderBy(a => a.Age).ToList(); q.Where(a => a.Id > 0).Take(10).OrderBy(a => a.Age).ToList(); q.Where(a => a.Id > 0).OrderBy(a => a.Age).ThenByDesc(a => a.Id).Select(a => new { a.Id, a.Name }).Skip(20).Take(10).ToList(); /* * SELECT TOP (10) [T].[Id] AS [Id],[T].[Name] AS [Name] FROM (SELECT [Users].[Id] AS [Id],[Users].[Name] AS [Name],ROW_NUMBER() OVER(ORDER BY [Users].[Age] ASC,[Users].[Id] DESC) AS [ROW_NUMBER_0] FROM [Users] AS [Users] WHERE [Users].[Id] > 0) AS [T] WHERE [T].[ROW_NUMBER_0] > 20 */ q.Where(a => a.Id > 0).Where(a => a.Name.Contains("lu")).ToList(); /* * SELECT [Users].[Id] AS [Id],[Users].[Name] AS [Name],[Users].[Gender] AS [Gender],[Users].[Age] AS [Age],[Users].[CityId] AS [CityId],[Users].[OpTime] AS [OpTime] * FROM [Users] AS [Users] * WHERE ([Users].[Id] > 0 AND [Users].[Name] LIKE '%' + N'lu' + '%') */ ``` * **Join Query** ```C# MsSqlContext context = new MsSqlContext(DbHelper.ConnectionString); var user_city_province = context.Query() .InnerJoin((user, city) => user.CityId == city.Id) .InnerJoin((user, city, province) => city.ProvinceId == province.Id); user_city_province.Select((user, city, province) => new { UserId = user.Id, CityName = city.Name, ProvinceName = province.Name }).Where(a => a.UserId == 1).ToList(); /* * SELECT [Users].[Id] AS [UserId],[City].[Name] AS [CityName],[Province].[Name] AS [ProvinceName] * FROM [Users] AS [Users] * INNER JOIN [City] AS [City] ON [Users].[CityId] = [City].[Id] * INNER JOIN [Province] AS [Province] ON [City].[ProvinceId] = [Province].[Id] * WHERE [Users].[Id] = 1 */ var view = user_city_province.Select((user, city, province) => new { User = user, City = city, Province = province }); view.Where(a => a.User.Id == 1).ToList(); /* * SELECT [Users].[Id] AS [Id],[Users].[Name] AS [Name],[Users].[Gender] AS [Gender],[Users].[Age] AS [Age],[Users].[CityId] AS [CityId],[Users].[OpTime] AS [OpTime],[City].[Id] AS [Id0],[City].[Name] AS [Name0],[City].[ProvinceId] AS [ProvinceId],[Province].[Id] AS [Id1],[Province].[Name] AS [Name1] * FROM [Users] AS [Users] * INNER JOIN [City] AS [City] ON [Users].[CityId] = [City].[Id] * INNER JOIN [Province] AS [Province] ON [City].[ProvinceId] = [Province].[Id] * WHERE [Users].[Id] = 1 */ view.Where(a => a.User.Id == 1).Select(a => new { UserId = a.User.Id, CityName = a.City.Name, ProvinceName = a.Province.Name }).ToList(); /* * SELECT [Users].[Id] AS [UserId],[City].[Name] AS [CityName],[Province].[Name] AS [ProvinceName] * FROM [Users] AS [Users] * INNER JOIN [City] AS [City] ON [Users].[CityId] = [City].[Id] * INNER JOIN [Province] AS [Province] ON [City].[ProvinceId] = [Province].[Id] * WHERE [Users].[Id] = 1 */ /* * Chloe also supports left join,right join and full join query. * For details please see 'https://github.com/shuxinqin/Chloe/blob/master/src/DotNet/Chloe/IQuery%60.cs'. */ ``` * **Group Query** ```C# IQuery q = context.Query(); IGroupingQuery g = q.Where(a => a.Id > 0).GroupBy(a => a.Age); g = g.Having(a => a.Age > 1 && AggregateFunctions.Count() > 0); g.Select(a => new { a.Age, Count = AggregateFunctions.Count(), Sum = AggregateFunctions.Sum(a.Age), Max = AggregateFunctions.Max(a.Age), Min = AggregateFunctions.Min(a.Age), Avg = AggregateFunctions.Average(a.Age) }).ToList(); /* * SELECT [Users].[Age] AS [Age],COUNT(1) AS [Count],SUM([Users].[Age]) AS [Sum],MAX([Users].[Age]) AS [Max],MIN([Users].[Age]) AS [Min],CAST(AVG([Users].[Age]) AS FLOAT) AS [Avg] * FROM [Users] AS [Users] * WHERE [Users].[Id] > 0 * GROUP BY [Users].[Age] HAVING ([Users].[Age] > 1 AND COUNT(1) > 0) */ ``` * **Sql Query** ```C# context.SqlQuery("select Id,Name,Age from Users where Name=@name", DbParam.Create("@name", "lu")).ToList(); context.SqlQuery("select Id from Users").ToList(); ``` * **Aggregate Query** ```C# IQuery q = context.Query(); q.Select(a => AggregateFunctions.Count()).First(); /* * SELECT TOP (1) COUNT(1) AS [C] FROM [Users] AS [Users] */ q.Select(a => new { Count = AggregateFunctions.Count(), LongCount = AggregateFunctions.LongCount(), Sum = AggregateFunctions.Sum(a.Age), Max = AggregateFunctions.Max(a.Age), Min = AggregateFunctions.Min(a.Age), Average = AggregateFunctions.Average(a.Age) }).First(); /* * SELECT TOP (1) COUNT(1) AS [Count],COUNT_BIG(1) AS [LongCount],SUM([Users].[Age]) AS [Sum],MAX([Users].[Age]) AS [Max],MIN([Users].[Age]) AS [Min],CAST(AVG([Users].[Age]) AS FLOAT) AS [Average] * FROM [Users] AS [Users] */ var count = q.Count(); /* * SELECT COUNT(1) AS [C] FROM [Users] AS [Users] */ var longCount = q.LongCount(); /* * SELECT COUNT_BIG(1) AS [C] FROM [Users] AS [Users] */ var sum = q.Sum(a => a.Age); /* * SELECT SUM([Users].[Age]) AS [C] FROM [Users] AS [Users] */ var max = q.Max(a => a.Age); /* * SELECT MAX([Users].[Age]) AS [C] FROM [Users] AS [Users] */ var min = q.Min(a => a.Age); /* * SELECT MIN([Users].[Age]) AS [C] FROM [Users] AS [Users] */ var avg = q.Average(a => a.Age); /* * SELECT CAST(AVG([Users].[Age]) AS FLOAT) AS [C] FROM [Users] AS [Users] */ ``` * **Method** ```C# IQuery q = context.Query(); var space = new char[] { ' ' }; DateTime startTime = DateTime.Now; DateTime endTime = DateTime.Now.AddDays(1); q.Select(a => new { Id = a.Id, String_Length = (int?)a.Name.Length,//LEN([Users].[Name]) Substring = a.Name.Substring(0),//SUBSTRING([Users].[Name],0 + 1,LEN([Users].[Name])) Substring1 = a.Name.Substring(1),//SUBSTRING([Users].[Name],1 + 1,LEN([Users].[Name])) Substring1_2 = a.Name.Substring(1, 2),//SUBSTRING([Users].[Name],1 + 1,2) ToLower = a.Name.ToLower(),//LOWER([Users].[Name]) ToUpper = a.Name.ToUpper(),//UPPER([Users].[Name]) IsNullOrEmpty = string.IsNullOrEmpty(a.Name),//too long Contains = (bool?)a.Name.Contains("s"),// Trim = a.Name.Trim(),//RTRIM(LTRIM([Users].[Name])) TrimStart = a.Name.TrimStart(space),//LTRIM([Users].[Name]) TrimEnd = a.Name.TrimEnd(space),//RTRIM([Users].[Name]) StartsWith = (bool?)a.Name.StartsWith("s"),// EndsWith = (bool?)a.Name.EndsWith("s"),// DiffYears = DbFunctions.DiffYears(startTime, endTime),//DATEDIFF(YEAR,@P_0,@P_1) DiffMonths = DbFunctions.DiffMonths(startTime, endTime),//DATEDIFF(MONTH,@P_0,@P_1) DiffDays = DbFunctions.DiffDays(startTime, endTime),//DATEDIFF(DAY,@P_0,@P_1) DiffHours = DbFunctions.DiffHours(startTime, endTime),//DATEDIFF(HOUR,@P_0,@P_1) DiffMinutes = DbFunctions.DiffMinutes(startTime, endTime),//DATEDIFF(MINUTE,@P_0,@P_1) DiffSeconds = DbFunctions.DiffSeconds(startTime, endTime),//DATEDIFF(SECOND,@P_0,@P_1) DiffMilliseconds = DbFunctions.DiffMilliseconds(startTime, endTime),//DATEDIFF(MILLISECOND,@P_0,@P_1) //DiffMicroseconds = DbFunctions.DiffMicroseconds(startTime, endTime),//DATEDIFF(MICROSECOND,@P_0,@P_1) Exception AddYears = startTime.AddYears(1),//DATEADD(YEAR,1,@P_0) AddMonths = startTime.AddMonths(1),//DATEADD(MONTH,1,@P_0) AddDays = startTime.AddDays(1),//DATEADD(DAY,1,@P_0) AddHours = startTime.AddHours(1),//DATEADD(HOUR,1,@P_0) AddMinutes = startTime.AddMinutes(2),//DATEADD(MINUTE,2,@P_0) AddSeconds = startTime.AddSeconds(120),//DATEADD(SECOND,120,@P_0) AddMilliseconds = startTime.AddMilliseconds(20000),//DATEADD(MILLISECOND,20000,@P_0) Now = DateTime.Now,//GETDATE() UtcNow = DateTime.UtcNow,//GETUTCDATE() Today = DateTime.Today,//CAST(GETDATE() AS DATE) Date = DateTime.Now.Date,//CAST(GETDATE() AS DATE) Year = DateTime.Now.Year,//DATEPART(YEAR,GETDATE()) Month = DateTime.Now.Month,//DATEPART(MONTH,GETDATE()) Day = DateTime.Now.Day,//DATEPART(DAY,GETDATE()) Hour = DateTime.Now.Hour,//DATEPART(HOUR,GETDATE()) Minute = DateTime.Now.Minute,//DATEPART(MINUTE,GETDATE()) Second = DateTime.Now.Second,//DATEPART(SECOND,GETDATE()) Millisecond = DateTime.Now.Millisecond,//DATEPART(MILLISECOND,GETDATE()) DayOfWeek = DateTime.Now.DayOfWeek,//(DATEPART(WEEKDAY,GETDATE()) - 1) Int_Parse = int.Parse("1"),//CAST(N'1' AS INT) Int16_Parse = Int16.Parse("11"),//CAST(N'11' AS SMALLINT) Long_Parse = long.Parse("2"),//CAST(N'2' AS BIGINT) Double_Parse = double.Parse("3"),//CAST(N'3' AS FLOAT) Float_Parse = float.Parse("4"),//CAST(N'4' AS REAL) //Decimal_Parse = decimal.Parse("5"),//CAST(N'5' AS DECIMAL) ps: 'Decimal.Parse(string s)' is not supported now,because we don't know the precision and scale information. Guid_Parse = Guid.Parse("D544BC4C-739E-4CD3-A3D3-7BF803FCE179"),//CAST(N'D544BC4C-739E-4CD3-A3D3-7BF803FCE179' AS UNIQUEIDENTIFIER) AS [Guid_Parse] Bool_Parse = bool.Parse("1"),//CASE WHEN CAST(N'1' AS BIT) = CAST(1 AS BIT) THEN CAST(1 AS BIT) WHEN NOT (CAST(N'1' AS BIT) = CAST(1 AS BIT)) THEN CAST(0 AS BIT) ELSE NULL END AS [Bool_Parse] DateTime_Parse = DateTime.Parse("1992-1-16"),//CAST(N'1992-1-16' AS DATETIME) AS [DateTime_Parse] B = a.Age == null ? false : a.Age > 1, }).ToList(); ``` * **Insert** ```C# IDbContext context = new MsSqlContext(DbHelper.ConnectionString); //return the key value int id = (int)context.Insert(() => new User() { Name = "lu", Age = 18, Gender = Gender.Man, CityId = 1, OpTime = DateTime.Now }); /* * INSERT INTO [Users]([Name],[Age],[Gender],[CityId],[OpTime]) VALUES(N'lu',18,1,1,GETDATE());SELECT @@IDENTITY */ User user = new User(); user.Name = "lu"; user.Age = 18; user.Gender = Gender.Man; user.CityId = 1; user.OpTime = new DateTime(1992, 1, 16); user = context.Insert(user); /* * String @P_0 = "lu"; Gender @P_1 = Man; Int32 @P_2 = 18; Int32 @P_3 = 1; DateTime @P_4 = "1992/1/16 0:00:00"; INSERT INTO [Users]([Name],[Gender],[Age],[CityId],[OpTime]) VALUES(@P_0,@P_1,@P_2,@P_3,@P_4);SELECT @@IDENTITY */ ``` * **Update** ```C# MsSqlContext context = new MsSqlContext(DbHelper.ConnectionString); context.Update(a => a.Id == 1, a => new User() { Name = a.Name, Age = a.Age + 1, Gender = Gender.Man, OpTime = DateTime.Now }); /* * UPDATE [Users] SET [Name]=[Users].[Name],[Age]=([Users].[Age] + 1),[Gender]=1,[OpTime]=GETDATE() WHERE [Users].[Id] = 1 */ context.Update(a => a.Gender == Gender.Woman, a => new User() { Age = a.Age - 1, OpTime = DateTime.Now }); /* * UPDATE [Users] SET [Age]=([Users].[Age] - 1),[OpTime]=GETDATE() WHERE [Users].[Gender] = 2 */ User user = new User(); user.Id = 1; user.Name = "lu"; user.Age = 28; user.Gender = Gender.Man; user.OpTime = DateTime.Now; context.Update(user); //update all columns /* * String @P_0 = "lu"; Gender @P_1 = Man; Int32 @P_2 = 28; Nullable @P_3 = NULL; DateTime @P_4 = "2016/7/8 11:28:27"; Int32 @P_5 = 1; UPDATE [Users] SET [Name]=@P_0,[Gender]=@P_1,[Age]=@P_2,[CityId]=@P_3,[OpTime]=@P_4 WHERE [Users].[Id] = @P_5 */ context.TrackEntity(user);//track entity user.Name = user.Name + "1"; context.Update(user);//update the column 'Name' only /* * String @P_0 = "lu1"; Int32 @P_1 = 1; UPDATE [Users] SET [Name]=@P_0 WHERE [Users].[Id] = @P_1 */ ``` * **Delete** ```C# MsSqlContext context = new MsSqlContext(DbHelper.ConnectionString); context.Delete(a => a.Id == 1); /* * DELETE [Users] WHERE [Users].[Id] = 1 */ context.Delete(a => a.Gender == null); /* * DELETE [Users] WHERE [Users].[Gender] IS NULL */ User user = new User(); user.Id = 1; context.Delete(user); /* * Int32 @P_0 = 1; DELETE [Users] WHERE [Users].[Id] = @P_0 */ ``` # License [MIT](http://opensource.org/licenses/MIT) License note:早期使用 apache 2.0 开源协议,从 2017-3-3 起切换至更宽松的 MIT 协议

近期下载者：

相关文件：

评论：[我要评论] [举报此文件]

收藏者：