SqlSharp 1.0.1

Generate SqlQuery for your type/object dynamically.

There is a newer version of this package available.
See the version list below for details.
Install-Package SqlSharp -Version 1.0.1
dotnet add package SqlSharp --version 1.0.1
<PackageReference Include="SqlSharp" Version="1.0.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add SqlSharp --version 1.0.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Example:

using Microsoft.VisualStudio.TestTools.UnitTesting;
using SqlSharp.Query;

namespace SqlSharp.UatTests
{
[TestClass]
public class HelperTests
{
[TestMethod]
public void Select_Test()
{

        SharpQuery select = SharpQuery.Select()
            .Field("AccountId").As("Id")
            .Where("account.created", Compare.GreaterThanEqual, "01/01/2018")
            .TopN(100)
            .From("account");


        var data = QueryHelper.GetSqlOutput(select);

        Assert.IsNotNull(data);

    }
}

}

Example:

using Microsoft.VisualStudio.TestTools.UnitTesting;
using SqlSharp.Query;

namespace SqlSharp.UatTests
{
[TestClass]
public class HelperTests
{
[TestMethod]
public void Select_Test()
{

        SharpQuery select = SharpQuery.Select()
            .Field("AccountId").As("Id")
            .Where("account.created", Compare.GreaterThanEqual, "01/01/2018")
            .TopN(100)
            .From("account");


        var data = QueryHelper.GetSqlOutput(select);

        Assert.IsNotNull(data);

    }
}

}

Dependencies

This package has no dependencies.

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
1.0.3 313 5/14/2018
1.0.2 285 5/14/2018
1.0.1 254 5/14/2018
1.0.0 277 5/10/2018