Skip to content

Releases

The Sharp Factory 1.2.2.5

Choose a tag to compare

@github-actions github-actions released this 17 Nov 18:26

Fixes

  • A query before the connection string is registered says what to do. The generated code threw
    "KeyNotFoundException: The given key '1' was not present in the dictionary"; now it throws an
    InvalidOperationException: "No connection string is registered for the model with id 1. Call
    Database.RegisterModelConnectionString with that model's RepoLookup.ModelId and its connection string once, when
    the application starts, before the first query." Regenerate with Sync to get it.

Downloads

Download What
TheSharpFactory-win-x64.zip, TheSharpFactory-win-arm64.zip The app for Windows
TheSharpFactory-osx-arm64.zip, TheSharpFactory-osx-x64.zip The app for macOS (Apple silicon, Intel)
TheSharpFactory-linux-x64.tar.gz The app for Linux
sharpfactory-cli-* The command line, sharpfactory, for the same systems

The Sharp Factory 1.2.2.4

Choose a tag to compare

@github-actions github-actions released this 17 Nov 06:47

Fixes

  • Navigation properties two or more levels deep. These now load correctly in the generated code (regenerate with
    Sync to get the fix):

    • With First, FirstOrDefault, Single or Top, a query with a second level such as
      .Append(CustomerNavProperty.Orders).Then(OrderNavProperty.Lines) failed in SQL Server with "The ORDER BY clause
      is invalid in … subqueries".
    • With paging, the second level skipped rows (an order came back without its lines).

    Queries with one level, or without Top, First, Single or paging, send the same SQL as before.

Downloads

Download What
TheSharpFactory-win-x64.zip, TheSharpFactory-win-arm64.zip The app for Windows
TheSharpFactory-osx-arm64.zip, TheSharpFactory-osx-x64.zip The app for macOS (Apple silicon, Intel)
TheSharpFactory-linux-x64.tar.gz The app for Linux
sharpfactory-cli-* The command line, sharpfactory, for the same systems

The Sharp Factory 1.2.2.3

Choose a tag to compare

@github-actions github-actions released this 16 Nov 05:21

Changes

  • Microsoft.Data.SqlClient 7.1.2. The app, the command line and the Repository project Sync creates use
    Microsoft.Data.SqlClient 7.1.2 (was 7.1.1). Projects Sync created before keep the version they have: change it
    in the Repository project's file if you want the new one.

Downloads

Download What
TheSharpFactory-win-x64.zip, TheSharpFactory-win-arm64.zip The app for Windows
TheSharpFactory-osx-arm64.zip, TheSharpFactory-osx-x64.zip The app for macOS (Apple silicon, Intel)
TheSharpFactory-linux-x64.tar.gz The app for Linux
sharpfactory-cli-* The command line, sharpfactory, for the same systems

The Sharp Factory 1.2.2.2

Choose a tag to compare

@github-actions github-actions released this 16 Nov 03:21

What's new

  • Sync shows what it will change, by itself. There is no Preview button any more: as soon as a solution is
    chosen, the Sync page works out every file Sync would add, change or delete (writing nothing) and shows them with
    their differences. It works it out again when you update the model or change a layer or a setting. The button says
    how many files it will write ("Sync 165 files"), the Sync entry in the menu shows the same count, and after a Sync
    the page says when it ran and what it wrote, with a Save button when the model file has unsaved changes.
  • A round of UI polish. The generated code on the Models page gets most of the width; the object checkboxes in
    the New model wizard are drawn properly, and Create model waits for at least one object; disabled buttons and menu
    entries say why; release notes in the update question are laid out; secondary text is easier to read; skipped
    objects stand out in the logs, with a filter to show only them.

Downloads

Download What
TheSharpFactory-win-x64.zip, TheSharpFactory-win-arm64.zip The app for Windows
TheSharpFactory-osx-arm64.zip, TheSharpFactory-osx-x64.zip The app for macOS (Apple silicon, Intel)
TheSharpFactory-linux-x64.tar.gz The app for Linux
sharpfactory-cli-* The command line, sharpfactory, for the same systems

The Sharp Factory 1.2.2.1

Choose a tag to compare

@github-actions github-actions released this 16 Nov 02:00

Fixes

  • Dates after a day. The "date greater than" filter left out values at exactly midnight of the next day, and on a
    date column the whole next day. Sync your solutions to get the fix: only the SQL engine's DatabaseSelect.cs
    changes.
  • Slower servers can connect. The Add and Update wizards gave a server 2 seconds to answer; they now wait as long
    as the connection's timeout (15 seconds), so remote and cloud servers no longer show as unreachable.
  • Logging needs a logger. Turning on Database.LogEnabled in the generated code without setting
    Database.Logger first now throws right there, with a message that says so, instead of every query failing later.
    Sync to get it.
  • The master database is refused. A model whose database is master is not saved, and the Add wizard says so:
    master belongs to the server, and no code should be generated from it.
  • Values longer than their column are refused. A text or binary value longer than its column (or a function's
    parameter) was cut to fit without a word, so only part of it was saved, or a filter compared only part of it. The
    generated code now throws before anything is sent to the database, and names the property. Sync to get it.

Downloads

Download What
TheSharpFactory-win-x64.zip, TheSharpFactory-win-arm64.zip The app for Windows
TheSharpFactory-osx-arm64.zip, TheSharpFactory-osx-x64.zip The app for macOS (Apple silicon, Intel)
TheSharpFactory-linux-x64.tar.gz The app for Linux
sharpfactory-cli-* The command line, sharpfactory, for the same systems

The Sharp Factory 1.2.2.0

Choose a tag to compare

@github-actions github-actions released this 15 Nov 01:15

What's new

  • The code writer is its own library. The part that writes the C# files is now a separate project,
    SF.CSharpWriter, that takes text and knows nothing of your model; the generators write through it. The
    generated code is exactly the same, byte for byte, so there is nothing to Sync.

Downloads

| Download | What |
|

The Sharp Factory 1.2.1.9

Choose a tag to compare

@github-actions github-actions released this 14 Nov 19:23

Fixes

  • Code writer details. A static constructor is written with one space after static, and a block comment
    closes at its own indent. Nothing generated today uses either, so the generated code does not change.

Downloads

| Download | What |
|

The Sharp Factory 1.2.1.8

Choose a tag to compare

@github-actions github-actions released this 14 Nov 19:09

What's new

  • Code generation uses less than half the memory. Generating a large model (1,783 files) allocated 138 MB; it
    now allocates 64 MB. Every file was copied twice on its way to disk to make its line endings CRLF, although they
    already were; the code writer no longer builds a string for each line it writes; and it keeps the file in one
    buffer that it reuses without reallocating. On Linux and macOS the writer now ends lines with CRLF itself, so
    the files no longer need converting. The generated code is exactly the same, byte for byte, so there is nothing
    to Sync.

Downloads

| Download | What |
|

The Sharp Factory 1.2.1.7

Choose a tag to compare

@github-actions github-actions released this 14 Nov 17:26

What's new

  • Leaner code writer. The part of the app that writes the C# no longer builds a new string for every level of
    indentation or for the type names in doc comments. The generated code is exactly the same as in 1.2.1.6, byte
    for byte, so there is nothing to Sync.

Downloads

| Download | What |
|

The Sharp Factory 1.2.1.6

Choose a tag to compare

@github-actions github-actions released this 14 Nov 17:01

Fixes

  • Your own code in generic types. The header of BatchEntry<TEntity> and StoredProcResult<TResult> showed
    how to add your own code as public partial class BatchEntry, which declares a different class. It now shows
    public partial class BatchEntry<TEntity>.
  • Tidier generated code. Properties document their value with <value> (it was <returns>, which tooltips
    ignore on properties), fields no longer get a <returns> comment, and base types, type parameters and trailing
    comments are spaced (Base<A, B>, IThing, x = 0; // comment).

Sync your solutions to get it; the SQL does not change.

Downloads

| Download | What |
|