►
From YouTube: PHINUG Online Dev Sessions 2021.03
Description
This session is run by the Philippine .NET Users Group (https://meetup.com/phinug) that hosts meetups in Manila, Philippines.
Meetup link: https://www.meetup.com/phinug/events/276438594/
For our next session we'll be hearing from an awesome overseas Filipino .NET developer and his open source ORM that's giving Dapper and Entity Framework a run for their money!
Our talk is going to be about:
RepoDB, a hybrid-ORM library for .NET
RepoDB is an open-source .NET ORM library that bridge the gaps of micro-ORMs and macro-ORMs (aka Full-ORMs). It is your best alternative to both Entity Framework and Dapper.
=======================
About our speaker:
Michael Pendon
Michael is the Author of RepoDB ORM and a Senior Application Architect and Technical Area Responsible for Ørsted A/S. He is currently based in Denmark. While he's not developing software and tweaking database performance, he goes deep into trading and investing stocks online. He's a self-proclaimed selfie king in the tech world, having sought to have selfies with Mark Russinovich, Scott Guthrie, and Anders Hejlsberg, among others.
A
A
We
have
a
double
header
of
sorts
because,
because,
aside
from
our
main
speaker,
we
were
we're
going
to
have
you
know
we're
going
to
have
a
lightning
talk
first
and
then
and
and
we're
going
to
have
that
lightning
talk
from
someone
who
had
been
who
who
had
already
been
a
guest
of
enoch
and
during
our
live
session,
it's
his
first
time
to
speak
for
for
online
and
then
later
on.
We're
going
to
have
our
main
event
with
with
the
featured
speaker.
A
A
That's
we
haven't
seen
much
yet
because
it's
very
new
right
so
so
most
of
the
examples
that
you
would
hear
of
this
technology,
blazer,
which
we
talked
about
in
our
in
our
dot
net-
con
that
that
that
we
we
actually
had
rocky
lotka
from
from
magenic
talk
about
talk
about
that
yeah.
So
so,
for
many
of
us
blazer
would
some
be
something
that's
just
theoretical
or
something
that
we're
just
playing
with.
A
B
B
B
Yes,
oh
there's
here.
Okay,
all
right,
can
I
start
now,
john?
Yes,
yes,
go
ahead,
all
right,
so
hi
everyone
to
all
the
viewers
so
good
evening
and
yeah.
So
I'm
not
sure
that's
what
john
mentioned
basically
blazer
has
been
presented
before
right
and
actually
there
are
only
a
few
companies
who
are
actually
using
it
in
production,
and
I
can
say
that
we're
actually
one
of
those
few
companies
that
is
actually
using
this
in
production
that
is
using
laser
introduction.
B
But
before
I
dive
into
that
one,
I
want
to
give
first
a
quick
introduction
of
what
blazer
is
right.
So
without
further
ado,
let's
start
with
the
slide,
so
the
first
slide
would
be
c
sharp,
oh
and
this
one.
So
typically,
when
you
do
web
development,
the
combination
is
usually
html,
plus
css
plus
javascript
right.
This
is
a
very
common
foundational
step
if
you
want
to
build
web
applications
or
if
you
want
to
build
rich
and
beautiful
web
applications.
B
But
my
question
is:
is
js
really
necessary?
I'm
not
saying
we
remove
it,
but
the
question
would
be.
Are
we
really
gonna
be
stuck
with?
Javascript?
Is
it
really
possible
to
have
another
language
replace
javascript?
So
if,
let's
say,
if
we
replace
it
with
c
sharp,
for
example,
in
this
case,
is
it
possible
to
have
html
css
and
c-sharp?
B
Can
we
really
achieve
something
like
this?
So
this
actually
answered?
Oh,
it's
actually
happening
already,
and
it's
actually
answered
by
blazor.
So,
let's
start
with
what
is
blazor
followed
by.
Why
should
you
use
blazer
and
then
I'm
gonna
show
you
real
world
experiences,
actually
production
real
world
experiences
with
blazor
so
versus
what
is
blazor
right
in
order
for
us
to
answer
this
question,
I
want
to
give
you
a
quick
background
of
what
happened
in
javascript.
B
I
think
around
2009,
so
around
2009
node.js
was
introduced
to
the
industry.
What
happened
is
that,
instead
of
javascript
just
being
a
language
for
the
browser,
it
actually
became
a
full
stack
language,
meaning
you
can
actually
do
full
stack
development
with
javascript.
You
can
actually
connect
to
databases
now
create
web
api
endpoints
all
because
of
node.js
and,
of
course,
because
of
javascript,
and
as
you
know,
what
we've
seen
from
what's
happening
right
now
react
and
angular.
All
those
kinds
of
frameworks
are
actually
evolving.
You
can
now
even
use
them
on
mobile
phones.
B
So
if
you
know
javascript,
basically,
you
can
also
be
a
mobile
developer
now
right
right.
So
what
happened
with
c
sharp
with
blazor
c
sharp,
actually
became
a
full
stack
development
as
well,
not
just
for
the
web,
but
also
I
mean
not
just
for
the
desktop
applications
or
back
ends.
It
also
became
one
for
the
web
itself.
B
Wait
ken,
isn't
that
weird
we
have
asp.net
mvc.
We
have.
We
have
the
cshtml.
We
have
this
razer
pages,
so
why
do
we
need
blaze
or
what's
different
with
blazor?
What's
new
about
it
right?
What
is
re?
What
is
blazer?
Really
I'm
going
to
show
you
in
the
next
slide
in
here,
I'm
actually
showing
you
side
by
side,
an
actual
application
that
is
not
served
by
any
backend,
but
it's
rather
being
executed
by
the
browser
in
itself
or,
if
a
more
formal
term
for
this
would
be
a
single
page
application
right.
B
A
B
B
On
the
top
of
the
page,
it
means
just
a
page
like
a
routing
element.
It
means,
if
you
go
to
slash
counter
you're,
actually
going
to
be
seeing
this
page.
The
h1
typically
html
elements
right,
and
then
we
have
the
paragraph
here
like
a
p
element
and
what's
interesting
about
this
one.
Is
this
one,
the
current
count
and
the
code
section
below
why?
B
If
you
look
at
the
code
section
below
it's
c
sharp,
if
you
look
at
this
one,
it's
referring
to
a
current
count,
which
is
a
variable
in
c
sharp
and
you
have
the
on
click
button
like
you
have
a
button
here
and
there's
an
on
click
parameter
and
there's
an
increment.
It's
just
calling
the
method.
Okay,
isn't
this
just
a
typical
code?
Well,
you
might
say
so,
but
in
reality
the
c
sharp
code
is
being
executed
by
the
browser.
B
How
can
we
actually
use
blazor
or
how
can
the
browser
actually
use
c,
sharp?
Okay?
So
to
answer
that
question,
we
actually
need
to
see
how
it's
happening
inside
the
browser.
So
on
the
next
slide,
we
can
actually
see
this
one
so
inside
the
browser.
There's
a
concept
of
dom
elements
right,
I'm
not
sure
if
you
guys
are
familiar
with
dom
elements,
but
basically
those
are
just
your
html
and
it's
formatted
in
an
object
model,
and
then
you
have
the
blazer
stack.
We
have
what
we
call
the.
B
I
think
this
is
the
most
like
one
of
the
recent
technologies
in
the
industry
wasam
or
web
assembly.
Basically,
what
happened
is
that
the
net
runtime
was
actually
compiled
or
is
actually
basically
was
built
for
web
assembly.
Web
assembly
is
a
common
binary
instruction
set
that
the
browser
knows.
So,
let's
say
you
have
your
own
runtime
or
you
have
your
application
if
you
actually
recompile
them
to
actually
adhere
to
the
web
assembly
standards,
your
browser
can
basically
execute
it.
B
This
is
what's
happening,
and
then
we
have
the
razer
components,
which
is
which
includes
a
c
sharp
code
and
it's
running
on
top
of
the
dotnet,
which
is
actually
running
on
top
of
the
web
assembly
right.
So
this
is
actually
one
of
the
flavors
of
blazor.
This
is
what
we
call
blazor
wasan
or
the
blazer
web
assembly
as
they
call
it,
but
there's
another
section
to
it.
The
next
section
to
it
is
what
we
call
the
this
one:
the
blazor
server
all
right,
the
blazer
server
is
another
flavor
of
blazor.
B
Wherein
what's
happening
is
that
you
have
the
dom
elements
here
and
basically,
your
blazer
server
is
the
one
who's
actually
managing
all
the
pre-rendering.
It's
it's
keeping
track
of
the
injections
and
everything
and
it's
actually
sending
those
elements
via
signal
r
to
the
browser,
and
if
there
are
any
changes
like
a
mouse
click
or
or
of
some
sort,
it's
actually
going
to
be
sent
back
to
the
browser,
sorry
to
the
server
and
the
server
will
re-evaluate
it
and
give
back
the
updated
dom
or
like
a
section
of
the
dom
component
to
the
browser.
B
B
Another
comparison
would
be
think
of
the
server
side
as
your
angular
or
zero
application,
basically
you're,
giving
everything
to
the
browser
and
so
up
to
the
browser
to
execute
it.
So
what
why?
Why
is
wasm
interesting
or
why
is
webassembly
interesting?
It's
because
of
this
one.
If
you
go
to
roadmap.sh
font
and
I'm
sure,
if
you
guys
are
familiar
with
this
website,
the
very
last
thing
or
the
latest
one
on
the
roadmap-
it's
actually
called
the
web
assembly.
B
B
So
if
you're,
if
you're
really
interested
with
keeping
up
with
the
technology,
then
blazer
is
something
that
you
really
need
to
look
at,
especially
blazer
wasn't,
but
also
a
good
alternative
would
be
blazer
server.
So
let's
talk
about
this
next
question:
why
should
you
use
blazor
short
answer?
Basically
you're
a
dotnet
developer,
and
you
like
this
one
c,
sharp,
basically
c
sharp
for
everywhere,
because
you
want
user
to
be
everywhere
and
you
love
c
sharp.
Okay,
I'm
gonna
talk
about
some
of
the
advantages
on
a
theoretical
level.
B
After
that
I'm
going
to
go
on
a
production
level
standpoint.
Here's
some
of
the
advantages,
one
language
ruled
them
all.
You
don't
need
to
learn
javascript.
You
can
just
use
c
sharp,
okay,
not
all
the
time,
but
basically
c
sharp.
Can
already
suffice
faster
development,
of
course,
so
if
you
know
c
sharp,
you
know
you
don't
you
don't
have
to
study
like
what
promises
are.
What
are
the?
What
is
the
for
each
syntax
in
javascript?
What
are
the?
What
are
the
dictionary
in
javascript
those
kinds
of
things,
because
you're
using
c
sharp?
B
Basically,
you
can
also.
You
can
also
take
advantage
of
c
sharp
features
most
if
not
all
features
are
are
already
available
to
you,
regardless
if
you
are
on
the
blazer
server
or
if
you're
on
the
blazer
wasn't
side
of
things
all
right.
Now,
let's
talk
about
some
of
the
disadvantages
for
the
disadvantages.
I'm
gonna
answer
them
as
well
from
a
real
world
experience
with
blazor
all
right.
So
let's
talk
about
some
of
the
positive
points.
First,
before
we
go
to
the
negative
side,
integration
with
azure,
it's
much
easier.
Of
course.
B
Definitely
it's
a
net
product
right,
it's
very
easy
to
connect
all
of
them
together
and
deploying
them
on
azure
is
very
easy.
Also
if
you're
using
data
server,
we
have
this
azure
signalr
as
a
service,
so
we
can
just
take
advantage
of
it.
Basically,
it's
going
to
help
your
application
scale
more
if
you're
using
data
server.
I
think
the
second
one
is
actually
a
very
important
thing
to
note.
B
B
I
was
able
to
build
a
scheduling
app
for
the
web
application
in
30
minutes.
Take
note
it's
feature
rich.
It
doesn't
really
look
good.
It's
I'm
not
really
good
at
css,
but
the
features
are
really
really
there.
So
if
you
think
about
it,
if
you're,
if,
if
we're
actually
going
to
be
starting
one
from
angular
or
from
react,
we
need
to
understand
what
our
components
and
angular
and
react
what
are
promises?
How
do
you
do
an
api
call?
B
You
need
to
understand
how
to
secure
your
your
endpoints
buy
a
job
focus,
how
to
connect
to
them,
how
to
do
paging,
those
kinds
of
things
and
it's
gonna
be
really
really
hard
to
see.
You
still
need
to
learn
those
things
right,
but
with
blazor.
Well,
it's
basically
make
things
easier
since
you're,
just
focusing
on
delivering
the
features,
not
learning
technologies.
B
Now,
let's
talk
about
some
of
the
real
points,
the
negative
ones.
First,
one
if
you're
using
blazer
server
latency
can
be
an
issue
if
you
have
a
server
in
the
us
and
you're
in
the
philippines.
Of
course,
there's
going
to
be
some
delay
since
signalr
keeps
the
connection
right.
It
switches
between
web
sockets,
server,
server
or
long
polling,
but
bottom
line.
It
can
be
a
bottleneck,
but
there
are
ways
to
mitigate
it.
You
can
leverage
azure
or
create
another
instance
of
your
server.
B
It's
also
possible,
but
it
can
be
an
issue
next,
one
c
sharp
is
definitely
not
javascript.
Sometimes
you
need
to
actually
use
javascript
or
npm
libraries
and
the
good
thing
is
blazer
can
interrupt
with
javascript.
I
actually
wrote
a
blog
about
this
one.
You
can
actually
use
your
npm
packages
with
this
one.
I
just
forgot
to
send
the
link,
but
it's
on
my
medium
account,
but
it's
very
easy
to
interact
with
with
javascript
and
javascript
and
call
c-sharp
and
c-sharp
can
call
javascript
vice
versa,
so
basically
they're
very
interoperable.
B
Last
one,
it's
a
it's
debugging,
it's
a
pain
in
the
you
know
why?
Because
c
sharp
doesn't
support,
for
example,
digital
server.
It
doesn't
support
hot
reloading.
You
have
to
do
that
watch,
but
it's
going
to
recompile
it
every
now
and
then
so.
Hopefully,
it's
going
to
be.
Hopefully
it
can
be
addressed
soon,
but
it's
one
of
the
difficulties
in
actually
debugging
this
one,
but
to
be
honest
with
you,
all
of
the
negative
ones
is
actually
being
outweighed
by
the
positive
ones,
meaning
all
the
positive
ones
actually
basically
outweighs
the
negative
ones.
B
I
don't
think
that,
even
if
we,
even
if
we're
encountering
these
challenges
real
time
or
in
production,
we're
not
switching
away
from
laser
right
now,
because
we
were
able
to
deliver
more
features
than
studying
new
technologies
and
imagine
we
can
actually
stream
lots
and
lots
of
data.
We're
actually
streaming
data.
That
is,
that
consists
of
500
000
rows
and
the
browser
is
not
even
complaining
about
it,
we're
actually
able
to
handle
them
properly.
We
don't
need
to
care
about
the
paging
and
everything
because
it's
being
handled
by
the
user
in
itself.
B
So
I
guess
that's
a
quick
summary
of
us
doing
it
in
production.
We're
gonna
be
doing
another
talk
soon
in
june,
probably
or
july,
about
this
one.
We're
gonna
we're
gonna,
go
more
deep
dive
in
terms
of
what
we're
doing
and
how
we're
using
it
with
blazer
and
in
production.
So,
hopefully
guys.
I
can
see
you
in
that
talk.
So
now,
let's,
let's
proceed
with
some
of
the
questions.
I
think
I
still
have
some
time.
John.
Maybe
I
can
answer
some
of
the
questions
in
the
chat.
A
B
Right.
Okay,
thank
you,
luis
to
answer
your
question.
If
you
have
an
application
that
is
already
built
and
have
you
and
you're
you're
really
good
at
web
apis,
you
have
your
web
apis
in
place
already.
Definitely
go
with
wasam,
but
take
note
there's
a
loading
time
in
wasam,
so
you
have
to
be
careful
with
that
one.
B
My
suggestion
is:
if
you
really
want
to
take
advantage
of
blazor,
I
suggest
going
with
bazer
server,
but
there
are
downsides
to
it
like
you
need
to
manage
the
scaling
and
everything,
but
blazer
server
basically
makes
web
development
really
really
easy.
You
don't
need
to
understand
what
web
apis
are.
Basically,
it's
all
happening
flawlessly
and,
of
course,
integrating
with
something
like
azure
like
azure
b2d.
I
forgot.
I
forget
exact
term
authentication,
it's
very
easy
as
well
right.
There.
A
B
Let's
try
to
answer
both
sides-
I
guess
john
so
to
answer
the
javascript
dom
I
don't
think
so.
Well
it
might
but
yeah.
I
honestly.
I
don't
think
that
it
will
replace
javascript.
What's
gonna
happen.
Is
it's
gonna
live
alongside
javascript?
That's
definitely
the
right
answer
to
it,
so
I
don't
think
it
will
kill
or
it
will
replace,
but
definitely
it
will
live
alongside
with
it,
for
example,
even
for
the
legacy
languages.
It's
still
there
right.
A
Yeah,
you
know
the
way
that
I
expect
this
to
do
to
happen
in
the
in
the
future.
Is
that
for
for
it?
It
won't
really
replace,
replace
it's
just
more
like
you,
you
know
how
how
c
plus
is
still
being
used
today
when
you
want
certain
levels
of
performance
or
certain
certain
levels
of
hardware
compatibility,
for
example,
so
javascript
will
still
be
your
default
browser
or
dispos
web
environment
language
and
then,
and
then
these
are
your
alternatives
that
yeah
they
did.
B
A
Just
yeah
yeah
yeah-
that
is
true.
That
is
true.
All
right,
I
yeah
I'm
trying
to
wait
for
other
other
people
that
we
have
requested.
So
thank
you
to
everyone
that
that
are
here,
yeah
catherine.
Can
you
do
you
want
to
talk
about
more
about
what
you
do
in
your
company,
yeah
yeah,
anything
about
the
where,
where
or
or
where
they
can
catch
you?
Next,
if
you
have
another
event,.
B
Yeah
sure,
definitely
so
just
to
give
you
a
click
of
a
background
so
how
we're
using
blazer
in
production
on
my
company,
I
guess
that's
going
to
be
the
helpful
one.
So
what
we're
doing
is
what
we
it's,
what
we
call
process
mining,
it's
a
very
new
thing
in
the
industry
and
what's
happening
is
we're
actually
streaming
a
lot
of
data,
like
literally
five
hundred
thousand
rows
of
data
to
a
hundred
thousand
rows
of
data,
and
actually
I
can't
really
think
of
another
way
to
do
it.
B
If
we
don't
use
blazor,
that's
how
critical
days
are
for
us
is
right
now
there
are
ways
to
do
it,
but
it's
gonna
take
us
months
and
months
of
studying
just
to
be
able
to
achieve
it,
but
with
blazer
it's
like
a
snap.
We
can
actually
just
throw
in
those
data
to
the
browser
and
it's
handling
it
nicely
and
done
like
it
even
supports
virtualization
by
default.
So
imagine,
instead
of
doing
those
pagination
parts,
you
can
just
use
virtualization.
B
A
B
B
That's
a
very
good
question
when
you
say
html
over
webs.
Think
of
it
like
this,
you
have
your
normal
web
page
and
it's
connecting
to
a
website.
It's
streaming
data
back
and
forth
right.
The
problem
is
that
sometimes
a
browser
needs
to
optimize
some
things
and
you
need
to
set
up
a
lot
of
things
in
order
for
that
to
happen,
but
if
you're
actually
going
to
be
using
blaze
or
server,
it's
like
you
can.
B
Actually
you
can
actually
just
stream
your
dictionary
of
data
to
the
other
end
and
the
browser
will
definitely
get
it
and
think
of
it,
as
basically,
blazer
is
already
using
signal
rs
at
default.
If
you
use
html
over
web
sockets,
you
still
need
to
do
a
lot
of
coding
in
terms
of
basically,
you
need
to
set
up
your
signal
or
I'm
sorry,
your
websites,
what
happens
if
the
website
gets
failed?
B
What's
your
redundancy
or
what's
your
backup
plan,
if
you
signal
r,
it's
that
is
being
used
by
laser
server,
basically,
it
automatically
switches
to
long
polling
or
to
server
server.
If
that
happens,
so
it
will
try
its
best
to
keep
the
connection
alive.
So
I
guess
that's
one
of
the
big
differences
and
I
think,
to
be
honest,
the
optimization's
being
done
by
the
blazer
server
when
it's
transferring
data
to
transparing
dom
data
to
the
browser
side.
I
think
it's
much
better
than
doing
the
typical
html
over
websites.
B
To
be
honest,
two
sides
of
the
coin
blazer
of
awesome
doesn't
connect
the
database.
So
that's
out
of
the
question
right.
It's
still
up
to
your
backend
to
do
that,
one
laser
server!
No!
Why?
Because
it's
very
different!
It's
like
your
laser
server
is
connecting
to
the
database.
So
it's
two
different
entities
if
c-sharp
or
dot-net,
can
connect
without
problems
to
your
platforms
and
tools,
then
by
all
means
you
can
definitely
do
it.
B
A
B
I
guess
I
think
I
can
answer
the
angular
sign,
not
the
react.
One
I've
used
angular
for
two
years
and
we've
been
using
in
production
and
honestly
angular
has
been
really
great.
It's
opinionated
the
typescript.
It's
really
really
awesome
to
use
angular,
but
I've
been
with
c
sharp
for
the
last
eight
years.
If
I'm
not
mistaken,
when
I
started
a
new
project
with
reapp,
it's
with
sorry
with
blazer,
it's
like.
Oh,
it's
easy,
very,
very,
very
easy.
I
came
from
angular
I
used.
B
I
also
have
background
on
react
when
I
transition
to
blazor
it's
very
easy.
My
suggestion
is,
if
you
want
to
deliver,
features
really
really
fast
and
timeliness
of
deadlines
is
of
the
essence.
Go
with
blazor.
Definitely
that's
my
take
on
it
and
if
you
don't
care
about
some
loading
times
on
when
your
application
loads
go
with
blazer,
it's
it's.
It's
a
no-brainer
choice
for
me.
A
Right,
okay,
I
guess
that's
it
for
for
for
this
stuff.
Thank
you
very
much.
I
mean
that
was
a
very
quick
talk,
but
but
the
insights
that
you've
given
us
are
are
really
good
and
and
valuable.
I
guess
for
for
for
a
lot
of
people
and
companies
that
are
starting
to
consider
using
blazer
and
yeah.
They
want.
They
basically
just
want
some
people
or
some
companies
to
go
ahead
and-
and
you
know,
encounter
basically
be
the
the
tip
of
the
spirit
and
and
find
the
problems
for
them.
I
guess.
A
Yeah,
so
so
so
that's
very
valuable,
so
yeah,
I
guess
that
ends
this
segment.
Thank
you
so
much
kevin
that
was
so
much
a
very
quick
but
very,
very
insightful
and
a
very
nice
talk
on
on
blazer
and
yeah.
We,
sir,
we
we
learned
a
lot
about
it
and
yeah.
I
was
certainly
for
myself
it's
one
of
the
questions
that
even
you
even
not
really
my
company,
but
but
but
myself
for
personal
projects.
A
It's
one
of
my
questions
of
whether
this
is
worth
investing
in
so
so
that's
really
good
there
all
right
all
right!
So
so
I
think
I
think
luis
just
one
last
question
there
and
katherine.
I
I
suppose
I'd
leave
it
up
to
you
to
answer
that
in
the
chat.
If
that's
okay
I'll,
do
it
all
right
thanks
thanks
thanks,
okay
yeah
just
for
those
who
are
curious!
That
question
was
about.
A
He
has
security
and
releasing
security
patches,
and
all
of
that
so
I'd
wait
for
kedra's
answer
on
that.
But
I
do
not
want
to
delay
our
time
for
our
main
speaker
that
that
we
are
going
to
have
so
before,
but
but
but
before
we
proceed
to
him
yeah.
I
would
just
like
to
take
this
opportunity
again
to
thank
the.net
foundation
and
the
virtual.net
users
group
for
for
for
facilitating
this.
A
This
live
stream
they're,
the
ones
who
are
well
well,
it's
it's
their
stream
year
account
actually
that
that's
allowing
us
to
stream
this
and
it's
their
youtube,
channel
and
and
they've
supported
us
for
for
the
past
few
months
and
yeah.
Thank
you
so
much
for
for
that.
We
we
we
look
forward
to
to
working
together
in
the
next
few
months
for
more
of
these
streams.
A
So
if
you
were
all
familiar
with
and
hibernate
and
hibernate
actually
used,
a
library
called
cecil
and
sisa
was
was
a
was
a
oss
project
paid
by
by
a
pin
a
pinoy
developer,
who's
now
in
based
in
australia,
philipp
luriano,
but
but
yeah
after
after
his
his
stint,
I
was,
I
was
pleasantly
surprised,
early
well
middle
of
last
year,
when
I
learned
about.
Actually
it
was
a
late
learning.
A
C
But
first
of
all
I
would
like
to
say
thank
you
so
much
john
for
inviting
me
to
be
a
speaker
of
tonight's
show
in
philadelphia,
online
dev
session
for
march
and
also
for
the
earlier
speaker.
I
guess
I
also
learned
about
blazer.
I
am
actually
a
back-end
developer
historically
and
a
little
bit
in
ui,
but
it
seems
that
blazer
is
actually
a
really
exciting
tool
and
the
technology
used
to
it's
a
really
cool
presentations.
I
learned
a
lot
on
that
30
minute
session.
C
So
I
am
michael
penton,
I'm
the
author
of
repo
dbrm
and
that's
going
to
be
the
topic
for
tonight
and
before
we
dive
down
into
the
actual
session,
I'm
gonna
tell
you,
what's
gonna,
be
the
importance
on
this
session
right
now
that
I'm
going
to
showcase
to
you?
I
actually
this
will
provide
you
the
detailed
overview
of
the
library,
both
the
features
and
the
functionalities,
and
because
of
this
it
will
help
you
solve
the
real,
complex
edge
cases
in
relation
to
the
data
access
space
in
that
net.
C
Rivo
db
is
an
open
source
that
net
rm
library
that
reduces
the
gaps
of
micro
or
amps
and
macro
orange
or
alcohol
or
amps,
also
known
as
photo
rms,
and
it
helps
you
simplify
the
switch
over
when
to
use
the
basic
and
advanced
operations
during
the
development,
and
I
actually
try
to
make
the
bold
gaps
here.
And
what
are
these
gaps
that
I'm
trying
to
say
it's?
C
I
mean
the
micro
or
m
and
polaris,
and
how
is
it
differed
from
the
two
very
popular
orm,
so
entity
framework
developed
by
microsoft,
full-fledged
orm
and
almost
has
everything
that
were
developed
by
stock
overflow,
the
most
likely
om
in
the
market,
and
you
need
to
issue
a
sql
statement
at
all
times,
whereas
ripple
db
is
actually
the
one
with
jade
the
developers
mostly
need
features
from
both
entity
framework
and
docker
orm.
You
can
open
a
connection
as
simple
as
dapper
and
execute
the
operations
as
simple
as
entity
framework.
C
Note
that
ripple
db,
core
and
doppler
are
considered
the
bare
metal,
orms
and
also.
I
would
like
to
make
a
disclaimer
on
this
page
that
I
am
not
putting
ripple
db
on
the
same
label
as
dapper
and
entity
framework,
but
I
actually
use
these
two
rms
to
become
the
benchmark
when
it
comes
to
the
features
for
entity
framework
and
offer
for
the
performance
and
that's
the
reason
why
actually
putting
it
here
and
the
supported
relational
database
management
system
are
sql
server,
postgresql,
mysql
and
sqlite.
C
C
That's
going
to
be
the
future
below
are
the
features
available
on
this
orm,
so
we
support
asynchronous
operations
batch
and
bulk
operations.
Caching,
second
layer,
glass,
handlers,
connection,
persistency,
dynamic
operations,
expression,
trees,
flowing
operations,
explicit
and
implicit
mapping.
Inline
hints
multi-result,
set
query
property
handlers,
repositories,
statement,
building,
tracing
transaction
and
type
mapping,
but
on
this
demo,
if
you
try
to
follow
my
show
in
microsoft
earlier,
it
was
actually
only
four
features,
but
here
I'm
trying
to
make
it
more
seven
features
I'm
going
to
showcase.
C
We
try
to
implement
the
actual
implementations
of
these
two
concepts
and
I'm
going
to
showcase
that
one
later
I
mean
caching
is
allow
the
users
to
temporarily
store
the
data
into
the
memory
or
any
other
caching
storage.
For
example,
you,
if
you
are
using
file
like
you,
can
use
json
or
xml,
you
can
even
utilize
the
existing
technology
like
memcache
or
even
a
localized
database
like
sqlite
or
whatever
kind
of
caching.
C
C
The
next
feature
is
repository:
it's
allow
the
users
to
organize
and
simplify
the
implementation
of
the
data
access
layers
and
in
ripo
db
we
have
two
kind
of
repository.
We
have
db
repository,
it
is
used
for
implementing
a
dynamic
repository
and
the
base
repository
is
used
for
implementing
an
entity-based
repository
a
little
bit
example
for
this
one.
If
you
are
using
db
repository,
if
you
have
a
database-
and
you
would
like
to
work
on
all
tables
in
the
database-
go
for
the
db
repository.
C
But
if
you,
if
you
would
like
to
make
sure
that
your
repository
is
actually
based
on
the
table
level,
entity
based
then
go
to
the
base
repository
and
on
this
example
letter
I'm
going
to
show
I'm
going
to
showcase
the
base
repository
dynamic
operations.
This
is
the
feature
that
would
allow
the
users
to
create
and
simplify
the
targeted
operation
by
simply
maximizing
the
usage
of
anonymous
types.
I
would
say
dynamic
types
in
general
in
that
net.
C
It
is
very
useful
if
you
wish
to
do
accrued
operations
on
the
targeted
columns
and
or
make
the
code
operations
without
even
having
a
class
model
or
entity,
and
the
disclaimer
for
this
is
that
the
feature
is
called
dynamics
in
a
context
of
an
orm,
but
don't
get
confused.
This
dynamic
terminology
in
ripple
db
against
the
dynamics
terminology
against
that
net
ecosystem.
I
will
explain
that
one
I
mean
here
ripple
db,
supports
different
kind
of
dynamics
like
the
object,
anonymous
type
dictionary
string,
object
and
such
kind
of
things.
They
are
supported.
C
It's
very
efficient
in
memory
usage,
it's
a
lightweight,
no
change
tracking,
no
extra
calculations
so,
unlike
unlike
enter
the
framework
that
you
are
actually
having
this
tracking
change
tracking
things
right,
but
any
ripple
debate
is
a
bit
a
bare
metal
and
a
bit
lower
lower
level
when
it
comes
to
that
and
hybrid
orm,
it's
easy
to
switch
between
massive
and
micro
or
amps.
I
mean
operations
and
the
only
identified
or
in
framework
and
dotnet
that
supports
this
fast
switching
capability,
and
it's
also
the
reason
why
it's
very.
C
To
use
I
mean,
that's
the
the
most
simple
orange
to
use
in
in
the
market
right
now
for
that
net,
and
it's
only
takes
10
seconds
to
install,
I
mean
in
the
end,
in
the
in
the
five
here
I
made.
I
want
to
put
a
disclaimer
on
my
wordings
about
the
simply
as
rm.
That
is
because,
if
you
are
using
dapper,
you
open
a
connection
and
execute
the
sql
statement
right
in
repo
db.
You
open
a
connection
and
call
the
operation.
That's
how
simple
it
is.
C
C
So
actually
I
have
about
three
solutions
here,
but
I
go
first
on
the
first
one
there's.
The
first
project
that
I
created
is
a
dotnet
file
project,
a
very
simple
api
that
contains
the
cloud
operations.
I
already
have
created
the
objects
here
in
preparation
for
this
demo
to
to
beat
the
time
and
I'm
going
to
explain
one
by
one.
What
I
have
done
here
before
we
go
proceed
with
it.
So
first
I
created
an
eye
repository.
It's
a
very
simple
interface
that
has
these
five
methods.
I
mean
this.
This
method
is
good
six
methods.
C
It's
accept
a
generic
type
of
tea,
which
is
actually
the
model
that
we
were
going
to
work
on
against
the
database,
and
then
I
created
a
model
called
person,
and
this
person
model
has
four
properties
and
then,
and
then
these
properties-
it's,
I
start
with
a
string
here.
So
that's
later,
I'm
going
to
showcase
about
the
address
model,
but
this
properties
here
is
actually
equivalent
to
what
I
have
in
the
database.
C
So
I
am
look
I'm
using
the
local,
my
sql
server
database
on
my
local
machine,
and
I
already
have
prepared
this
single
table
person
that
has
four
columns
equivalent
to
this
table
on
this
demo.
We
will
just
do
it:
a
direct
access
only
from
one
entity
to
the
to
the
actual
table
in
the
database,
and
on
top
of
that
I
created
an
interface
called
iperson
repository.
C
I
see
for
a
simple
repository
and
that
implements
the
I
repository
that
uses
the
model
person
we're
going
to
use,
and
here
I
also
created
a
repositories
class
person
repository
that
inherits
the
base.
Repository
of
repo
db,
I
didn't
share
it
earlier,
but
I
already
have
installed
the
package
of
repo
db,
so
I
have
installed
the
package
ripple
db
liquidity
with
the
sql
server
and
they
would
be
the
sql
server
that
bulk
operations.
If
you
don't
want
valve
operations,
you
can
remove
this
one,
but
I
already
have
pre-installed
this
one
on
this
project.
C
So
now
I
have
inherited
the
base
repository
and
here
I'm
saying
that
I
would
like
to
work
on
the
person
model
and
I
would
like
to
connect
to
the
sql
connection.
I
mean
to
the
sql
database.
If
I'm
using
postgre,
you
can
use
something
npg,
sql
connection
or
sqlite
connection
or
mysql
or
mysql
connection.
C
Let's
go
connector
connection,
something
like
that
and
also
I
personally
repository,
I
implemented
the
existing
repository
that
I
created
here
for
me
to
be
able
to
implement
those
methods
that
I
needed
to
and
once
you
have
inherited
the
base
repository
of
rivodb.
If
I'm
going
to
call
the
baser,
you
already
have
inherited
all
the
methods
of
ripple
db.
So
here
it
contains
all
the
methods
you
can
actually
utilize
against
your
database
and-
and
you
can
do
the
insert
you
can
do
the
merge.
C
You
can
do
the
insert
always
actually
the
batch
operations
things
like
that
now.
You
can
do
that
and
then
and
every
method
that
I
had
here.
I
don't
need
to
write
sql
statement
for
that.
I
don't
need
to
open
a
connection.
I
don't
need
to
to
pass
the
parameters,
but
all
I'm
going
to
have
to
do
is
to
just
simply
call
repo
db
based
method
so
for
the
delete.
I
use
the
delete
method
and
pass
the
primary
key.
C
It
can
also
you
pass
whatever
you
would
like
to
like
expressions,
for
example,
something
like
e
that
name
something
like
that.
Like
entity
framework
I
should
do
is
also
supported.
You
can
also
pass
a
query
objects,
it's
something
like
a
new
query,
object
things
like
that
and
then
and
then
do
the
things
you
can
also
pass
a
dynamic
object
or
anonymous
type
yeah
on
this,
and
also
for
the
get
same
as
the
delete.
C
You
can
also
do
it
like
that,
but
I'm
just
use
the
query
method
and
then
for
the
get,
also
query
all
method
and
merge
for
the
merge
method,
and
I
also
use
the
name
as
the
qualifier.
But
it's
not
limited
only
to
one
qualifier
by
depot
is
using
the
id.
But
here
I
force
the
name
because
I'm
going
to
explain
it
later
and
you
can
also
utilize
multiple
qualifiers.
C
For
example,
if
you
have
an
ssn
and
you
would
like
to
use
the
last
name
here
as
the
qualifier
you
usually
like
that
right
in
the
system,
then
you
can
do
it
like
that.
But
for
now
on
this
demo,
I'm
going
to
use
single
qualifier
and
for
the
save
I
just
choose
the
insert
return
the
log
as
the
primary
key
and
the
entity
just
insert
it
and
then
update.
C
This
is
the
update
method
of
the
base,
and
this
is
how
it
is
and
when
it
comes
to
the
to
the
registration
of
the
of
the
repository
first
before
you
actually
start
working
with
wdb,
you
have
to
call
the
the
bootstrapper.
So
every
package
that
you
have
installed
in
your
solutions,
via
repoddb
unity,
called
initializer
initializer,
is
actually
the
one
that
will
going
to
initialize
all
the
settings
needed
in
order
for
you
to
work
on.
C
The
specific
database
are
the
vms,
and
here
it's
very
simple
connection
string
and
look
I'm
connected
to
my
local
server
or
the
motive
db
database.
Integrated
security
is
actually
my
as
an
admin,
and
I
just
created
a
single
time,
deposit
depository
as
a
sample
here
and
then
I
passed
my
new
repository
and
here
guys
you
can
see
that
it's
maybe
not
the
best,
the
best
patterns,
but
this
is
just
a
demo.
C
So
please
fyi-
that
is
a
very
simple
project
for
this
demo
and
and
for
the
patterns
and
practices,
is
a
different
thing,
and
here
you
can
see.
Usually
in
the
controller
we
post
the
services
or
managers
or
business
layers
right,
but
here
in
this
demo
I'm
going
to
use
the
repository
directly
just
to
showcase
the
purpose
of
rival
db
and
and
then
in
this
repository,
I
also
created
the
the
necessary
method
to
call
the
method
from
the
repository.
C
Yes,
cool
and
while
we
are
waiting
to
run
this
project
on
my
local
machine,
I
have
opened
a
lot
of
instances
here.
So
I
also
have
the
postman
here
and
I
use
this
tool
rather
than
the
the
one
that
has
been
generated
by
the
swagger,
so
I'm
gonna
use
the
post
one,
at
least
for
this
example
for
me
to
be
able
to
control
everything.
The
calls
on
the
actual
api
that
this
one,
but
eventually
the
dotnetpipe,
is
actually
automatically
integrated
into
swagger.
C
C
I
know
it's
actually
using
those
insert
operations
of
rival
db
and
you
can
see
that
the
id1
has
been
resulted
here
and
you
can
see
in
the
database
that
the
record
has
been
inserted
and
for
the
get
all
just
simply
called
the
get
all
operations.
You
see
the
query
method
or
very
old
method
of
rifle
db
and
that
returns
to
the
data
against
a
database,
and
here
the
merge,
very
simple
call
and
it's
something
like
that.
C
I'm
using
my
name
as
the
as
the
qualifier
and
then
I
realized
that
actually
not
from
from
copenhagen,
but
right
now,
actually
living
in
genta,
for
example
in
denmark,
and
then
I'm
gonna
send
this
one.
You
can
see
that
I
know
that
michael
penton
is
now
existing
in
the
database
and
I'm
gonna
update
that
record
rather
than
rather
than
inserting
a
new
one.
C
C
So
the
record
has
been
inserted
in
the
database
because
michael
kamar
is
not
yet
in
the
database
right,
so
things
like
that,
so
that's
actually
the
fourth
of
it
and
then,
if
you're
going
to
make
a
delete
and
then
just
simply
pass
those
id
number
two,
I'm
gonna,
I'm
gonna
delete
those
those
person
two
has
been
deleted
in
the
database
and
same
goes
with
the
other
methods.
It's
almost
the
same
like
like
entity
framework,
and
that
is
how
it
is
so.
C
The
one
that
I
actually
showcased
to
you
earlier
is
actually
the
the
repository
and
how
how
it's
actually
simple
to
how
simple
it
is
to
implement
depository
via
repo
db
and
then
and
then
and
then
the
next
topic
and
features
that
I'm
going
to
showcase
to.
You
is
actually
the
caching
second
layer
which
is
a
bit
important
feature
and
repo
db
by
default.
It's
actually
using
the
memory
cache
object
of
ripo
db.
C
So
there
is
what
we
call
memory
cast
object,
not
the
memory
cache
of
that
net,
because
I
think
we
need
to
somehow
customize
the
way
how
we
do
caching
with
ripo
db.
So
it's
interface-based
implementation
and
you
can
also
create
your
own
memory
cards
or
own
caching,
just
by
simply
implementing
the
I
cache
object
or
repo
db
or
interface
and
inject
it
here.
C
This
for
this
one
is
actually
person
and
I'm
going
to
put
people
I'm
going
to
cache
them,
and
the
recommendation
for
this
is
that
if
you
have
a
table
in
the
database,
that
is
not
frequently
changing.
That
is
actually
the
candidate
of
forecasting,
so
it's
actually
a
static
table
or
share
table
or
some
lookup
table
list
of
products
from
your
website.
C
You
can
just
simply
pass
the
the
retention
per
year
here
in
the
in
the
overloaded
methods.
As
you
can
see
the
cache
item
expiration
here
you
can,
you
can
just
flash
it
anytime
you
would
like
to,
and
that
would
change
the
cache
item
expiration
of
the
cache.
And
if
you
would
like
to
purge
the
information
of
the
cache,
you
can
just
simply
access
the
cache
object,
property
of
the
base
repository
and
then
you
can,
you
can
add
customize
cache.
If
you
would
like
to
you
can
clear
it.
C
C
C
But
yes,
yeah,
that's,
okay,
surgeon!
Just
let
me
know
if
there's
a
question,
so
I
can
also
answer
that,
while
I'm
doing
the
demo
so
sure
so
so
here
we
already
have
one
record
in
the
database.
You
can
see
earlier,
but
I've
seen
something
like
I'm
going
to
put
something
like
one
de
la
cruz
here
or
jandal.
C
Something
like
manila
follow
things
and
then
run
it
now.
You
can
see
that
I
have
two
records
on
the
database.
Right
is
it?
Is
it
the
same
that
I
have
yes,
it's
three.
It
has
created
a
tree
here.
You
can
see
that
I
have
two
records
already
in
the
database
and
if
I'm
going
to
call
the
get
all
you
can
see
that
after
you
get
those
record
from
the
database
and
you
can
see
that
the
time
took
is
up
315,
milliseconds
and
the
second
time
I
call
this
one.
C
It
will
only
take
16
milliseconds
because
the
second
call
is
only
half
is
already
happening
or
retrieving
the
informations
from
the
cache
and
not
from
the
database.
As
you
can
see
it,
it
even
lowers.
Sometimes
it's
become
more
faster
and
here
you
can
see
if
I'm
going
to
truncate,
let's
say
I'm
going
to
truncate
the
table
here.
C
And
there
is
no
record
now
in
the
database.
Right
revoir
would
still
have
those
record
because
it's
already
cached
using
those
people
kashki
earlier
and
until
the
application
is
stopped,
then
it
will
actually
remove
from
the
cash
or
until
the
expiration
date
of
three
hours
is
actually
lapse.
That
will
remove
the
cash
there.
So
that's
actually
the
caching
mechanism
of
a
rifle
db
and
then
the
next
feature
that
I'm
going
to
showcase
is
actually
the
tracing.
C
C
It
creates
all
the
methods
for
every
operation
rival
db
before
and
after
before,
it's
actually
being
triggered
before
the
actual
executions
against
the
database
and
after
exactly
the
one
that
is
being
executed
after
the
executions
against
the
database,
and
here
you
can
see
as
well
that
own
the
before
it's
after
the
concealable
trace
log.
So
it
means
that
if
you
saw
that
this
execution
is
a
bit
yeah,
it's
a
fraud
execution.
It's
not
really
for
this
man
or
this
purpose.
It
means
that
you
can
always
cancel
that
operations.
C
You
can
throw
the
exception
back
to
the
caller,
and
it's
also
inherited
the
trace
log,
which
is
actually
the
one
the
same
as
what
we
have
in
the
after,
which
contains
the
session
id
the
result,
the
parameter
and
statement.
I
will
showcase
it
to
you
so
here
after
you
have
created
all
those
cache,
I
mean
this
object
might
cause
your
your
your
trace
object.
C
That,
and
here
is
the
I
trace
interface
of
rival
db.
All
you're
gonna
have
to
do
in
the
repository.
Is
that
to
just
inject
it,
so
you
can
see
it
here
this
base,
you
can
see
it
actually.
There
is
overloaded
method
here,
but
we
can
also
inject
the
eye
tracer
if
you
would
like
to-
and
I
suggest
for
you
to
have
a
dependency
injection
here
or
ioc
part
of
the
of
the
iris
implementations
in
this
example.
C
I
just
use
this
object
instantiation
just
for
this
for
first,
but
the
the
best
is
actually
to
d.
I
this
thing
okay
and
then,
and
then
I'm
go
so
now.
All
I'm
gonna
have
to
do
is
just
inject.
It
and
I'll
have
the
trash,
and
then
I
have
the
the
tracer
and
then
I
just
put
a
comment
or
a
breakpoint
on
the
on
the
metal
that
I
would
like
to
trace.
Saying
like
that
and
then
maybe
log
it
in
the
console
or
the
log
file
or
in
the
application
insights.
C
Then
then,
then
I'll
showcase.
It
I
mean,
I
run
the
application
and
then
I
call
the
operations.
So
now
it's
running
before
the
demo
started
very
fast
and
then
during
the
actual
game
was
a
bit
slow
and
I
don't
know
what
happened
so.
But
yes,
here
you
can
see.
I'm
gonna
insert
a
record
here,
so
I'm
gonna
put
something
like
jandal,
for
example,
and
he's
from
new
york,
usa.
C
And
see
reaperdivi
actually
breakpointed
into
the
before
insert
because
that's
the
before
insertions
happen
and
if
I'm
going
to
somehow
what
we
called
see
what's
happening
here.
Ribodavi
give
you
the
statement
that
has
been
composed
by
default
for
you.
So
it's
insertion
inserting
the
records
into
this
table
passing
this
address,
and
this
is
also
returning
the
the
newly
created
scope
identity,
because
it's
after
the
identity,
column
id
and
here
you
can
see
as
well-
that
I
can
also
see
the
statement.
C
But
you
have
the
result
already
here
and
the
statement
is
the
same
right
and
then
you
can
see
in
the
database
that
this
john
doe
is
now
actually
inserted,
and
you
can
see
also
the
elapsed
time
how
fast
it
is
being
inserted
into
the
database
just
the
execution
time
of
the
operations
and
also
it's
the
same
as
what
we
have
if
you
are
going
to
make
a
get
all
here.
So
in
the
get
all
you
can
see
here,
for
example,
the
what's
the
statement.
C
What's
decision
id
and
what's
execution
time
and
to
give
you
example
how
to
utilize
this
concealable
trace
log.
This
is
the
example
that
I
really
would
like
to
that.
If
you
can
audit
the
thing
so,
for
example,
if,
like
that
statement
that
contains
delete,
so,
for
example,
this
is
just
a
sample
right
and
you
see
that
oh,
this
is
really
fraught,
because
it
is
a
clip
for
query
all.
But
somebody
injected
a
new
builder
in
reaperdivi
and
all
they
can
have
to
do-
is
to
delete
it.
C
For
example,
there's
a
library
who
created
this
one
right.
I
created
this
ex
new
sql
server
builder
and
they
actually
would
like
to
inject
something
in
your
database
and
then
you
accidentally
reference
that
package
and
then
you
can
ask
something
like
cancel
that
automatic
and
introduction
back
to
the
caller.
C
So
this
is
just
for
the
purpose
of
security,
for
example,
but
you
can
also
do
whatever
you
would
like
to
just
to
trace
the
operation
so
and
then
I'm
gonna,
I'm
gonna,
I'm
gonna
run
this
one,
and
you
can
see
that
also
that
after
query,
you
can
see
how
how
actually
fast
it
is
and
also
the
result
set
here.
So
you
can
see
there's
only
one
record
on
the
database.
C
A
A
C
C
Ripple
db,
it's
2018,
I
actually
it's
it's
I'm
historically,
I'm
actually
maybe
would
like
to
say
maybe
something
like
I
mastered.
Idio.Net
so
connected
things
like
that.
So
I
know
all
the
objects
there
in
idio.net
from
1.0
version
of
c-sharp
and-
and
I
think
I
can
utilize
that
my
old,
my
old
job
is
actually
doing
a
crm
like
salesforce.
Will
you
create
the
objects
and
create
the
objects
dynamically
right
in
salesforce.
A
C
I
also
did
that
in
n4
in
the
philippines,
I've
been
a
part
of
n
for
principal
super
engineer
and
and
then
I
created
those
cancellation,
wizards
and
such
kind
of
things,
building
a
dynamic
way
of
building
the
objects
and
customers
or
business
areas
and
activities
and
opportunities
from
the
specific
customers.
It's
a
crm
and
it's
a
bit
dynamic
and
then
and
then
on
our
recent
company.
C
I
have
a
requirement
of
something
like
creating
a
repository,
a
very
simple
repository
and
then
under
integrate
the
two
databases
together
and
it's
a
utilized
doppler,
and
I
cannot
utilize
entity
framework
because
entity
framework
is
not
really
dynamic.
So
the
only
thing
is
dapper
by
that
time
and
it's
a
hell
of
implementations.
So
I
need
to
write
everything
in
a
sequel
statement
and
it's
very
difficult,
just
for
example,
while
insert.
But
how
can
I
do
this
in
dapper?
Should
I
really.
A
C
All
those
things
and
then
and
then
I
have
skills
of
creating
this
this
thing
and
I
have
envisioned
this
one.
It's
a
collective
experience.
It's
not
only
my
experience
right.
It's
also
the
my
fellow
developers
and
architects
say
that
I
really
would
like
a
method
that
I
just
you
know
what
and
just
the
list
of
entity
watch
it
and
it's
the
real
batch,
not
just
simply
an
iteration,
and
I
can
explain
it
later.
All
right.
A
C
Yes,
so
yes,
so
we
are
in
the
class
handler.
So
this
is
the
feature
that
would
allow
you
to
intercept
the
the
the
hydration,
the
digitalization
and
serialization
process
of
the
model,
so
in
ripple
db,
all
you're
going
to
have
to
do
is
to
implement
a
class
that
implements
the
I
class
handler
interface,
and
the
purpose
of
this
is
to
allow
you
to
handle
which
specific
model
you
would
like
to.
C
You
can
see
here,
yeah
personal
class
under
okay,
so
that's
it
and
on
reputable
we're,
gonna
use
the
class
sender.
So
in
this
person
class
on
there,
I'm
gonna
actually
put
a
comment,
a
breakpoint
here
and
then
so
that
we
will
gonna
handle
that
later
and
break
that
later.
So,
but
there
is
also
if
you
would
like
to
remove
the
explicit
mapping,
that's
actually
the
explicit
mapping,
because
you
put
an
attribute
into
the
model.
C
C
They
would
be
also
supported
that
one
driven
by
the
community
of
that
net,
so
you
can
now
put
an
entity
here,
for
example,
person
and
then
in
that
personal
entity
I
would
like
to
put
class
under
what
is
the
class
under
the
class
and
there's
actually
the
the
person
class
senders,
for
example,
and
that's
it
and
automatically.
This
is
also
equating
the
one
that
we
have
set
up
before
by
attribute.
You
can
also
see
a
property
under
here.
You
can
also
something
like
db
type.
C
You
can
also
see,
what's
the
table
equivalent
in
the
database,
dbo
that
or
that's
something
like
sales
that
person
right-
it's
not
in
a
depo
dbo,
so
you
can
also
do
it
like
that,
and
this
is
what
we
call
implicit
mapping
and
and
then,
of
course,
the
way
how
you're
going
to
do
this
is
that
use
this
one
in
your
registrations
or
just
call
it
once
so
that
you
actually
mapping
all
those?
But
let's
just
go
to
the
class
handler
here.
C
C
As
you
can
see
that
rivet,
we
already
invoked
those
set
method
right
and
it's
passing
all
the
entities
that
you
pass
from
the
client
as
well.
There's
no
change
to
that
one.
But
here
what
I'm
going
to
do
is
that
it
gives
you
an
opportunity
to
validate
the
content
of
this
entity.
If
you
would
like
to
move
something
like
validation
here,
you
would
like
to
make
translation
if
you
would
like
to
make
streaming.
C
In
this
example,
I'm
going
to
put
a
handled
keyword
here
and
then,
instead
of
putting
something
like
honors
anderson
I
was
put
on
us,
understand,
call
and
handle
and
then
return
the
entity
and
that
entity
will
be
the
one
will
be
inserted
to
the
database,
as
you
can
see
here
so
it's
handled
and
then
now
I'm
going
to
query
the
back
the
entity
as
you
can
see
every
time.
I
query
the
entity.
C
C
The
position
of
the
iterator
is
actually
equivalent
to
what
we
have
dehydrated
to
this
model
and
you
can
handle
the
things
here
so
here
for
now.
For
me,
the
name
that
we
get
from
the
database
is
this
one,
but
I'm
removing
this
handle
and
then
it's
it
returned
the
the
normal
name,
but
in
the
sense
in
between
really
before
you,
you
save
the
data
into
the
database
and
you
bring
back
the
data
to
the
client.
You
handle
those
one
right.
C
If
we
have
the
class
under,
we
also
have
property
handlers,
and
this
is
a
feature
that
will
handle
the
property
level
and
on
this
one
right,
I'm
going
to
showcase
the
the
the
way
how
we
put
an
object
from
c
sharp
into
a
string
type
in
the
database
and
then
read
the
string
type
in
the
database
and
return
it
as
an
object
into
the
application.
So
it's
a
complex
way,
but
that
can
be
handled
in
a
person
I
mean
in
a
in
a
class.
C
I
mean
property
handler
in
this
one.
All
you're
gonna
have
to
do
is
to
create
a
class
and
implement
an
eye
property
handler
interface,
and
this
contains
two
generic
types
here.
The
first
one
is
actually
the
type
of
your
database
and
the
second
one
is
actually
the
type
of
your
property
okay.
So
here
in
the
person
model,
I
would
like
to
say
to
handle
this
address
column,
which
is
equivalent
to
the
address
column.
Here
I
mean
this
address
property,
and
then
I
don't
want
a
string.
C
I
I
want
an
object
address
which
contains
three
column
or
three
properties,
which
is
straight
postal
code
and
country.
Okay,
so
I'm
gonna
have
to
do,
is
to
put
it
here
and
then
I
will
put
a
handler
for
that.
I
already
have
created
the
property
handler
for
that
one.
So
this
is
the
string
in
the
database
an
address
property,
and
this
is
a
name.
It
person
that
address
property,
property
handler
and
all
we're
going
to
have
to
do
is
the
same,
just
put
property
handler
offs,
stipul
and
then
property
handlers.
C
This
one
yeah,
of
course
I'll
just
remove
this
one
so
that
there
will
be
no
disturbance
on
the
breakpoint.
So
so
I'll
just
say,
but
you
can
do
you
can
you
can
actually
put
them
together
if
you
would
like
to,
but
it
will
slow
down
the
process
of
course,
because
you're
handling
both
so
but
here
you
can
see,
I'm
gonna
run
this
one.
C
Applications
and
all
I'm
gonna
have
to
do
here-
is
to
insert
a
object
into
the
database
right,
so
I
already
prepared
that
object
here
to
speed
it
up
and
during
insertions.
Instead
of
putting
a
string,
I
put
an
object
here
as
a
json
object.
You
can
see
it
contains
those
three
properties
right
and
then
I'm
going
to
send
this
one.
C
C
As
you
can
see
here
and
then
I'm
gonna
return
this
address
as
a
string,
but
it's
serialized
as
a
json
convert
by
a
newtons
of
json
as
a
string,
json
object
and
I'm
going
to
save
this
one
in
the
database
as
you
can
see,
and
then
run
it
again,
and
you
can
see
that
the
one
that
is
saving
the
database
is
actually
this
one
again.
There
is
a
legacy
system,
for
example,
that
we
are
leveraging.
C
We
are
integrating
that
we
have
xml,
we
have
also
json
or
whatever
kind
of
or
binary
format
right,
and
if
you
you
sometimes
you
cannot
read
it
right
and
here
property
handler
can
handle
that
one.
So
for
in
this
case
it's
json
very
simplified
and
I'm
going
to
query
the
data
from
the
database.
As
you
can
see,
the
get
method
is
also
being
called,
as
you
can
see
here.
C
That's
why
it's
also
returning
in
the
yeah
in
the
calls
here,
so
that's
actually
for
for
for
the
property
handlers,
and
I
am
gonna
move
into
the
next
feature,
which
is
actually
the
batch
and
bulk
operations.
This
is
a
very,
very
important
feature
that
I
I
mean.
Maybe
one
of
the
highlight
and
repo
dv
that
I
can
showcase
to
you
guys
so,
but
I
have
a
second
screen
here
and
watch
bug
operations.
Where
are
you
you
know
you
are
here?
Yes,
cool?
C
Yes,
so
I
have
a
very
simple
console
application
here
with
the
same
database,
I'm
using
person,
okay
and
I'm
also
using
the
same
database
and
also
connected
to
my
local
machine,
maybe
just
to
clear
everything.
I'm
gonna
truncate
the
information
in
my
database
and
I
created
a
very
simple
method.
There.
Four
methods
I
do
do
atomic
do
batch,
do
and
do
dynamic
and
the
first
of
course
I
do
trunking.
As
I
mentioned
earlier.
C
First,
you
first
initialize
ripple
db,
call
always
this
one,
the
initialize
method,
and
then
after
that
one
you
can
now
call
all
the
operations
like
dapper.
As
I
mentioned
earlier,
when
you
open
the
connection,
you
can
now
call
the
methods
automatically
here
so
connection
and
then
insert
whatever
it.
Is
it's
not
accessible
to
you?
It's
very
wrong.
C
Actually
so
as
simple
as
open
connection,
I
think
called
operations
here,
I'm
gonna
trunk,
it
first
the
person
and
that's
okay,
the
person
table
and
here
what
I'm
doing
in
the
do
atomic
method
is
that
I
actually
yielding
I
created
a
method
yielding
of
the
list
of
person
here
and
then
just
simply
return.
The
number
of
people
based
on
the
account
that
I
have
passed
after
leaving
here,
I'm
gonna,
I'm
gonna
pass
one
by
one
later,
and
here
I
iterated
it
one
by
one
and
insert
the
information
to
the
database.
C
So
it's
very
atomic,
it's
one
by
one
as
an
iteration.
How
many
rows
is
that
and
then
the
batch
is
that
I'm
calling
the
batch
operation
called
insert
o
okay,
it's
the
same,
nothing
else,
and
then
we
are
recording
how
much
time
is
actually
taking
to
insert
those
operations
and
for
the
bug
I'm
using
the
real
bulk
operations.
C
Now
I'm
going
to
remove
this
one,
I'm
going
to
explain
this
one
later,
so
it's
very
important
and
it's
very
simple
and
on
the
dynamic
which
is
the
very
popular
in
an
arsenal
when
they
are
using
level
db.
We
are
using
this
one.
This
is
only
existing
on
this
orm
and
not
on
the
other
or,
and
so
this
one.
I
think
it's
a
bit
highlight
so
here.
C
The
way
how
we
actually
use
our
operations
is
that
if
we
have
rows
less
than
30
that
we
have
actually
look
at
it,
it
is
much
still
faster
compared
to
using
the
batch,
if
you're,
actually
putting
big
data
into
the
database,
something
like
200
columns
or
50
columns.
On
top
of
that,
and
it's
much
more
still
faster
iterating
it
rather
than
doing
a
batch
and
bulk
operations.
C
What
did
you
for
that,
and
here
I
actually
have
the
rows
count
here.
100
draws
I'm
inserting
and
then
I'm
calling
those
operations
and
I'm
showcasing
it
to
you
now.
Maybe
I'll
just
comment
this
one
and
then
I'm
going
to
showcase
it
later
where's
to
so.
I
would
like
to
share
to
you
the
difference
of
this
one.
So
now
I'm
actually
inserting
100
rows
each
right,
as
you
can
see
here
and
yeah,
and
then
I'm
recording
how
much
time
it
is
in
every
operations.
C
C
C
C
Atomic
is
11
seconds.
Batch
is
1.71
seconds,
but
bulk
is
point
44
seconds
and
lastly,
I'm
gonna
insert
something
like
maybe
thirty
thousand,
to
showcase
to
you,
maybe
twenty
thousand
yeah.
So
you
notice
the
difference
right
when
you
are
inserting
multiple
breakers
and
you
are
doing
an
atomic
like
dover
and
literature
framework.
They
are
becoming
very,
very
slow
right
and,
although
entity
framework
nowadays,
the
af
core
is
now
supporting
the
batch
operations.
It's
they're
doing
a
very,
very
big,
merge
statement
just
to
accommodate
this
request.
C
It's
only
repo
divi
and
llblj
of
franz
buma
is
doing
the
things
actually
about
the
batch,
but
they
are
not
supporting
the
bulk
you
can
see
earlier.
We
are
inserting.
1
thousand
records
is
zero
point.
Forty
four,
but
here
twenty
thousand
records
is
zero.
Point.
Thirty,
nine!
Let's
go
to
the
database,
so
I'm
not
deceiving
you!
It's
sixty
thousand
rows
here
available
because
this
twenty
thousand
roses
I
mean
twenty
thousand
each
has
been
inserted.
C
Imagine
that
join
certain
twenty
thousand
rows
less
than
one
second
right,
and
here
in
in
apps
in
our
organizations
we
are
actually
merging
information
from
one
system
to
another
system.
From
our
vendor's
database
to
what
our
database
internally
and
passes
on
to
the
amq
for
asynchronous
pattern,
for
example,
and
really
would
be
just
doing
the
things,
this
is
a
matter
of
the
lightning
fast
insertions
because
of
this
batch
operations,
and
here
I
can
see
what
happens
if
I'm
gonna
do
dynamic.
C
Actually,
the
dynamic
is
actually
the
one
that
does
know
what
and
what
method,
and
how
do?
I
call
it
something
like
that,
and
it's
just
know
itself
when
to
switch
into
this
three.
So
again,
if
you're
inserting
big
table
by
number
of
rows
dynamics,
I
mean
atomic
is
much
more
faster,
but
if
it
is
less
than
one
thousand,
it's
actually
a
batch
and
then
bulk
is
greater
than
one
thousand
or
equal
to
one
thousand
and
dynamic
knows
how
to
use
and
what
to
use
in
each
situation.
C
C
C
I'm
now
in
48
minutes
on
this
demo.
I
hope
I
have
demo
the
lot
now,
but
I
another
one
more
demo.
After
this
one,
so
targeted
operation
you
can
see
dynamic
operations
is
a
bit
faster
compared
to
them.
So
that's
how
it
is
and
also
would
like
to
highlight
what
happens
behind
the
scene.
If
we
are
doing
this
one,
I
will
explain
it.
I
am
going
to
open
a
profiler
here
on
my
sql
server.
C
Applications,
yes,
so
the
profiler
is
here,
though,
I'm
gonna
empty
that
one
and
now
I'm
gonna,
I'm
gonna
run.
I'm
gonna
run
the
the
atomic.
What
happened
so
I'm
inserting
100
draws
only
okay
super
hundred
draws
what
happened
behind
the
scene.
Now
you
can
see
that
it
creates
100,
insert
statement
right.
So
that's
because
it's
atomics
one
by
one
and
we
are
passing
the
correct
value
here
and
what
happened
behind
the
scenes
we
called
the
batch
so
in
the
batch
by
default,
it's
actually
batching
10.
C
It's
only
creating
10,
insert
statement,
10
round
trip
to
the
database
and
then
and
then
insert
those
and
match
those
property
alignment
based
on
the
sql
statement
that
has
been
generated.
As
you
can
see
here,
it's
only
created,
10
executions
right
and
then
and
then
this
is
it
and
then,
but
again,
I'm
going
to
clear
this
one
and
then
on
the
batch.
You
can
also
do
it
something
like
this.
I
don't
know
what
I
I
would
like
to
batch
size.
It
no
here,
of
course
the
do
batch.
C
C
You
can
see
that
here
it
only
created
to
insert
statement.
I
mean
two
run
crafts
against
the
database,
but
it
creates
a
lab.
I
mean
very,
very
big,
insert
statement.
You
can
see
here
right,
but
it's
because
it's
watching
I
mean
the
real
batching
of
the
informations
and
also
what
happens
if
I'm
gonna
do
the
bulk
operations?
C
Okay,
in
the
path
operations,
it
uses
the
real
bulk
operations.
I
mean
the
right
to
sql
server,
that's
using
those
yeah,
the
single
back
copy
of
sql
server,
utilizing
that
one
as
you
can
see.
Maybe
I'm
gonna,
I'm
gonna
what
happened
to
the
bob,
because
I
executed
the
dynamic,
but
I'm
going
to
do
the
bug
operations
again
clear
this
one.
You
can
see
what
happened
behind
the
scene
here,
it's
a
real
bug,
as
you
can
see,
there's
no
record
here!
C
That's
because
background
I
mean
sql
server,
transfer
the
files
as
a
stream
and
then
insert
it
back
to
that
table.
That's
why
it's
ignoring
everything
is
ignoring
the
constraint
after
the
primary
key
as
well.
If
you
are
actually
not
finding
that
properly,
it
will
be
ignored
things
like
that
by
the
watch.
That's
why
it's
very
very
fast,
so
that's
the
difference
between
the
three
okay
and
one
more
thing
that
I
would
like
to
highlight
in
the
back
and
the
batch
operations
here.
C
If
I
do
the
batch
operations,
you
can
see
here
and
then
now
now
I
stopped
the
I
stopped
the
profiler
you
can
see
if
you
do
the
batch
operation,
so
I
have
an
entity
of
100
that
I
had
created
here.
You
can
see
right,
that's
the
model,
but
it's
their
id
is
zero.
By
default
after
you
inserted
it,
the
id
will
be
set
back
to
you
if
that
is
actually
an
identity.
C
Otherwise
the
actual
id
will
be
resulted
back
to
you
if
that
is
not
an
identity
for
an
unclustered
environment,
for
example,
as
you
can
see
here
so
and
then,
if
you
go
to
the
bar
operations
here,
you
can
see,
the
bulk
operation
is
the
same,
and
then
you
can
see
here.
The
people
is
actually
not
not
does
not
have
an
id
yet,
and
if
you
do,
the
ins
about
insert
by
default
bulk
insert
is
not
doing
the
thing,
because
it's
very
impossible
for
you
to
get
the
information
from
the
database.
C
It's
called
copy
class
and
in
repo
db
you
have
an
option.
So
someone
is
return,
identity
and
what's
happening
behind
the
scene
on
this
one.
If
I'm
going
to
to
set
it
to
true,
you
can
see
here,
it's
actually
returning
the
record
for
you.
I
mean
at
least
those
id
automatically
and
how
that's
happened.
It's
impossible
to
do
it
in
the
watch
and
bug
operations
right
and
also
there's
another
tweak
here
that
something
like
use
should
a
temporary
table.
C
So
here
there's
a
switcher
there's
a
documentation
here
we
use
utilize
the
circle
bar
copy
and
then
write
to
server
method,
and
then
it's
return
identity.
If
known,
it's
directly
inserted
to
the
database
table
without
doing
anything.
But
if
it
is
yes,
I'm
going
to
use
physical
table
or
not.
If
it
is
yes,
then
I'm
going
to
create
an
actual
physical
table
in
your
database,
okay
and
utilize
that
one
and
if
it
is
no,
which
is
at
the
decision
base.
C
This
is
actually
the
temporary
table
hash
temp
table
that
is
decision
based
based
on
your
connection
and
then
it
will
not
gonna
create
the
physical
table,
but
it
will
still
use
that
one
and
then
it's
gonna
utilize,
both
of
them
to
use
the
insert
into
statement
into
the
whole
table
and
after
the
insert
into
statement
it
will
actually
return
the
identities
generated.
That's
why
we
have
to
retrieve
this
identity
through
this
technique.
C
C
So
I
I
want
I
want
to
do
a
profiling
for
this
one
and
just
showcase
to
you.
So
here
you
can
see
I'm
actually
returning
the
identity
and
I
want.
I
would
like
to
use
the
should
temporary
table
fiscal
table
here.
What
happens
when
this
end
after
that?
One,
okay,
repo
db
first
created
a
temporary
table
repo
db
order.
Call,
I
mean
repo
the
way
back
in
third
person.
C
This
is
the
temporary
table,
but
this
is
still
physical
table
because
it's
not
temporary
table
right,
and
this
is
only
copying
with
structure
and
then,
after
that,
one
repo
db
bulk
insert
into
this
table.
Okay
and
after
that,
one,
it's
merging
the
data
from
from
this
table
going
to
this
actual
table
and
then
returning
the
identity.
As
you
can
see
here,
output
identity
that
insert
that's
why
you
can
get
the
the
identity
and
then,
at
the
end
of
the
day,
we
will
drop
those
temp
physical
table.
C
Okay.
So
now,
if
I'm
going
to
use
something
like
this,
one
is
false,
which
is
the
default
one.
If
I'm
going
to
run
it
again,
as
you
can
see
here,
it's
the
same
thing,
but
here
you
can
see
that
it's
actually
excision
based
temporary
table.
It's
created
this
one
right,
it's
the
same,
but
here
you
can
see
that
this
decision
base.
It
means
that
if
I
open
connection
and
I'm
processing
multiple
entities
on
the
same
table,
I
can
still
have
multiple
ripple
db
insert
person
in
the
differentiation
base.
C
They
are
registered
differently
in
the
actual
temp
database
temp
database
of
the
sql
server.
It's
a
session
based.
So
if
the
connection
is
closed
automatically
this
is
deleted
and
the
purpose
of
this
one
is
to
give
you
an
opportunity
to.
If
you
think
you
are
not
running
a
parallelism,
use
physical
table
that
is
much
more
faster,
always
because
it's
actual
physical
table,
but
if
you
think
you're
running
multiple
insertion
bug
insertion
in
a
further
lesson
state.
C
You
know
you
know,
processing
together
the
data
using
the
same
table
then
use
the
position
based
temporary
table,
and
that's
actually
the
the
highlights
of
this
two
here
and
not
just
that.
It's
also
happening
in
the
bulk
merge,
the
bulk
delete
and
the
bulk
update
the
same
operations
here,
for
example,
so
some
of
them,
and
then
you
can
also
you
can
also
because
this
is
the
highlight
in
rival
db
and
that's
existing
with
the
other
orm,
and
you
can
also
just
trace
this
one
profile
this
one.
C
If
you
would
like
to-
and
the
last
feature
that
I
would
like
to
discuss
so
I
have
after
27
minutes
now
so,
but
the
last
feature
that
I
would
like
to
discuss
to
you
guys
is
the
dynamic
support
of
rival
db
and
again.
This
is
not
the
dynamic
in
a
sense
that
dynamic
in
that
net
ecosystem,
but
it's
actually
dynamic
in
a
context
of
an
orm.
I
mean
like
into
the
framework
you're
going
to
do
dynamic
approach
there
and
therefore
you're
going
to
do
that.
C
I
think
it's
only
rrm
light.
You
can
also
do
the
same
thing,
but
ripple
db
also
support
that.
So,
as
you
can
see
here
so
again,
I
installed
the
library
and
then
I
called
the
initialize
method
to
initialize
the
the
method,
and
then
I
created
each
method
here.
So
do
truncate
the
data
first,
you
can
see,
I
don't
have
the
model.
C
I
just
can't
get
the
table
person.
It's
the
same.
You
can
also
do
it
like
this.
It's
passing
your
model
right,
but
here
I
don't
have
the
model
truncate
the
person
and
then
insert
all
the
data
you
can
see
here
and
if
you
try
to
see
here,
there's
no
model,
it's
actually
dynamic
object,
it's
an
anonymous
type
right,
so
I'm
inserting
all
the
anonymous
type.
I
can
also
insert
specific
here.
I
can
also
just
target
specific
column.
I
don't
want
to
insert
an
address.
C
I
can
do
that
and
you
can
yes
and-
and
here
you
can
also
do
query
all
all
the
person
and
also
I
would
like
to
query
only
the
person
but
on
the
id
name,
and
I
can
also
do
the
query,
for
example,
the
the
data
in
in
the
database,
where
the
name
is
equals
to
this
one,
or
I
can
also
do
it
like
this
one,
which
is
update
the
data
that
has
an
id1,
and
I
also
do
a
merge
like
this.
Something
like
merge
the
person
using
this
new
dynamic.
C
This
is
only
the
name
and
address
and
then
I'm
using
the
qualifier
name
same
as
before,
and
then
also
do
an
update
like
that
so
id
one.
I
would
like
to
update
it
with
this
new
record
and
then
delete
it.
Delete
all
do
count
and
then
do
count.
All
is
the
same.
I'm
gonna
showcase
it
to
you.
So
I
will
add
a
breakpoint
here.
Let's
do
it
one
by
one.
C
So
now
I
have
to
generate
1000
people
and
then-
and
then
I
just
insert
all
of
that
one
and
then
I
can
see
that
I
have
a
1000
results
set
here.
That's
actually
1000
row
that
I
inserted
see
that
the
1000
row
has
been
inserted
here
and
I
can
also
just
simply
insert
honors
anderson
and
then
it
will
give
me
the
id
that
has
been
inserted.
That's
1001.!
C
C
And
just
of
course,
just
counting
the
records
from
that
and
then
query
all
the
data
hey.
This
is
a
bit
highlight
if
I'm
very
lazy
sometimes
and
then
I
have
been
asking.
If
you
know
what
can
you
integrate
this
data
to
this
data
database,
it's
much
easier
for
me
to
use
repo
db
rather
than
using
ssis
or
whatever
too,
because
I
just
create
source
connection,
destination,
connection,
query
and
then
back
insert
and
then
that's
it.
But
here
you
can
see.
C
C
So
this
first
one
is
also
queried,
and
I
can
also
merge
so
making
sure
that
okay,
the
name
thing
here
will
become
will
become
an
address.
We
can
get
denmark
and
then
I'm
going
to
create
that
one
again
and
then
you
can
see
that
it
is
often
updated
in
the
database.
If
you
go
here,
the
10
is
after
updated
in
the
database.
This
is
the
name
10
right,
the
11th
row,
of
course,
so
that's
it
and
then
do
update,
for
example,
the
first
column,
the
first
row.
C
I
would
like
to
update
the
name
to
address
this
one.
Of
course,
it's
only
targeting
certain
columns,
I
didn't
add
all
the
columns
here.
It's
only
touching
those
columns,
update
name
address
where
something
like
that
or
update
name
address
from
table
where
that's
only
the
statement
and
nothing
else,
and
it's
also
traceable.
If
you
are
passing
the
trace
object
and
if
I
query
those
one
you
can
see
here,
the
one
that
I
get
from
the
database
is
this
is
the
content
already
and
you
can
see
here
that.
C
No,
it's
not
responding
and
we
are
working
with
microsoft,
so
that's
really
happening
in
this
case.
You
can
see
here
the
the
one
is
michael
pendon
and
in
gantt
of
denmark
and
and
yes
of
course,
do
count.
I
also
mentioned
that
earlier,
so
you
can
just
simply
count
the
how
many,
how
many
requests
of
the
database
that
has
this
name
like
name,
you
can
see
that
it's
a
query
field.
It's
not
an
anonymous
object,
it's
not
a
type,
but
it's
actually
a
query
object.
So
it's
query
field
and
query
group.
C
You
can
also
pass
that
here
and
this
is
very
robust
because
you
can.
Oh,
this
is
the
most
fastest
way
of
doing
querying
the
things
from
the
from
the
database.
There's
a
lot
of
a
lot
of
things
there
and
they're
all
supported
as
well,
and
also,
if
I'm
going
to
query
that
one
you
can
see
that
the
result
is
actually
this
one.
You
can
see
all
the
like
data
in
the
database
name
10
like
so
you
can
see
here
so
it
has
been
queried
and
also
delete,
delete,
specific
informations.
C
You
can
see
without
me
having
the
model.
I
was
able
to
actually
manipulate
the
data
against
the
database
right,
so
that's
actually
the
technical
demo
out
of
it,
but
I
would
like
to
highlight,
as
well
still
have
11
minutes
here
so
repo
db
has
our
website
repodib.net
just
go
there
and
it
will
guide
you
what
where
to
start,
but
you
can
also
read
all
the
information,
sir.
It's
well
documented
and
and
get
started
yeah
each
each
database,
rdbms
that
is
being
supported,
has
its
own
get
started.
C
Page
features
that
you
would
like
to
play
around.
We
have
a
lot
of
features
here
that
has
not
been
discussed
expression,
trees.
Hence,
for
example
like
you
can
just
also
query
the
data
like
person
and
then
I
would
like
hints
with
tableau
or
you
can
just
simply
write
the
persons,
and
this
is
low
level
row
level,
isolation
level,
not
on
the
connection
level.
C
You
can
do
this,
unlike
the
other
order,
and
here
you
can
do
it
implicit
and
explicit
nothing,
the
one
that
I
have
to
showcase
to
you
before:
mapping
a
column,
identity,
primary
key
class
under
property,
understable
and
entity,
and
also
the
type
itself.
You
can
also
see
that.
Okay,
you
know
what
I
would
like
that
the
type
date
time
to
be
always
date
time
to
in
the
database.
C
C
Unit
of
work,
for
example,
is
nothing
it's
not
supported
by
rival
db,
but
we
have
a
references
so
that
you
can
implement
your
network
using
this
approach.
Things
like
that,
so
you
can
also
implement
it
on
your
own
and
releases,
of
course,
all
the
packages
of
repo
tvs
here
so
one
by
one.
We
actually
do
the
the
releases
updater
and
it's
very
active
because
I'm
pushing
everybody
to
be
always
into
the
into
the
nugget
package.
It's
a
nougat
page
and
also
the
blog
sir.
C
If
we
have
a
highlight
that
we
would
like
to
hear
so,
for
example,
announcing
the
version
12
1.5.
This
is
the
major
release
of
ripo
db,
that
supports
dynamic
into
the
bulk
operations
and,
of
course,
guys
also.
I
would
like
to
to
to
ask
your
supporter
just
start
the
the
repository
here
in
github
and
and
then
and
then
so
just
go
to
my
github
and
start
it
and
then
share
to
your
friends,
your
colleagues,
to
your
families,
to
your
to
you
to
to
whoever
you
would
like
to
share
it
actually.
C
Yes,
yes,
please
and,
and
lastly,
but
not
the
least,
I
would
like
to
highlight
that
I
am
in
collaboration
with
france.
Bulma
always
acted
the
creator
of
llblg
and
orm,
so
he
actually
already
put
a
ripple,
devious
part
of
the
venture,
which
is
the
most
official
I
mean
not
official,
but
maybe
something
like
near
official
benchmark
for
orr
and
worldwide
for
that
net
and
recently
I
have
made
an
update
in
riva
tv
and
for
the
first
time
everybody
we
bit
the
hand
coded
materializer,
so
we
are
the
fastest.
C
Ever
we
have
beaten
it,
and
then
francois
told
me
that
how
did
you
do
that
mike?
You
are
now
again
cheating?
No!
No.
I
think
I
explained
to
him
that
I
made
additional
compilations
in
the
anonymous
ties
to
beat
this
one.
So
historically,
we
cannot
beat
that
one
and
there's
also
instance
for
the
for
the
last
two
years.
C
We
are
always
the
fastest
orm,
as
you
can
see
here,
just
right
behind
this
uncoded,
and
we
cannot
beat
that
one
and
recently
I
made
a
mistake
on
my
update
and
then
and
then
link
you
db,
actually
beating
us
on
this
one.
I
guess
there's
an
instance
of
the
lego
db
beat
us,
but
eventually
here
in
the
net
5,
we
are
for
the
fastest
and
the
most
efficient,
rm
and
uppers
up
here.
So
it's
it's
a
bit
slower
compared
to
the
other.
Here.
There's
a
lot-
and
here
are
also
the
efficiency.
C
We
are
the
most
efficient
just
right
after
the
hand,
code
materializer.
Imagine
the
factory
declared
variable
var
one.
There
is
no
logic,
that's
uncoded,
but
in
repo
db,
something
like
var
get
one
you
we
put
a
method
on
top
of
that.
So
inside
the
get
one
method,
that's
the
memory
that
we
are
using
and
also
that's
the
performance
that
we
are
aiming
here
during
the
compilations.
C
He's
actually
a
contributor
here
so
brad,
the
bringer,
yeah,
granger
and
also
simon
craft,
is
also
a
contributor.
I
mean
it's
a
very
popular
open
source.
You
know,
guy
he's,
also
a
contributor
here
so
and
he's
using
river
diving
thanks
for
that
same
one
and
also
last,
but
not
the
least
scott
hanselmann.
Also,
if
you
didn't
know
it
yet,
scott
hanselman
also
tried
to
make
a
blog,
which
you
can
also
try
to
revisit,
maybe
and
start
from
there.
C
And
the
trends
of
rival
db,
I
I
started
2018
for
the
first
two
years
that
I
am
actually
stabilizing.
Remo
tv
is
not
open
to
the
public.
Maybe
I
started
communicating
it
to
the
reader,
but
not
to
the
public
and
for
the
first
two
years
we
only
have
twenty
thousand
download
started.
Last
year
we
actually
opened
it
up,
and
then
scott
hanselman
also
tried
to
make
a
blog
here
around
july,
and
you
can
see
that,
for
the
less
than
one
year
we
have
downloaded
around
130
000
downloads.
C
A
A
Yeah
you're
you're,
absolutely
welcome
and,
and
actually
just
sure,
showcasing
it
to
to.
You
know
the
world,
our
viewers,
so
we
I
think
we
have
a
few
viewers
who
are
not
from
the
philippines,
so
thank
you
to
them
as
well
and
and
it's
a
great
opportunity
to
show
it
to
them.
We
do
have
some
questions.
Well,
we
do
have
questions
from
several
questions
from
georgia.
Aquino
on
on
on
this.
So
just
just
going
through
that
there's
a
lot
of
features.
C
Yeah,
the
major
assembly
is
repo
db.core.
Those
feature
mostly
reside
on
the
repo
divided
core,
so
tracing
caching
and
and
everything
else.
The
batch
operations
there
is
a
package
called
ripple
db
that
sql
server
rebooted.
With
that
my
sequel
circle,
light
and
postgre,
for
example,
they
are
just
any.
They
are
just
an
extensibility
features.
C
A
C
C
So
so,
if
you're
using
a
repository,
you
can
invalidate
the
cache
simply
just
this
that
cache
and
clear.
If
you
would
like
to
clear
all
the
cache,
but
if
you
would
like
to
just
specifically
remove
specific
cash,
for
example,
and
just
remove
the
people
here,
the
one
that
I
actually
cash
before,
so
you
can
invalidate
it.
C
So
you
control
the
validations
and
I
will
never
introduce
the
auto
validation
or
whatever
auto
invalidation
of
the
cache
in
revo
devi,
because
it's
very
extensive
and
I
would
like
to
make
the
body
be
a
bit
lightweight
more
on
the
area
of
micro
r
and
rather
than
big,
o
rm.
So
that's
the
reason
there
are
people
requesting
it,
but
I
cannot
do
it
for
this.
For
us.
C
C
C
Okay
and
then,
but
there's
also
an
equivalent
alternative
solutions
and
every
limitations-
and
I
explained
it
well
there.
So
I
think
it's
better
to
read
these
limitations
before
you
use
this
library
so
that
you
would
know
this
is
everybody
we
could
not
something
like
do
composite
key
or
could
not
do
something
like
auto
calculated
columns.
Something
like
that.
A
All
right,
thank
you
for
that.
Maybe
I
have
my
I
have.
I
actually
have
my
own
own
questions
that
I'd
like
to
ask
so
so
so
yeah,
because
I
think
you
extensively
use
bulk
insert
in
your
in
in
I
mean
that's
at
least
that
those
are
some
of
the
key
features.
Are
they
I
I
mean
I
would
expect
that
it's
available
for
sql
server
right,
but
I'm
not
sure
what
other?
What
other
databases
are?
Are
you
able
to
do
bulk
inserts
in
or
use.
C
C
So,
but
maybe
it's
a
bit
critical,
that's
why
I
need
to
be
still
the
architect
on
this
on
this
area
when
it
comes
to
implementation
of
this
bulk
insertions
in
postgre,
and
if
there's
somebody
from
the
community
open
up,
they
contribute.
I
also
it's
also
welcome,
but
I
think
I
still
need
to
architect
the
way
how
it's
been
implemented
to
just
to
just
align
the
way
I
mean
the
experience,
how
simple
it
is
to
use
it.
C
A
A
C
A
C
A
C
C
Yes
here
so
here
you
can
see,
for
example,
on
the
on
the
references
I
created
something
like
json
cache
and
here-
and
this
is
actually
the
consolidated
restart
tonight.
So
so
you
can
see
here,
I
created
my
own,
I
cache
and
we
got.
I
called
it.
Json
cache
and
implemented
the
I
cache
attribute
here
I
mean
interfacer
and
actually
handling
all
my
caching
via
file,
and
then
I
inject
it
in
reboot
db.
Something
like
this.
A
A
A
But
but
yeah
and
those
I,
I
love
the
use
case
that
you
said
that
that
instead
of
having
to
make
you
know
having
to
make
an
ssis
a
package
instead
of
for
for
for
etl,
you
could
just
type
up
a
quick
epl
for
we're,
using
bulk,
insert
and
and
and
sis
use
this
multi
search
anyway
for
for
quick
transformation.
So
yeah,
that's
totally
awesome.
I
just
have
to
say
all
right,
any
any
final
words
for
us
or
any
final
things
that
you
could
share
to
everyone
here.
C
Yeah,
I
think
I
already
made
my
statement
on
that
before
I
actually
ended
up
my
demo,
so
just
please
support
repudiate,
share
it
to
your
friends,
colleagues
and
and
again
guys,
I'm
not
making
money
here
so
whether
there's
sponsorship,
it's
still
not
I'm
not
making
money
out
of
it
and
right
now,
it's
not
yet
integrated
with
the
other
company
and
also
not
yet
I
didn't
bring
it
to
the
that
foundation
yet
and
also
to
the
to
the
jetbrains
villagers.
They
have
conducted
some
of
it,
but
I'm
not.
C
A
So
I'd
like
to
thank
you
mike,
thank
you
for
sharing
us
this
th.
You
know
this.
This
is
such
an
awesome
project.
Thank
you
and,
and
and
it's
great
to
know
that
there
are
there
is
an
alternative
orm
out
there,
that
that
would
that
that
we
could
consider
that
has
some
features
that
are
unique
and
and
and-
and
we
appreciate
that
and
we'll
yeah
personally
and
yeah
do
do
our
best
to
support
you
in
your
anniversary.
Good
luck!
Thank
you
for
being
here.
A
Yes,
thank
you
so
much
and
have
a
good
day.
Everyone
all
right!
Thank
you
so
much
mike,
so,
okay,
so
that
ends.
That
concludes
our
fenug
dev
sessions.
For
for
tonight.
I
hope
you
enjoyed
that.
It
was
learned
really
a
lot
tonight
and
again.
Let
me
take
this
opportunity
to
thank
the.net
foundation,
the
virtual.net
users
group
for
for
hosting
this
event,
so
so
yeah
follow
our
meetup
group.
That's
that's!
Meetup.Com!
Look
for
fino!
P!
H!
I
n!
U
g!