kiyokura/dapper-smple2.cshtml

## dapper-smple2.cshtml
@using Dapper;
@{
    IEnumerable< UserEntity> users;
    using( var cn = new System.Data.SqlServerCe.SqlCeConnection("接続文字列"))
    {
        cn.open();
        users = cn.Query<UserEntity>( "SELECT * FROM users");
    }
}
<!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="utf-8" />
        <title></title>
    </head>
    <body>
        <ul>
        @foreach( var d in users){
            <li> @d.Name : @ d.Email : @d.Age</li>
        }
        </ul>
    </body>
</html>

@functions{
    private class UserEntity{
        public string Name{get; set;}
        public string Email{get; set;}
        public string Age{get; set;}
    }
}
	@using Dapper;
	@{
	IEnumerable< UserEntity> users;
	using( var cn = new System.Data.SqlServerCe.SqlCeConnection("接続文字列"))
	{
	cn.open();
	users = cn.Query<UserEntity>( "SELECT * FROM users");
	}
	}
	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="utf-8" />
	<title></title>
	</head>
	<body>
	<ul>
	@foreach( var d in users){
	<li> @d.Name : @ d.Email : @d.Age</li>
	}
	</ul>
	</body>
	</html>

	@functions{
	private class UserEntity{
	public string Name{get; set;}
	public string Email{get; set;}
	public string Age{get; set;}
	}
	}