Densen.FreeSql.Extensions.BootstrapBlazor 8.3.4

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

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

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: 强制排序,但是手动排序优先
    • 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 = new List<string> {
            nameof(AspNetUserRoles.AspNetRoless) ,
        };
    
    
    }
    
    
  3. FreeSql.Cloud 多库操作服务 (AddFreeSqlCloud), 提供跨数据库访问

更新日志

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 net6.0 is compatible.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 is compatible.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  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. 
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 (1)

Showing the top 1 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 的应用。
Version Downloads Last updated
8.3.4 96 3/9/2024
8.3.2 75 3/7/2024
8.3.1 89 2/26/2024
8.3.0 84 2/25/2024
8.2.3 89 2/12/2024
8.2.2 95 2/9/2024
8.2.1 76 2/9/2024
8.2.0 84 2/5/2024
8.1.13 81 1/31/2024
8.1.12 111 1/20/2024
8.1.11 73 1/19/2024
8.1.10 85 1/18/2024
8.1.8 123 1/15/2024
8.1.7 81 1/14/2024
8.1.6 77 1/12/2024
8.1.5 82 1/12/2024
8.1.4 103 1/8/2024
8.0.4 103 1/8/2024
8.0.3 92 1/8/2024
8.0.2 89 1/8/2024
8.0.1 121 1/4/2024
8.0.0 207 11/15/2023
7.10.4 290 9/3/2023
7.10.3 114 9/3/2023
7.10.2 118 9/3/2023
7.10.1 117 9/2/2023
7.8.0 184 7/15/2023
7.7.9 192 6/12/2023
7.7.8 183 6/7/2023
7.7.7 142 6/6/2023
7.7.5 142 6/3/2023
7.7.4-beta02 106 6/3/2023
7.7.3 128 6/3/2023
7.7.1 143 6/2/2023
7.7.0 137 6/2/2023
7.2.3 878 3/20/2023
7.2.2 352 3/20/2023
7.2.1 695 2/24/2023
7.2.0 259 2/23/2023
7.1.1 411 1/30/2023
7.1.0 333 1/14/2023
7.0.0 384 11/9/2022
6.8.0 668 8/3/2022
6.7.0 396 8/3/2022
6.5.0 606 4/30/2022
6.4.0 430 4/29/2022
6.3.2 472 3/23/2022
6.0.2 342 12/21/2021
6.0.0 277 12/20/2021
0.0.5 352 4/12/2021
0.0.4 337 2/4/2021