Densen.FreeSql.Extensions.BootstrapBlazor 8.6.0

There is a newer version of this package available.
See the version list below for details.
dotnet add package Densen.FreeSql.Extensions.BootstrapBlazor --version 8.6.0                
NuGet\Install-Package Densen.FreeSql.Extensions.BootstrapBlazor -Version 8.6.0                
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.6.0" />                
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.6.0                
#r "nuget: Densen.FreeSql.Extensions.BootstrapBlazor, 8.6.0"                
#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.6.0

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

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-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.7.1 93 7/7/2024
8.7.0 80 7/1/2024
8.6.0 89 6/5/2024
8.4.0 217 4/6/2024
8.3.4 121 3/9/2024
8.3.2 90 3/7/2024
8.3.1 104 2/26/2024
8.3.0 108 2/25/2024
8.2.3 108 2/12/2024
8.2.2 112 2/9/2024
8.2.1 86 2/9/2024
8.2.0 93 2/5/2024
8.1.13 92 1/31/2024
8.1.12 126 1/20/2024
8.1.11 86 1/19/2024
8.1.10 99 1/18/2024
8.1.8 229 1/15/2024
8.1.7 93 1/14/2024
8.1.6 91 1/12/2024
8.1.5 95 1/12/2024
8.1.4 121 1/8/2024
8.0.4 114 1/8/2024
8.0.3 107 1/8/2024
8.0.2 99 1/8/2024
8.0.1 130 1/4/2024
8.0.0 221 11/15/2023
7.10.4 319 9/3/2023
7.10.3 120 9/3/2023
7.10.2 124 9/3/2023
7.10.1 123 9/2/2023
7.8.0 190 7/15/2023
7.7.9 202 6/12/2023
7.7.8 195 6/7/2023
7.7.7 154 6/6/2023
7.7.5 153 6/3/2023
7.7.4-beta02 114 6/3/2023
7.7.3 134 6/3/2023
7.7.1 155 6/2/2023
7.7.0 149 6/2/2023
7.2.3 1,007 3/20/2023
7.2.2 359 3/20/2023
7.2.1 795 2/24/2023
7.2.0 272 2/23/2023
7.1.1 426 1/30/2023
7.1.0 343 1/14/2023
7.0.0 387 11/9/2022
6.8.0 684 8/3/2022
6.7.0 399 8/3/2022
6.5.0 618 4/30/2022
6.4.0 433 4/29/2022
6.3.2 475 3/23/2022
6.0.2 351 12/21/2021
6.0.0 281 12/20/2021
0.0.5 359 4/12/2021
0.0.4 347 2/4/2021