Giter Club home page Giter Club logo

sqlclient-parsetoobject's Introduction

Build Status Quality Gate Status NuGet Downloads NuGet Version

SqlClient.ParseToObject

Get a full object (with nested complex objects) from Microsoft.Data.SqlClient. Created with .NET Core support;

Install via NuGet

PM> Install-Package SqlClient.ParseToObject

How to use

Optional Packages (to run next code):

Install-Package Dapper 

Demo Models:

public class UserModel
{
	public string Id { get; set; }

	public string Name { get; set; }

	public int Weight { get; set; }

	public DateTime Birthdate{ get; set; }

	public AddressModel Address { get; set; }
}

public class AddressModel
{
	public string Line1 { get; set; }

	public string Line2 { get; set; }

	public string City { get; set; }
}

Code:


var query = @"SELECT 
				U.Cod AS Id,
				Name,
				Birthdate,
				Weight,
				A.Line1 as [Address.Line1],
				A.Line2 as [Address.Line2],
				A.City as [Address.City]
			  FROM User U INNER JOIN Address A ON U.AddressCod = A.Cod
			  WHERE Name = @Name";

var parameters = new 
{
	Name = "Thiago Barradas"
};

using (var sqlConnection = new SqlConnection(connectionString))
{
    var reader = sqlConnection.ExecuteReader(query, parameters);

    List<User> users = reader.GetResults<User>();
}

How can I contribute?

Please, refer to CONTRIBUTING

Found something strange or need a new feature?

Open a new Issue following our issue template ISSUE TEMPLATE

Changelog

See in nuget version history

Did you like it? Please, make a donate :)

if you liked this project, please make a contribution and help to keep this and other initiatives, send me some Satochis.

BTC Wallet: 1G535x1rYdMo9CNdTGK3eG6XJddBHdaqfX

1G535x1rYdMo9CNdTGK3eG6XJddBHdaqfX

sqlclient-parsetoobject's People

Contributors

thiagobarradas avatar

Stargazers

 avatar

Watchers

 avatar  avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.