Densen.FreeSql.Extensions.BootstrapBlazor 9.1.2

dotnet add package Densen.FreeSql.Extensions.BootstrapBlazor --version 9.1.2                
NuGet\Install-Package Densen.FreeSql.Extensions.BootstrapBlazor -Version 9.1.2                
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="9.1.2" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Densen.FreeSql.Extensions.BootstrapBlazor --version 9.1.2                
#r "nuget: Densen.FreeSql.Extensions.BootstrapBlazor, 9.1.2"                
#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=9.1.2

// Install Densen.FreeSql.Extensions.BootstrapBlazor as a Cake Tool
#tool nuget:?package=Densen.FreeSql.Extensions.BootstrapBlazor&version=9.1.2                

BootstrapBlazor的FreeSql数据注入服务扩展包

  1. 注入服务

    //添加FreeSql服务
    builder.Services.AddFreeSql(option =>
    {
        option.UseConnectionString(FreeSql.DataType.Sqlite, "Data Source=demo.db;")
    #if DEBUG
             //开发环境:自动同步实体
             .UseAutoSyncStructure(true)
             .UseNoneCommandParameter(true)
            //调试sql语句输出
             .UseMonitorCommand(cmd => System.Console.WriteLine(cmd.CommandText + Environment.NewLine))
    #endif
        ;
    });
    
    //全功能版
    builder.Services.AddTransient(typeof(FreeSqlDataService<>));
    

    数据服务支持的方法:

    • IncludeByPropertyNames: 附加IncludeByPropertyName查询条件, 单项可逗号隔开附加查询条件的第二个参数 then,可以进行二次查询前的修饰工作. (暂时只支持一个then附加)
    • OrderByPropertyName: 强制排序,但是手动排序优先, ["len(CustomerID)", "CustomerID"]
    • LeftJoinString: 左联查询,使用原生sql语法
    • WhereCascade: 附加查询条件使用and结合
    • WhereCascadeOr: 附加查询条件使用or结合
    • WhereLamda: 查询条件,Where(a ⇒ a.Id > 10),支持导航对象查询
  2. TableAmePro 组件使用示例

    • 通过注入数据服务直接操作实体类的CRUD操作, 无需编写任何后端代码, 无需编写任何前端代码, 无需编写任何SQL语句
    • 增删改查, 导出Excel, 导出Word
    • 支持多表联查
    • 支持多库切换
    • 保存时级联保存, 默认 false
    • 自动保存当前页码, 默认 false
    • Excel模式切换
    • 虚拟滚动/分页模式切换
    <h4>用户表</h4>
    
    <TableAmePro TItem="AspNetUsers" ItemDetails="NullClass" ItemDetailsII="NullClass" ItemDetailsIII="NullClass" ShowColumnList />
    
    <TableAmePro TItem="AspNetUsers"
        IncludeByPropertyNames="@IncludeAspNetUsers"
        ItemDetails="AspNetUserRoles"
        SubIncludeByPropertyNames="@SubIncludeByPropertyNames"
        ItemDetailsII="NullClass"
        ItemDetailsIII="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 = [nameof(AspNetUserRoles.AspNetRoless)];
    
    
    }
    
    
  3. FreeSql.Cloud 多库操作服务 (AddFreeSqlCloud), 提供跨数据库访问

更新日志

2024-7-1

  • 添加 AfterQueryCallBackAsync 查询回调方法,用于附加获取地理位置之类

2024-2-9

  • 增加 FreeSql.Cloud 多库操作服务 (AddFreeSqlCloud), 提供跨数据库访问,分布式事务TCC、SAGA解决方案
  • TableAmePro 组件使用 ConnectionString 作为key,在服务里 fsql = fsqlCloud.Use(connectionString) 获取当前库的实例
  • FreeSql.Cloud

2024-2-5

  • 添加 SubIsSimpleUI 详表简化UI , IsReadonly 双击弹窗只读
  • 添加 SubIsReadonly 详表只读

2024-2-1

  • 添加 FooterContent

2024-1-18

  • 缓存当前编辑实体
  • 多主键实体,保存前先删除(利用缓存实体比对)
  • 去除内存排序和搜索功能, 业务层不封装

2024-1-12

  • 修复分页数量由大切小导致不刷新项目的错误
  • DataAcces.FreeSql 支持更多功能

2024-1-3

  • TableAmePro 添加主表只读 IsReadonly 属性, 详表组件工作模式为 Excel 模式SubIsExcel

2023-09-30

  • TableAmePro 添加参数 自动保存当前页码 AutoSavePageIndex, 当前页码 PageIndex

2023-6-3

  • 添加 ItemDetailsIII , 选项卡3, 附加查询条件III
Product Compatible and additional computed target framework versions.
.NET net8.0 is compatible.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed.  net9.0 is compatible. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

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 (2)

Showing the top 2 popular GitHub repositories that depend on Densen.FreeSql.Extensions.BootstrapBlazor:

Repository Stars
densen2014/BlazorMaui
用 c # 和 Razor 创建本机移动应用和桌面应用。使用 Blazor.BB.Maui,可以快速开发共享代码库运行于 Windows (Winforms/WPF/UWP)、Android、iOS、macOS 的应用。
densen2014/BlazorHybrid
关于BlazorHybrid的一切研究. 用 c # 和 Razor 创建本机移动应用和桌面应用。快速开发共享代码库运行于 Windows (Winforms/WPF/UWP)、Android、iOS、macOS、Linux 的应用。
Version Downloads Last updated
9.1.2 40 12/22/2024
9.0.1 48 12/22/2024
9.0.0 121 11/13/2024
8.10.5 131 10/16/2024
8.10.4 112 10/16/2024
8.7.5 125 7/30/2024
8.7.1 163 7/7/2024
8.7.0 107 7/1/2024
8.6.0 121 6/5/2024
8.4.0 368 4/6/2024
8.3.4 158 3/9/2024
8.3.2 123 3/7/2024
8.3.1 138 2/26/2024
8.3.0 142 2/25/2024
8.2.3 135 2/12/2024
8.2.2 145 2/9/2024
8.2.1 125 2/9/2024
8.2.0 135 2/5/2024
8.1.13 126 1/31/2024
8.1.12 155 1/20/2024
8.1.11 110 1/19/2024
8.1.10 146 1/18/2024
8.1.8 392 1/15/2024
8.1.7 127 1/14/2024
8.1.6 120 1/12/2024
8.1.5 134 1/12/2024
8.1.4 150 1/8/2024
8.0.4 149 1/8/2024
8.0.3 136 1/8/2024
8.0.2 122 1/8/2024
8.0.1 153 1/4/2024
8.0.0 249 11/15/2023
7.10.4 387 9/3/2023
7.10.3 156 9/3/2023 7.10.3 is deprecated because it has critical bugs.
7.10.2 163 9/3/2023 7.10.2 is deprecated because it has critical bugs.
7.10.1 168 9/2/2023
7.8.0 227 7/15/2023
7.7.9 248 6/12/2023
7.7.8 232 6/7/2023
7.7.7 184 6/6/2023
7.7.5 179 6/3/2023
7.7.4-beta02 150 6/3/2023
7.7.3 148 6/3/2023
7.7.1 170 6/2/2023
7.7.0 178 6/2/2023
7.2.3 1,202 3/20/2023
7.2.2 396 3/20/2023
7.2.1 960 2/24/2023
7.2.0 301 2/23/2023
7.1.1 451 1/30/2023
7.1.0 359 1/14/2023
7.0.0 410 11/9/2022
6.8.0 704 8/3/2022
6.7.0 435 8/3/2022
6.5.0 650 4/30/2022
6.4.0 468 4/29/2022
6.3.2 512 3/23/2022
6.0.2 378 12/21/2021
6.0.0 318 12/20/2021
0.0.5 398 4/12/2021
0.0.4 377 2/4/2021