Densen.FreeSql.Extensions.BootstrapBlazor
7.2.3
.NET 6.0
dotnet add package Densen.FreeSql.Extensions.BootstrapBlazor --version 7.2.3
NuGet\Install-Package Densen.FreeSql.Extensions.BootstrapBlazor -Version 7.2.3
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Densen.FreeSql.Extensions.BootstrapBlazor" Version="7.2.3" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Densen.FreeSql.Extensions.BootstrapBlazor --version 7.2.3
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Densen.FreeSql.Extensions.BootstrapBlazor, 7.2.3"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install Densen.FreeSql.Extensions.BootstrapBlazor as a Cake Addin
#addin nuget:?package=Densen.FreeSql.Extensions.BootstrapBlazor&version=7.2.3
// Install Densen.FreeSql.Extensions.BootstrapBlazor as a Cake Tool
#tool nuget:?package=Densen.FreeSql.Extensions.BootstrapBlazor&version=7.2.3
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
BootstrapBlazor的FreeSql数据注入服务扩展包
- 注入服务
//添加FreeSql服务
builder.Services.AddFreeSql(option =>
{
option.UseConnectionString(FreeSql.DataType.Sqlite, builder.Configuration.GetConnectionString("IdsSQliteConnection")) //也可以写到配置文件中
#if DEBUG
//开发环境:自动同步实体
.UseAutoSyncStructure(true)
.UseNoneCommandParameter(true)
//调试sql语句输出
.UseMonitorCommand(cmd => System.Console.WriteLine(cmd.CommandText + Environment.NewLine))
#endif
;
})
//全功能版
builder.Services.AddSingleton(typeof(FreeSqlDataService<>));
- FreeSql ORM 的 IDataService 数据注入服务接口实现
/// <summary>
/// 查询方法
/// </summary>
/// <param name="option"></param>
/// <returns></returns>
public override Task<QueryData<TModel>> QueryAsync(QueryPageOptions option)
/// <summary>
/// 查询方法
/// </summary>
/// <param name="option"></param>
/// <param name="WhereCascade">附加查询条件使用and结合</param>
/// <param name="IncludeByPropertyNames">附加IncludeByPropertyName查询条件, 单项可逗号隔开附加查询条件的第二个参数 then,可以进行二次查询前的修饰工作. (暂时只支持一个then附加)</param>
/// <param name="LeftJoinString">左联查询,使用原生sql语法,LeftJoin("type b on b.id = a.id")</param>
/// <param name="OrderByPropertyName">强制排序,但是手动排序优先</param>
/// <param name="WhereCascadeOr">附加查询条件使用or结合</param>
/// <param name="WhereLamda">查询条件,Where(a => a.Id > 10),支持导航对象查询,Where(a => a.Author.Email == "2881099@qq.com")</param>
/// <returns></returns>
public Task<QueryData<TModel>> QueryAsyncWithWhereCascade(
QueryPageOptions option,
DynamicFilterInfo? WhereCascade = null,
List<string>? IncludeByPropertyNames = null,
string? LeftJoinString = null,
List<string>? OrderByPropertyName = null,
List<string>? WhereCascadeOr = null,
Expression<Func<TModel, bool>>? WhereLamda = null)
/// <summary>
/// 全部记录
/// </summary>
/// <param name="WhereCascade">附加查询条件使用and结合</param>
/// <param name="IncludeByPropertyNames">附加IncludeByPropertyName查询条件, 单项可逗号隔开附加查询条件的第二个参数 then,可以进行二次查询前的修饰工作. (暂时只支持一个then附加)</param>
/// <param name="LeftJoinString">左联查询,使用原生sql语法,LeftJoin("type b on b.id = a.id")</param>
/// <param name="OrderByPropertyName">强制排序,但是手动排序优先</param>
/// <param name="WhereCascadeOr">附加查询条件使用or结合</param>
/// <param name="WhereLamda">查询条件,Where(a => a.Id > 10),支持导航对象查询,Where(a => a.Author.Email == "2881099@qq.com")</param>
/// <returns></returns>
public List<TModel>? GetAllItems(
DynamicFilterInfo? WhereCascade = null,
List<string>? IncludeByPropertyNames = null,
string? LeftJoinString = null,
List<string>? OrderByPropertyName = null,
List<string>? WhereCascadeOr = null,
Expression<Func<TModel, bool>>? WhereLamda = null)
- FreeSql ORM 查询工具类
FsqlUtil
/// <summary>
/// 执行查询
/// </summary>
/// <param name="options">查询条件</param>
/// <param name="optionsLast">缓存查询条件</param>
/// <param name="TotalCount"></param>
/// <param name="fsql"></param>
/// <param name="WhereCascade">附加查询条件使用and结合</param>
/// <param name="IncludeByPropertyNames">附加IncludeByPropertyName查询条件.<para></para>
/// 其中单项可逗号隔开附加查询条件的第二个参数 then,可以进行二次查询前的修饰工作. <para></para>
/// 单项第二个逗号隔开可第三层then附加</param>
/// <param name="LeftJoinString">左联查询,使用原生sql语法,LeftJoin("type b on b.id = a.id")</param>
/// <param name="OrderByPropertyName">强制排序,但是手动排序优先</param>
/// <param name="WhereCascadeOr">附加查询条件使用or结合</param>
/// <param name="forceAllItems">附加查询条件使用or结合</param>
/// <param name="WhereLamda">查询条件,Where(a => a.Id > 10),支持导航对象查询,Where(a => a.Author.Email == "2881099@qq.com")</param>
public static QueryData<TModel> Fetch<TModel>(
QueryPageOptions options,
QueryPageOptions? optionsLast,
long? TotalCount,
IFreeSql fsql,
DynamicFilterInfo? WhereCascade = null,
List<string>? IncludeByPropertyNames = null,
string? LeftJoinString = null,
List<string>? OrderByPropertyName = null,
List<string>? WhereCascadeOr = null,
bool forceAllItems = false,
Expression<Func<TModel, bool>>? WhereLamda = null) where TModel : class, new()
- TablePollo 组件
<h4>用户表</h4>
<TablePollo TItem="AspNetUsers" ItemDetails="NullClass" ItemDetailsII="NullClass" ShowColumnList />
<TablePollo TItem="AspNetUsers"
IncludeByPropertyNames="@IncludeAspNetUsers"
ItemDetails="AspNetUserRoles"
SubIncludeByPropertyNames="@SubIncludeByPropertyNames"
ItemDetailsII="NullClass"
ShowColumnList
ShowExportButton
ShowDetailRowS
Field="@nameof(AspNetUsers.Id)"
FieldD="@nameof(AspNetUserRoles.UserId)"
ExportToStream="false"
ExportBasePath="temp"/>
@code{
//通过 UserId 联表读取角色表 AspNetUserRoles 指定用户数据, 但是AspNetUsers表主键是 Id 字段, 详表指定 FieldD="UserId"
//附加导航IncludeByPropertyName查询条件
List<string> IncludeAspNetUsers
{
get => new List<string> {
$"{nameof(AspNetUsers.AspNetUserRoless)},{nameof(AspNetUserRoles.AspNetRoless)}" ,
};
}
List<string> SubIncludeByPropertyNames = new List<string> {
nameof(AspNetUserRoles.AspNetRoless) ,
};
}
Product | Versions |
---|---|
.NET | net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows net7.0 net7.0-android net7.0-ios net7.0-maccatalyst net7.0-macos net7.0-tvos net7.0-windows |
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.
-
net6.0
- BootstrapBlazor.Table.ImportExportsService (>= 7.2.3)
- Densen.Extensions.BootstrapBlazor (>= 7.3.1)
- FreeSql.Extensions.JsonMap (>= 3.2.692)
- FreeSql.Repository (>= 3.2.692)
- Newtonsoft.Json (>= 13.0.3)
-
net7.0
- BootstrapBlazor.Table.ImportExportsService (>= 7.2.3)
- Densen.Extensions.BootstrapBlazor (>= 7.3.1)
- FreeSql.Extensions.JsonMap (>= 3.2.692)
- FreeSql.Repository (>= 3.2.692)
- Newtonsoft.Json (>= 13.0.3)
NuGet packages (1)
Showing the top 1 NuGet packages that depend on Densen.FreeSql.Extensions.BootstrapBlazor:
Package | Downloads |
---|---|
BootstrapBlazor.Table.Freesql
BootstrapBlazor 的 Table 扩展 |
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
7.2.3 | 57 | 3/20/2023 |
7.2.2 | 63 | 3/20/2023 |
7.2.1 | 203 | 2/24/2023 |
7.2.0 | 97 | 2/23/2023 |
7.1.1 | 198 | 1/30/2023 |
7.1.0 | 169 | 1/14/2023 |
7.0.0 | 251 | 11/9/2022 |
6.8.0 | 504 | 8/3/2022 |
6.7.0 | 271 | 8/3/2022 |
6.5.0 | 460 | 4/30/2022 |
6.4.0 | 290 | 4/29/2022 |
6.3.2 | 352 | 3/23/2022 |
6.0.2 | 231 | 12/21/2021 |
6.0.0 | 189 | 12/20/2021 |
0.0.5 | 250 | 4/12/2021 |
0.0.4 | 232 | 2/4/2021 |