Up next in 10
Leveraging Azure Tables with Azure Functions - Azure Essentials Series - Ep: 1
0 views
Aug 6, 2025
In this episode, we'll delve into how Azure Tables, a NoSQL data storage solution, can be seamlessly integrated with Azure Functions, Microsoft's serverless compute service, to build efficient and scalable cloud applications. During the episode, we'll cover: • An introduction to Azure Tables and its key features for storing structured data in the cloud • Understanding the benefits of using Azure Functions for event-driven computing and serverless execution • Exploring common scenarios where Azure Tables and Azure Functions work together seamlessly • Best practices for designing and implementing Azure Functions to interact with Azure Tables • Real-world examples showcasing the flexibility and scalability of this integration across various use cases Whether you're a developer, data engineer, or cloud architect, this episode will provide you with valuable insights and practical guidance on harnessing the power of Azure Tables with Azure Functions to build modern, event-driven applications in the cloud. Don't miss out on this informative session packed with demos, tips, and best practices! 📺 CSharp TV - Dev Streaming Destination http://csharp.tv 🌎 C# Corner - Community of Software and Data Developers https://www.c-sharpcorner.com/ #Azure #AzureShow #CSharpTV #LiveShow #AzureEssentils #AzureFunction #AzureTable
View Video Transcript
0:02
[Music]
0:19
[Music]
0:36
hello guys welcome to my show aure
0:39
hello guys welcome to my show aure
0:39
hello guys welcome to my show aure Essentials so this is episode first of
0:42
Essentials so this is episode first of
0:42
Essentials so this is episode first of my show my name is habibu ran I a
0:45
my show my name is habibu ran I a
0:45
my show my name is habibu ran I a Microsoft certified solution developer
0:48
Microsoft certified solution developer
0:48
Microsoft certified solution developer uh I also cop Corner
0:50
uh I also cop Corner
0:50
uh I also cop Corner MVP uh currently I'm working as a
0:53
MVP uh currently I'm working as a
0:53
MVP uh currently I'm working as a fullstack developer I have seven plus
0:55
fullstack developer I have seven plus
0:55
fullstack developer I have seven plus years of professional development
0:57
years of professional development
0:57
years of professional development experience so I will be uh hosting this
1:00
experience so I will be uh hosting this
1:00
experience so I will be uh hosting this show uh every Saturday Okay so let's
1:04
show uh every Saturday Okay so let's
1:04
show uh every Saturday Okay so let's start
1:08
this okay so this is the agenda of our
1:12
this okay so this is the agenda of our
1:12
this okay so this is the agenda of our show uh first of all we will talk about
1:15
show uh first of all we will talk about
1:15
show uh first of all we will talk about aure tables uh then integration with
1:18
aure tables uh then integration with
1:18
aure tables uh then integration with Azure functions and after all we will
1:21
Azure functions and after all we will
1:21
Azure functions and after all we will discuss few real word use cases uh we
1:24
discuss few real word use cases uh we
1:24
discuss few real word use cases uh we will also Implement uh we will also
1:27
will also Implement uh we will also
1:27
will also Implement uh we will also Implement uh this in vew studio so that
1:29
Implement uh this in vew studio so that
1:29
Implement uh this in vew studio so that you guys can learn how to uh leverage a
1:32
you guys can learn how to uh leverage a
1:32
you guys can learn how to uh leverage a zero tables and at the end we will have
1:35
zero tables and at the end we will have
1:35
zero tables and at the end we will have a QA session and network session so
1:38
a QA session and network session so
1:38
a QA session and network session so let's start this first of all uh what is
1:42
let's start this first of all uh what is
1:42
let's start this first of all uh what is aure table storage so basically aure
1:46
aure table storage so basically aure
1:46
aure table storage so basically aure table storage is a nosql data storage uh
1:50
table storage is a nosql data storage uh
1:50
table storage is a nosql data storage uh with schema less and it's uh keybase
1:53
with schema less and it's uh keybase
1:54
with schema less and it's uh keybase data storage it's very flexible to use
1:57
data storage it's very flexible to use
1:57
data storage it's very flexible to use and it is designed for scalability by
2:00
and it is designed for scalability by
2:00
and it is designed for scalability by Microsoft uh it can handle large volume
2:03
Microsoft uh it can handle large volume
2:03
Microsoft uh it can handle large volume of data with million of transactions per
2:06
of data with million of transactions per
2:06
of data with million of transactions per second it's a very cost effective
2:09
second it's a very cost effective
2:09
second it's a very cost effective solution uh you can use it very cheaper
2:12
solution uh you can use it very cheaper
2:12
solution uh you can use it very cheaper for lost produ projects it's very high
2:15
for lost produ projects it's very high
2:15
for lost produ projects it's very high performance it provides uh a million of
2:20
performance it provides uh a million of
2:20
performance it provides uh a million of transactions per second it provide a
2:22
transactions per second it provide a
2:22
transactions per second it provide a very quick lookup uh it's also a
2:25
very quick lookup uh it's also a
2:25
very quick lookup uh it's also a flexible data model as it's a nosql data
2:28
flexible data model as it's a nosql data
2:28
flexible data model as it's a nosql data model so it can handle any type of data
2:32
model so it can handle any type of data
2:32
model so it can handle any type of data variations uh it's very easy to
2:35
variations uh it's very easy to
2:35
variations uh it's very easy to integrate with Azure ecosystem uh it
2:37
integrate with Azure ecosystem uh it
2:38
integrate with Azure ecosystem uh it provides a seamless integration and then
2:40
provides a seamless integration and then
2:40
provides a seamless integration and then it's high available High availability
2:44
it's high available High availability
2:44
it's high available High availability means as your provide us GE redundant
2:47
means as your provide us GE redundant
2:47
means as your provide us GE redundant locations and it will be available 247
2:50
locations and it will be available 247
2:50
locations and it will be available 247 for you and it is very easy to manage by
2:54
for you and it is very easy to manage by
2:54
for you and it is very easy to manage by aure portal or you can use uh rest apis
2:57
aure portal or you can use uh rest apis
2:58
aure portal or you can use uh rest apis for managing these databases
3:00
for managing these databases
3:00
for managing these databases uh next we have few pros and cons of
3:03
uh next we have few pros and cons of
3:03
uh next we have few pros and cons of asure table storage first of all the
3:06
asure table storage first of all the
3:06
asure table storage first of all the main Pro of uh Azure table storage is uh
3:10
main Pro of uh Azure table storage is uh
3:10
main Pro of uh Azure table storage is uh scalability Azure table is uh on massive
3:14
scalability Azure table is uh on massive
3:14
scalability Azure table is uh on massive scale it can handle uh a lot of data it
3:17
scale it can handle uh a lot of data it
3:17
scale it can handle uh a lot of data it can handle massive data like u in GBS or
3:21
can handle massive data like u in GBS or
3:21
can handle massive data like u in GBS or in terabytes also it provide automatic
3:25
in terabytes also it provide automatic
3:25
in terabytes also it provide automatic partitioning whenever you are storing
3:27
partitioning whenever you are storing
3:27
partitioning whenever you are storing your data inside as your uh table
3:30
your data inside as your uh table
3:30
your data inside as your uh table it automatically partition your data for
3:32
it automatically partition your data for
3:32
it automatically partition your data for better
3:33
better
3:33
better Cur it is also cost effective as you'll
3:36
Cur it is also cost effective as you'll
3:36
Cur it is also cost effective as you'll provide you uh pay as you go plans uh so
3:40
provide you uh pay as you go plans uh so
3:40
provide you uh pay as you go plans uh so you can pay as you are using uh the data
3:44
you can pay as you are using uh the data
3:44
you can pay as you are using uh the data uh it also handle large data sets in
3:47
uh it also handle large data sets in
3:47
uh it also handle large data sets in very uh low price it is very high
3:50
very uh low price it is very high
3:50
very uh low price it is very high performance database it provide a very
3:52
performance database it provide a very
3:52
performance database it provide a very quick lookup uh the data latency is very
3:55
quick lookup uh the data latency is very
3:56
quick lookup uh the data latency is very low so it's very good uh for cloud
4:00
low so it's very good uh for cloud
4:00
low so it's very good uh for cloud F database systems uh then it's flexible
4:03
F database systems uh then it's flexible
4:03
F database systems uh then it's flexible as it's no SQL database you can store
4:06
as it's no SQL database you can store
4:06
as it's no SQL database you can store your data inside your key attribute uh
4:09
your data inside your key attribute uh
4:09
your data inside your key attribute uh types it's schema less it's very
4:12
types it's schema less it's very
4:12
types it's schema less it's very adoptable in any project uh it's
4:15
adoptable in any project uh it's
4:15
adoptable in any project uh it's integration is very easy uh in
4:18
integration is very easy uh in
4:18
integration is very easy uh in especially in Azure ecosystem you want
4:21
especially in Azure ecosystem you want
4:21
especially in Azure ecosystem you want to integrate with is azure functions or
4:23
to integrate with is azure functions or
4:23
to integrate with is azure functions or you want to integrate with any net
4:25
you want to integrate with any net
4:25
you want to integrate with any net application it's very easy to use uh as
4:28
application it's very easy to use uh as
4:28
application it's very easy to use uh as your provide building SD is and also
4:31
your provide building SD is and also
4:31
your provide building SD is and also provide rest apis for communication so
4:33
provide rest apis for communication so
4:33
provide rest apis for communication so you can use any of them and then the
4:36
you can use any of them and then the
4:36
you can use any of them and then the availability aure table storage uh can
4:40
availability aure table storage uh can
4:40
availability aure table storage uh can be uh distributed globally and it is Al
4:44
be uh distributed globally and it is Al
4:44
be uh distributed globally and it is Al it also provide a redundency option
4:46
it also provide a redundency option
4:46
it also provide a redundency option which means uh you can create uh
4:50
which means uh you can create uh
4:50
which means uh you can create uh duplication of your aure table on
4:52
duplication of your aure table on
4:52
duplication of your aure table on multiple regions so if any uh one of the
4:56
multiple regions so if any uh one of the
4:56
multiple regions so if any uh one of the region goes down you don't have to be
4:58
region goes down you don't have to be
4:58
region goes down you don't have to be worried about your D
5:00
worried about your D
5:00
worried about your D so this is all about the pros of aure
5:03
so this is all about the pros of aure
5:03
so this is all about the pros of aure tables uh next we have a few cons of
5:07
tables uh next we have a few cons of
5:07
tables uh next we have a few cons of aure table cury limitations uh there are
5:11
aure table cury limitations uh there are
5:11
aure table cury limitations uh there are uh very few uh cury limitations on aure
5:14
uh very few uh cury limitations on aure
5:14
uh very few uh cury limitations on aure table storage uh for example uh you want
5:17
table storage uh for example uh you want
5:17
table storage uh for example uh you want to put a group by or you want to put uh
5:21
to put a group by or you want to put uh
5:21
to put a group by or you want to put uh any aggregate function uh that is not
5:24
any aggregate function uh that is not
5:24
any aggregate function uh that is not possible in Azure table storage uh in
5:27
possible in Azure table storage uh in
5:27
possible in Azure table storage uh in aure table storage you first have to
5:29
aure table storage you first have to
5:30
aure table storage you first have to cury your data and then you can apply
5:32
cury your data and then you can apply
5:32
cury your data and then you can apply all these functions so these are few
5:34
all these functions so these are few
5:34
all these functions so these are few cury limitations as uh compared to SQL
5:38
cury limitations as uh compared to SQL
5:38
cury limitations as uh compared to SQL databases uh then we have partition
5:41
databases uh then we have partition
5:41
databases uh then we have partition scans uh so if you will uh search any
5:45
scans uh so if you will uh search any
5:45
scans uh so if you will uh search any data Insite as your table it will scan
5:48
data Insite as your table it will scan
5:48
data Insite as your table it will scan that specific data from all available
5:51
that specific data from all available
5:51
that specific data from all available partitions okay so which will uh cost
5:54
partitions okay so which will uh cost
5:54
partitions okay so which will uh cost you a lot of time and it will uh
5:58
you a lot of time and it will uh
5:58
you a lot of time and it will uh decrease the performance of your data
6:00
decrease the performance of your data
6:00
decrease the performance of your data next we have consistency eventual
6:02
next we have consistency eventual
6:02
next we have consistency eventual consistency whenever you add or create
6:05
consistency whenever you add or create
6:05
consistency whenever you add or create or update any data inside as your table
6:07
or update any data inside as your table
6:07
or update any data inside as your table it is uh uh it is replicated on multiple
6:12
it is uh uh it is replicated on multiple
6:12
it is uh uh it is replicated on multiple Origins at the same time okay which
6:14
Origins at the same time okay which
6:15
Origins at the same time okay which means if anyone is accessing the data
6:18
means if anyone is accessing the data
6:18
means if anyone is accessing the data there may be issue with the Integrity of
6:20
there may be issue with the Integrity of
6:20
there may be issue with the Integrity of data so this is one of the main uh cones
6:25
data so this is one of the main uh cones
6:25
data so this is one of the main uh cones of aure table next we have limited
6:27
of aure table next we have limited
6:27
of aure table next we have limited concurrency sport
6:30
concurrency sport
6:30
concurrency sport uh as you know that in U uh other
6:33
uh as you know that in U uh other
6:33
uh as you know that in U uh other databases we have a very good currency
6:35
databases we have a very good currency
6:35
databases we have a very good currency sport but in uh a your SQL if uh two uh
6:40
sport but in uh a your SQL if uh two uh
6:40
sport but in uh a your SQL if uh two uh users are adding uh the same data at the
6:43
users are adding uh the same data at the
6:43
users are adding uh the same data at the same time this may uh create few
6:46
same time this may uh create few
6:46
same time this may uh create few conflicts and you have to manage them
6:48
conflicts and you have to manage them
6:48
conflicts and you have to manage them with view few rules uh but those rules
6:51
with view few rules uh but those rules
6:51
with view few rules uh but those rules are very limited then we have uh
6:53
are very limited then we have uh
6:53
are very limited then we have uh complexity in design as this is a nosql
6:56
complexity in design as this is a nosql
6:57
complexity in design as this is a nosql database so data mod is a little bit
7:00
database so data mod is a little bit
7:00
database so data mod is a little bit complex and challenging and you have to
7:03
complex and challenging and you have to
7:03
complex and challenging and you have to be very careful when designing the data
7:07
be very careful when designing the data
7:07
be very careful when designing the data then we have future
7:09
then we have future
7:09
then we have future limitations uh as your table uh provide
7:12
limitations uh as your table uh provide
7:12
limitations uh as your table uh provide no transaction across partition you can
7:15
no transaction across partition you can
7:15
no transaction across partition you can apply partition uh inside same uh inside
7:19
apply partition uh inside same uh inside
7:19
apply partition uh inside same uh inside same uh partition but you cannot uh
7:22
same uh partition but you cannot uh
7:22
same uh partition but you cannot uh apply transaction on different
7:24
apply transaction on different
7:24
apply transaction on different partitions of aure table so this is uh
7:27
partitions of aure table so this is uh
7:27
partitions of aure table so this is uh one
7:28
one
7:28
one limitation uh then we we have uh limited
7:31
limitation uh then we we have uh limited
7:31
limitation uh then we we have uh limited community and third party sport uh
7:33
community and third party sport uh
7:33
community and third party sport uh currently I think so as compared to uh
7:35
currently I think so as compared to uh
7:35
currently I think so as compared to uh Microsoft SQL server and other database
7:38
Microsoft SQL server and other database
7:38
Microsoft SQL server and other database Technologies uh aure table have very
7:41
Technologies uh aure table have very
7:41
Technologies uh aure table have very limited support and community so this
7:44
limited support and community so this
7:44
limited support and community so this may be an issue for you uh next we have
7:49
may be an issue for you uh next we have
7:49
may be an issue for you uh next we have maintenance uh sometimes when we are
7:51
maintenance uh sometimes when we are
7:51
maintenance uh sometimes when we are inserting data inside our aure table
7:54
inserting data inside our aure table
7:54
inserting data inside our aure table storage and data is growing day by day
7:56
storage and data is growing day by day
7:56
storage and data is growing day by day and at the end we may face uneven
8:00
and at the end we may face uneven
8:00
and at the end we may face uneven distribution of data in AO table
8:02
distribution of data in AO table
8:03
distribution of data in AO table partitions so this requires proper
8:06
partitions so this requires proper
8:06
partitions so this requires proper maintenance and check and balance and
8:09
maintenance and check and balance and
8:09
maintenance and check and balance and then we have to manually partitions uh
8:11
then we have to manually partitions uh
8:12
then we have to manually partitions uh the AZ table data so this is one reason
8:15
the AZ table data so this is one reason
8:15
the AZ table data so this is one reason for
8:16
for
8:16
for that uh then there are a few real world
8:19
that uh then there are a few real world
8:19
that uh then there are a few real world cases where we can use a your tables one
8:23
cases where we can use a your tables one
8:23
cases where we can use a your tables one is iot data integration and storage uh
8:27
is iot data integration and storage uh
8:27
is iot data integration and storage uh scenario is for example you you have a
8:29
scenario is for example you you have a
8:29
scenario is for example you you have a lot of iot devices uh which are sending
8:33
lot of iot devices uh which are sending
8:33
lot of iot devices uh which are sending uh different Telemetry data uh so you
8:36
uh different Telemetry data uh so you
8:36
uh different Telemetry data uh so you want a solution where your iot iot
8:39
want a solution where your iot iot
8:39
want a solution where your iot iot devices can send data uh seamlessly uh
8:44
devices can send data uh seamlessly uh
8:44
devices can send data uh seamlessly uh with very uh low response time so then
8:47
with very uh low response time so then
8:47
with very uh low response time so then uh here you can use aure tables so what
8:50
uh here you can use aure tables so what
8:50
uh here you can use aure tables so what you can do you can create aure functions
8:52
you can do you can create aure functions
8:52
you can do you can create aure functions which will uh process the incoming data
8:55
which will uh process the incoming data
8:55
which will uh process the incoming data and then you can store that data inside
8:58
and then you can store that data inside
8:58
and then you can store that data inside as your table storage
9:00
as your table storage
9:00
as your table storage uh so in this way even you have million
9:02
uh so in this way even you have million
9:02
uh so in this way even you have million of iot devices uh then this uh solution
9:07
of iot devices uh then this uh solution
9:07
of iot devices uh then this uh solution can handle your problem next we have
9:09
can handle your problem next we have
9:09
can handle your problem next we have user profile management for example you
9:12
user profile management for example you
9:12
user profile management for example you have you are working on a project and
9:14
have you are working on a project and
9:14
have you are working on a project and you want to manage user profiles in a
9:16
you want to manage user profiles in a
9:16
you want to manage user profiles in a web application then you you can use
9:18
web application then you you can use
9:18
web application then you you can use Azure table you can uh create aure uh
9:22
Azure table you can uh create aure uh
9:22
Azure table you can uh create aure uh functions with HTTP trigger which will
9:25
functions with HTTP trigger which will
9:25
functions with HTTP trigger which will handle your data and you can perform CR
9:27
handle your data and you can perform CR
9:27
handle your data and you can perform CR operation on your AO table storage so
9:31
operation on your AO table storage so
9:31
operation on your AO table storage so there are a lot of you use cases you can
9:33
there are a lot of you use cases you can
9:33
there are a lot of you use cases you can do and two of them was that okay so now
9:39
do and two of them was that okay so now
9:39
do and two of them was that okay so now our next session is uh moving toward the
9:43
our next session is uh moving toward the
9:43
our next session is uh moving toward the real word uh programming so now I'm
9:47
real word uh programming so now I'm
9:47
real word uh programming so now I'm going to share my
9:49
going to share my
9:49
going to share my screen uh let me share
9:56
that okay I hope you can my screen uh
10:01
that okay I hope you can my screen uh
10:01
that okay I hope you can my screen uh now let's go to V Studio I have
10:03
now let's go to V Studio I have
10:03
now let's go to V Studio I have installed V Studio
10:07
installed V Studio
10:07
installed V Studio 2022 so let's create a new project Habib
10:12
2022 so let's create a new project Habib
10:12
2022 so let's create a new project Habib sorry to interrup we can see your
10:15
sorry to interrup we can see your
10:15
sorry to interrup we can see your streamyard but we don't see your Visual
10:17
streamyard but we don't see your Visual
10:17
streamyard but we don't see your Visual Studio you see we see
10:20
Studio you see we see
10:20
Studio you see we see your let me share it again maybe some
10:24
your let me share it again maybe some
10:24
your let me share it again maybe some technical issue
10:34
okay now I have shared my full screen
10:35
okay now I have shared my full screen
10:35
okay now I have shared my full screen can you see
10:40
now yes I can maybe you want to click on
10:43
now yes I can maybe you want to click on
10:43
now yes I can maybe you want to click on that height popup the popup in the PO it
10:45
that height popup the popup in the PO it
10:45
that height popup the popup in the PO it says hide yeah yeah you're good to
10:48
says hide yeah yeah you're good to
10:48
says hide yeah yeah you're good to go okay that's great okay first of all
10:52
go okay that's great okay first of all
10:52
go okay that's great okay first of all we need to create a new project and that
10:55
we need to create a new project and that
10:55
we need to create a new project and that project will be as your functions Okay
10:58
project will be as your functions Okay
10:58
project will be as your functions Okay so click on next button uh I need to put
11:02
so click on next button uh I need to put
11:02
so click on next button uh I need to put any name for this project I will create
11:04
any name for this project I will create
11:04
any name for this project I will create this project with name episode one uh so
11:07
this project with name episode one uh so
11:07
this project with name episode one uh so that I can track my all episode codes
11:10
that I can track my all episode codes
11:10
that I can track my all episode codes and I will push this code on my GitHub
11:13
and I will push this code on my GitHub
11:13
and I will push this code on my GitHub so that everyone can access this uh
11:16
so that everyone can access this uh
11:16
so that everyone can access this uh click on next
11:18
click on next
11:18
click on next button uh VI studio is creating the
11:20
button uh VI studio is creating the
11:20
button uh VI studio is creating the project okay next option is uh framework
11:24
project okay next option is uh framework
11:24
project okay next option is uh framework worker so there are a lot of options
11:26
worker so there are a lot of options
11:26
worker so there are a lot of options available but I will be going with
11:29
available but I will be going with
11:29
available but I will be going with net8 because net 8 uh is the currently
11:34
net8 because net 8 uh is the currently
11:34
net8 because net 8 uh is the currently available long-term score project and in
11:37
available long-term score project and in
11:37
available long-term score project and in net 8 aure functions work in isolated
11:41
net 8 aure functions work in isolated
11:41
net 8 aure functions work in isolated process so we are going to use isolated
11:44
process so we are going to use isolated
11:44
process so we are going to use isolated worker process model next uh it is
11:47
worker process model next uh it is
11:47
worker process model next uh it is asking me for the first function with
11:49
asking me for the first function with
11:49
asking me for the first function with which HTTP Trigger or with which
11:53
which HTTP Trigger or with which
11:53
which HTTP Trigger or with which function type you want to create so I
11:55
function type you want to create so I
11:55
function type you want to create so I want to create an HTTP trigger so I will
11:58
want to create an HTTP trigger so I will
11:58
want to create an HTTP trigger so I will select this and and then there is an
12:00
select this and and then there is an
12:00
select this and and then there is an option for a your right for runtime
12:02
option for a your right for runtime
12:02
option for a your right for runtime storage as I'm uh developing this
12:05
storage as I'm uh developing this
12:05
storage as I'm uh developing this solution inside my V studio so I will be
12:07
solution inside my V studio so I will be
12:07
solution inside my V studio so I will be using Azure simulator so you check this
12:10
using Azure simulator so you check this
12:10
using Azure simulator so you check this uh option otherwise uh you can use your
12:13
uh option otherwise uh you can use your
12:13
uh option otherwise uh you can use your Azure uh storage account uh from aure
12:16
Azure uh storage account uh from aure
12:16
Azure uh storage account uh from aure panel
12:18
panel
12:18
panel so next we have authorization level uh
12:21
so next we have authorization level uh
12:21
so next we have authorization level uh whether we want to authorize our
12:22
whether we want to authorize our
12:22
whether we want to authorize our function at function level or at
12:25
function at function level or at
12:25
function at function level or at Anonymous level so for now I'm going to
12:27
Anonymous level so for now I'm going to
12:27
Anonymous level so for now I'm going to select function uh let's create this
12:32
project okay uh project have been
12:36
project okay uh project have been
12:36
project okay uh project have been created and now you can see that episode
12:39
created and now you can see that episode
12:39
created and now you can see that episode one project uh if I go through uh this
12:44
one project uh if I go through uh this
12:44
one project uh if I go through uh this uh project the basic files first of all
12:47
uh project the basic files first of all
12:47
uh project the basic files first of all I have program. CS file uh this is the
12:50
I have program. CS file uh this is the
12:50
I have program. CS file uh this is the entry point for my function when I will
12:53
entry point for my function when I will
12:53
entry point for my function when I will run my function uh so first of all it is
12:56
run my function uh so first of all it is
12:56
run my function uh so first of all it is uh setting the host Builder then
12:59
uh setting the host Builder then
12:59
uh setting the host Builder then configuring web applications so these
13:01
configuring web applications so these
13:01
configuring web applications so these are uh buildin functions extension
13:04
are uh buildin functions extension
13:04
are uh buildin functions extension functions provided by Microsoft uh then
13:07
functions provided by Microsoft uh then
13:07
functions provided by Microsoft uh then it's adding the uh support for uh
13:10
it's adding the uh support for uh
13:10
it's adding the uh support for uh Telemetry insights and then
13:13
Telemetry insights and then
13:13
Telemetry insights and then uh configuring the application inside so
13:16
uh configuring the application inside so
13:16
uh configuring the application inside so this is uh the entry point of my
13:19
this is uh the entry point of my
13:19
this is uh the entry point of my function uh then if I see we have uh
13:23
function uh then if I see we have uh
13:23
function uh then if I see we have uh local settings. Json uh you can use any
13:27
local settings. Json uh you can use any
13:27
local settings. Json uh you can use any uh Json settings inside this you can
13:29
uh Json settings inside this you can
13:29
uh Json settings inside this you can store
13:30
store
13:30
store here and then we have our function so
13:36
here and then we have our function so
13:36
here and then we have our function so this is uh the by default HTTP trigger
13:39
this is uh the by default HTTP trigger
13:39
this is uh the by default HTTP trigger function created by V studio so let's go
13:43
function created by V studio so let's go
13:43
function created by V studio so let's go through this this is a class uh with a
13:45
through this this is a class uh with a
13:45
through this this is a class uh with a name uh then we have a function so first
13:49
name uh then we have a function so first
13:49
name uh then we have a function so first of all if you want to create a function
13:50
of all if you want to create a function
13:50
of all if you want to create a function in aure you have to uh put data
13:54
in aure you have to uh put data
13:54
in aure you have to uh put data annotation with function so this will
13:57
annotation with function so this will
13:57
annotation with function so this will create an Azure function then you need
13:59
create an Azure function then you need
13:59
create an Azure function then you need to uh create a trigger basically aure
14:04
to uh create a trigger basically aure
14:04
to uh create a trigger basically aure functions are aure functions are event
14:07
functions are aure functions are event
14:07
functions are aure functions are event based so you have to use them with any
14:11
based so you have to use them with any
14:11
based so you have to use them with any type of event Microsoft provide us
14:13
type of event Microsoft provide us
14:13
type of event Microsoft provide us different type of event and one of them
14:16
different type of event and one of them
14:16
different type of event and one of them is HTTP trigger uh we also have q
14:19
is HTTP trigger uh we also have q
14:19
is HTTP trigger uh we also have q trigger blob trigger and a lot of other
14:22
trigger blob trigger and a lot of other
14:22
trigger blob trigger and a lot of other triggers are available so you can use
14:25
triggers are available so you can use
14:25
triggers are available so you can use that uh then we have
14:27
that uh then we have
14:27
that uh then we have authorization level
14:29
authorization level
14:29
authorization level uh then we can specify whether this
14:31
uh then we can specify whether this
14:31
uh then we can specify whether this function this HTTP function is uh get or
14:35
function this HTTP function is uh get or
14:35
function this HTTP function is uh get or post then we have HTTP request if I run
14:38
post then we have HTTP request if I run
14:38
post then we have HTTP request if I run this project uh so that how it is
14:41
this project uh so that how it is
14:41
this project uh so that how it is looking in the
14:44
starting
14:46
starting
14:46
starting so okay now console just opens and you
14:49
so okay now console just opens and you
14:49
so okay now console just opens and you can see that it's running my project and
14:52
can see that it's running my project and
14:52
can see that it's running my project and this is the end point the Trier that
14:55
this is the end point the Trier that
14:55
this is the end point the Trier that just created so just click on this
14:59
just created so just click on this
14:59
just created so just click on this okay now it is returning with response
15:01
okay now it is returning with response
15:01
okay now it is returning with response welcome to as your function and this URL
15:05
welcome to as your function and this URL
15:05
welcome to as your function and this URL is API SL function
15:08
is API SL function
15:09
is API SL function one okay so this is how uh basic as your
15:14
one okay so this is how uh basic as your
15:14
one okay so this is how uh basic as your function look
15:15
function look
15:15
function look like our next step is how to uh write
15:20
like our next step is how to uh write
15:20
like our next step is how to uh write data inside aure table okay so for that
15:25
data inside aure table okay so for that
15:25
data inside aure table okay so for that for example I want to write student data
15:29
for example I want to write student data
15:29
for example I want to write student data inside my Azure table so what I need to
15:33
inside my Azure table so what I need to
15:33
inside my Azure table so what I need to do first of all I will update uh my aure
15:37
do first of all I will update uh my aure
15:37
do first of all I will update uh my aure function to for example insert
15:42
function to for example insert
15:42
function to for example insert student so this model will be used for
15:45
student so this model will be used for
15:45
student so this model will be used for inserting student inside aure table now
15:49
inserting student inside aure table now
15:50
inserting student inside aure table now I need to install few dependencies uh so
15:53
I need to install few dependencies uh so
15:53
I need to install few dependencies uh so I will go to nugate package
15:56
I will go to nugate package
15:56
I will go to nugate package manager and here I will search for
15:59
manager and here I will search for
15:59
manager and here I will search for worker.
16:01
worker.
16:01
worker. extension. uh so this is the package
16:03
extension. uh so this is the package
16:03
extension. uh so this is the package that you need to uh install for working
16:07
that you need to uh install for working
16:07
that you need to uh install for working with Azure table inside Azure
16:10
with Azure table inside Azure
16:10
with Azure table inside Azure function so click on
16:13
function so click on
16:13
function so click on accept Okay the package have been
16:16
accept Okay the package have been
16:16
accept Okay the package have been installed uh next option is binding my
16:20
installed uh next option is binding my
16:20
installed uh next option is binding my Azure function
16:24
so basically aure function provide us
16:28
so basically aure function provide us
16:28
so basically aure function provide us two types of binding one is input
16:30
two types of binding one is input
16:30
two types of binding one is input binding and one is output
16:34
binding and one is output
16:35
binding and one is output binding so if I want to write my data
16:39
binding so if I want to write my data
16:39
binding so if I want to write my data inside aure table I have to use output
16:41
inside aure table I have to use output
16:41
inside aure table I have to use output mining so what I can
16:46
do I can uh put uh brackets here and
16:50
do I can uh put uh brackets here and
16:50
do I can uh put uh brackets here and then inside that I will write output
16:55
table spelling mistake
17:00
table output okay then inside table
17:04
table output okay then inside table
17:04
table output okay then inside table output I have to provide two things
17:06
output I have to provide two things
17:07
output I have to provide two things first of all I need to provide table
17:09
first of all I need to provide table
17:09
first of all I need to provide table name uh which I can say
17:12
name uh which I can say
17:12
name uh which I can say students or uh I can
17:16
students or uh I can
17:16
students or uh I can say student
17:19
say student
17:19
say student table I can put any name here and then
17:23
table I can put any name here and then
17:23
table I can put any name here and then inside connection I need to provide the
17:26
inside connection I need to provide the
17:26
inside connection I need to provide the app setting name which is containing the
17:28
app setting name which is containing the
17:28
app setting name which is containing the azour storage connection
17:31
azour storage connection
17:31
azour storage connection string so for example I'm going to say
17:34
string so for example I'm going to say
17:34
string so for example I'm going to say it Dev later I this is basically app
17:37
it Dev later I this is basically app
17:37
it Dev later I this is basically app setting name and inside this app setting
17:40
setting name and inside this app setting
17:40
setting name and inside this app setting name I need to set my connection string
17:43
name I need to set my connection string
17:43
name I need to set my connection string for aert table so there is very easy
17:47
for aert table so there is very easy
17:48
for aert table so there is very easy option for that if you click on
17:51
option for that if you click on
17:51
option for that if you click on this so basically as you provide already
17:56
this so basically as you provide already
17:56
this so basically as you provide already provide a connected service with storage
17:59
provide a connected service with storage
17:59
provide a connected service with storage aite emulator basically aor Right
18:01
aite emulator basically aor Right
18:01
aite emulator basically aor Right emulator provide us uh storage account
18:04
emulator provide us uh storage account
18:04
emulator provide us uh storage account emulator so you can use uh a your Q as
18:08
emulator so you can use uh a your Q as
18:08
emulator so you can use uh a your Q as your blob and a your tables emulator for
18:12
your blob and a your tables emulator for
18:12
your blob and a your tables emulator for uh developing inside your studio
18:15
uh developing inside your studio
18:15
uh developing inside your studio so I can update this connection string
18:18
so I can update this connection string
18:18
so I can update this connection string name to Dev and the connection string
18:20
name to Dev and the connection string
18:20
name to Dev and the connection string value is used development storage so
18:23
value is used development storage so
18:23
value is used development storage so whenever I will uh specify use
18:26
whenever I will uh specify use
18:26
whenever I will uh specify use development storage it will
18:27
development storage it will
18:28
development storage it will automatically with aor Right
18:30
automatically with aor Right
18:30
automatically with aor Right emulator okay so and do not save
18:34
emulator okay so and do not save
18:34
emulator okay so and do not save anywhere next and
18:38
finish uh it is giving me one
18:44
error okay uh let's check it okay uh
18:49
error okay uh let's check it okay uh
18:49
error okay uh let's check it okay uh basically this connected service
18:52
basically this connected service
18:52
basically this connected service automatically create few other functions
18:55
automatically create few other functions
18:55
automatically create few other functions which I don't require so I'm going to
18:57
which I don't require so I'm going to
18:57
which I don't require so I'm going to delete this uh these functions are
18:59
delete this uh these functions are
18:59
delete this uh these functions are giving
19:01
giving
19:01
giving error and this function so it
19:05
error and this function so it
19:05
error and this function so it automatically create blob trigger
19:07
automatically create blob trigger
19:07
automatically create blob trigger function okay that's it uh next thing is
19:11
function okay that's it uh next thing is
19:11
function okay that's it uh next thing is I need to create a model a data model
19:14
I need to create a model a data model
19:14
I need to create a model a data model that I want to save inside my aure
19:17
that I want to save inside my aure
19:17
that I want to save inside my aure table so let me create a new uh model uh
19:23
table so let me create a new uh model uh
19:23
table so let me create a new uh model uh first I will put it inside my models
19:26
first I will put it inside my models
19:26
first I will put it inside my models table uh create a new CL class for
19:30
table uh create a new CL class for
19:30
table uh create a new CL class for this and this class will be named
19:34
this and this class will be named
19:34
this and this class will be named student model or I can just say it's
19:39
student I can say it's student
19:43
student I can say it's student
19:43
student I can say it's student in okay so this is student
19:46
in okay so this is student
19:47
in okay so this is student entity now the first thing which we need
19:51
entity now the first thing which we need
19:51
entity now the first thing which we need is we need to inherit it from itable
19:55
is we need to inherit it from itable
19:55
is we need to inherit it from itable entity so itable entity is basically an
19:59
entity so itable entity is basically an
19:59
entity so itable entity is basically an interface uh this interface belongs to
20:01
interface uh this interface belongs to
20:01
interface uh this interface belongs to aure do dat. tabls uh
20:05
aure do dat. tabls uh
20:05
aure do dat. tabls uh package and we have to implement it just
20:08
package and we have to implement it just
20:08
package and we have to implement it just click and Implement
20:11
click and Implement
20:11
click and Implement interface okay now this interface
20:15
interface okay now this interface
20:15
interface okay now this interface provide four things first of all
20:17
provide four things first of all
20:17
provide four things first of all partition key this is the partition key
20:21
partition key this is the partition key
20:21
partition key this is the partition key uh value that you can use for creating
20:24
uh value that you can use for creating
20:24
uh value that you can use for creating different partition for example uh you
20:26
different partition for example uh you
20:26
different partition for example uh you want to partition you are uh male and
20:29
want to partition you are uh male and
20:29
want to partition you are uh male and female students separate separately so
20:33
female students separate separately so
20:33
female students separate separately so you can use this partition key next we
20:35
you can use this partition key next we
20:36
you can use this partition key next we have uh row key row key is just
20:39
have uh row key row key is just
20:39
have uh row key row key is just like uh row key is just like uh your
20:43
like uh row key is just like uh your
20:43
like uh row key is just like uh your primary key for your function as we have
20:46
primary key for your function as we have
20:46
primary key for your function as we have in relational databases so
20:50
in relational databases so
20:50
in relational databases so inide this you have to use row key for
20:54
inide this you have to use row key for
20:54
inide this you have to use row key for identifying specific student inside as
20:58
identifying specific student inside as
20:58
identifying specific student inside as your table so currently this is not
21:00
your table so currently this is not
21:00
your table so currently this is not implemented so I will update it to my
21:04
implemented so I will update it to my
21:04
implemented so I will update it to my letter
21:05
letter
21:05
letter Setter
21:07
Setter
21:07
Setter and then we have time stamp time stamp
21:11
and then we have time stamp time stamp
21:11
and then we have time stamp time stamp is basically uh the time when we are
21:14
is basically uh the time when we are
21:14
is basically uh the time when we are creating or updating this as your table
21:18
creating or updating this as your table
21:18
creating or updating this as your table and then we have e tag e tag basically
21:21
and then we have e tag e tag basically
21:21
and then we have e tag e tag basically is a metadata field which you can use
21:23
is a metadata field which you can use
21:23
is a metadata field which you can use for uh storing
21:26
for uh storing
21:26
for uh storing different metadata
21:29
different metadata
21:29
different metadata values so I'm going to make them empty
21:32
values so I'm going to make them empty
21:32
values so I'm going to make them empty so that I can remove the uh warning so
21:36
so that I can remove the uh warning so
21:36
so that I can remove the uh warning so now I have created my student entity now
21:39
now I have created my student entity now
21:39
now I have created my student entity now I will use this student entity for
21:43
I will use this student entity for
21:43
I will use this student entity for uh connecting with aure table now move
21:46
uh connecting with aure table now move
21:46
uh connecting with aure table now move to my function one which is basically
21:49
to my function one which is basically
21:49
to my function one which is basically insert student uh I also I already have
21:54
insert student uh I also I already have
21:54
insert student uh I also I already have created output binding for disable now I
21:58
created output binding for disable now I
21:58
created output binding for disable now I I need to update this I action result to
22:03
I need to update this I action result to
22:03
I need to update this I action result to my student entity and here I will
22:08
my student entity and here I will
22:08
my student entity and here I will return a new student
22:12
entity so whenever I will return this
22:16
entity so whenever I will return this
22:16
entity so whenever I will return this new student entity as this is an output
22:19
new student entity as this is an output
22:19
new student entity as this is an output binder this will automatically save my
22:22
binder this will automatically save my
22:22
binder this will automatically save my data inside my aure table
22:28
so here uh I also need few Uh custom
22:32
so here uh I also need few Uh custom
22:32
so here uh I also need few Uh custom properties for my students so I will put
22:35
properties for my students so I will put
22:35
properties for my students so I will put them
22:38
here for example I have student
22:42
here for example I have student
22:42
here for example I have student name and I have
22:45
name and I have
22:45
name and I have student
22:49
email I will mark them empty as
22:53
email I will mark them empty as
22:53
email I will mark them empty as well by default
22:56
well by default
22:56
well by default value okay
23:00
value okay
23:00
value okay here I need to uh save my values in
23:03
here I need to uh save my values in
23:03
here I need to uh save my values in starting later on I will get them from
23:06
starting later on I will get them from
23:06
starting later on I will get them from HTTP request
23:08
HTTP request
23:08
HTTP request body I will say this for example Habib
23:12
body I will say this for example Habib
23:12
body I will say this for example Habib and then email is
23:15
and then email is
23:15
and then email is tabib
23:18
gmail.com I need row key so row key can
23:22
gmail.com I need row key so row key can
23:22
gmail.com I need row key so row key can be any new
23:27
grid
23:57
e
24:27
e e
24:51
[Music]
24:58
n
25:02
[Music]
25:28
n
25:29
n
25:29
n [Music]
26:21
[Music]
26:28
n
26:35
[Music]
26:58
he
26:59
he
26:59
he [Music]
27:28
[Music]
27:28
[Music] n
27:30
n
27:30
n [Music]
28:24
n
28:28
m
28:29
m
28:29
m [Music]
28:59
n
29:03
[Music]
29:25
[Music]
29:58
[Music]
29:58
[Music] n
30:00
n
30:00
n [Music]
30:57
[Music]
30:57
[Music] d
30:58
d
30:58
d [Music]
31:57
h
31:58
h
31:58
h uh sorry guys I just disconnected from
32:01
uh sorry guys I just disconnected from
32:01
uh sorry guys I just disconnected from the internet and there was some issue so
32:04
the internet and there was some issue so
32:04
the internet and there was some issue so I'm back can you guys tell me where you
32:08
I'm back can you guys tell me where you
32:08
I'm back can you guys tell me where you uh lost me uh on which
32:11
uh lost me uh on which
32:11
uh lost me uh on which topic it will be
32:15
good um I cannot actually Habib but you
32:19
good um I cannot actually Habib but you
32:19
good um I cannot actually Habib but you were you just we lost you only for five
32:22
were you just we lost you only for five
32:22
were you just we lost you only for five minutes for less than five minutes okay
32:25
minutes for less than five minutes okay
32:25
minutes for less than five minutes okay okay okay let me uh go through a little
32:30
okay okay let me uh go through a little
32:30
okay okay let me uh go through a little in past uh so I was talking about in
32:33
in past uh so I was talking about in
32:33
in past uh so I was talking about in aure table if I want to save any data I
32:35
aure table if I want to save any data I
32:35
aure table if I want to save any data I have to create a model so this model is
32:39
have to create a model so this model is
32:39
have to create a model so this model is uh any cop clause and you have to
32:42
uh any cop clause and you have to
32:42
uh any cop clause and you have to inherit it from itable entity so this it
32:45
inherit it from itable entity so this it
32:45
inherit it from itable entity so this it table entity interface belongs to asure
32:48
table entity interface belongs to asure
32:48
table entity interface belongs to asure data tables uh then this table entity
32:51
data tables uh then this table entity
32:52
data tables uh then this table entity provide us four uh at four properties
32:55
provide us four uh at four properties
32:55
provide us four uh at four properties one is partition key partition key is
32:57
one is partition key partition key is
32:57
one is partition key partition key is BAS basically the value on which we want
33:00
BAS basically the value on which we want
33:00
BAS basically the value on which we want to partition what data then we have row
33:02
to partition what data then we have row
33:02
to partition what data then we have row key row key is just like any primary key
33:06
key row key is just like any primary key
33:06
key row key is just like any primary key or any uh unique key we have inside our
33:10
or any uh unique key we have inside our
33:10
or any uh unique key we have inside our data then we have time stamp and eag uh
33:13
data then we have time stamp and eag uh
33:14
data then we have time stamp and eag uh so next step
33:15
so next step
33:15
so next step was
33:17
was
33:17
was to B uh this entity with our Azure
33:21
to B uh this entity with our Azure
33:21
to B uh this entity with our Azure function so I uh made this as a return
33:24
function so I uh made this as a return
33:24
function so I uh made this as a return type for my Azure function and then I
33:27
type for my Azure function and then I
33:27
type for my Azure function and then I created a new instance of student entity
33:29
created a new instance of student entity
33:29
created a new instance of student entity and returning uh to this function now
33:32
and returning uh to this function now
33:32
and returning uh to this function now what will happen this table output
33:34
what will happen this table output
33:34
what will happen this table output binder will automatically write my data
33:37
binder will automatically write my data
33:37
binder will automatically write my data inside as your table so I also had T
33:42
inside as your table so I also had T
33:42
inside as your table so I also had T this uh in previous but let's test it
33:48
again okay this my aure function is
33:51
again okay this my aure function is
33:51
again okay this my aure function is working and if I click on this and
33:54
working and if I click on this and
33:54
working and if I click on this and continue
33:56
continue
33:56
continue this so there is no error which means my
33:59
this so there is no error which means my
33:59
this so there is no error which means my data have been saved inside aure table
34:03
data have been saved inside aure table
34:03
data have been saved inside aure table so next step
34:04
so next step
34:04
so next step is how to uh retrieve this data inside
34:08
is how to uh retrieve this data inside
34:08
is how to uh retrieve this data inside HTTP trigger and show to the user so I
34:12
HTTP trigger and show to the user so I
34:12
HTTP trigger and show to the user so I will create a new function for this and
34:16
will create a new function for this and
34:16
will create a new function for this and I will name this function get
34:18
I will name this function get
34:18
I will name this function get all uh male students for example I want
34:21
all uh male students for example I want
34:21
all uh male students for example I want to uh get data on the type of
34:25
to uh get data on the type of
34:25
to uh get data on the type of partitions after this an notation uh I
34:29
partitions after this an notation uh I
34:29
partitions after this an notation uh I need to create new
34:32
need to create new
34:32
need to create new function and this function will be
34:34
function and this function will be
34:34
function and this function will be basically I action
34:37
basically I action
34:37
basically I action result get
34:40
result get
34:40
result get all male
34:44
students okay now inside this
34:50
students okay now inside this
34:50
students okay now inside this function I also need to bind it with
34:54
function I also need to bind it with
34:54
function I also need to bind it with HTTP trigger basically any function
34:58
HTTP trigger basically any function
34:58
HTTP trigger basically any function needs to be triggered by
35:00
needs to be triggered by
35:00
needs to be triggered by something and as this will be only get
35:04
something and as this will be only get
35:04
something and as this will be only get function then this will be my HTTP
35:11
request here I need to return okay
35:16
request here I need to return okay
35:16
request here I need to return okay object
35:18
object
35:18
object result uh let's see what error is coming
35:21
result uh let's see what error is coming
35:21
result uh let's see what error is coming it is
35:23
it is
35:23
it is me okay I got one mistake okay
35:28
me okay I got one mistake okay
35:28
me okay I got one mistake okay and I can put any data here now if I
35:32
and I can put any data here now if I
35:32
and I can put any data here now if I want to access my uh data from Azure
35:35
want to access my uh data from Azure
35:35
want to access my uh data from Azure table I need to create a binder that
35:39
table I need to create a binder that
35:39
table I need to create a binder that binder is basically input binder for a
35:42
binder is basically input binder for a
35:42
binder is basically input binder for a table so I will say
35:45
table so I will say
35:45
table so I will say it table input and inside this table
35:49
it table input and inside this table
35:49
it table input and inside this table input I need to give it table name table
35:52
input I need to give it table name table
35:52
input I need to give it table name table name is students
35:56
name is students
35:56
name is students table and then
35:58
table and then
35:58
table and then uh I need to give it property key as you
36:00
uh I need to give it property key as you
36:00
uh I need to give it property key as you can see that there are uh four function
36:03
can see that there are uh four function
36:03
can see that there are uh four function uh
36:04
uh
36:04
uh available table name partition key row
36:07
available table name partition key row
36:07
available table name partition key row key uh but I want to fetch only data
36:11
key uh but I want to fetch only data
36:11
key uh but I want to fetch only data with uh partition key and I will give it
36:14
with uh partition key and I will give it
36:14
with uh partition key and I will give it mail basically uh this function will
36:17
mail basically uh this function will
36:17
mail basically uh this function will only get male students and then row key
36:21
only get male students and then row key
36:21
only get male students and then row key but I will not and uh I will not get
36:24
but I will not and uh I will not get
36:24
but I will not and uh I will not get specific data as I want to uh take
36:27
specific data as I want to uh take
36:27
specific data as I want to uh take multiple data so I will use this
36:30
multiple data so I will use this
36:30
multiple data so I will use this function then I need to specify uh
36:35
connection and inside this connection I
36:38
connection and inside this connection I
36:38
connection and inside this connection I need to give it the app setting name
36:40
need to give it the app setting name
36:40
need to give it the app setting name which is storing my connection and that
36:43
which is storing my connection and that
36:43
which is storing my connection and that name is Dev and then I need to create an
36:46
name is Dev and then I need to create an
36:46
name is Dev and then I need to create an i enumerable because I will get a list
36:49
i enumerable because I will get a list
36:49
i enumerable because I will get a list of uh
36:51
of uh
36:51
of uh students and inside this I enumerable
36:54
students and inside this I enumerable
36:54
students and inside this I enumerable the data model will be student enti and
36:58
the data model will be student enti and
36:58
the data model will be student enti and here I will
37:00
here I will
37:00
here I will create it okay next I need to return
37:05
create it okay next I need to return
37:05
create it okay next I need to return this okay object result with my students
37:12
this okay object result with my students
37:12
this okay object result with my students data so for
37:16
data so for
37:16
data so for example I will directly put it
37:19
example I will directly put it
37:19
example I will directly put it here okay that's it uh create a
37:23
here okay that's it uh create a
37:23
here okay that's it uh create a breakpoint here
37:28
let's run this function and see whether
37:30
let's run this function and see whether
37:30
let's run this function and see whether this is matching data
37:36
from okay now you can see that another
37:38
from okay now you can see that another
37:38
from okay now you can see that another function is running with name get all
37:41
function is running with name get all
37:41
function is running with name get all student and it is giving me 500 so let's
37:45
student and it is giving me 500 so let's
37:45
student and it is giving me 500 so let's see what is the
37:50
error it is giving me storage account
37:53
error it is giving me storage account
37:53
error it is giving me storage account connection Str a your
37:56
connection Str a your
37:56
connection Str a your job that does not exist uh there is
37:59
job that does not exist uh there is
37:59
job that does not exist uh there is something wrong with my connection
38:08
name okay let's check it thoroughly what
38:12
name okay let's check it thoroughly what
38:12
name okay let's check it thoroughly what may be
38:15
wrong uh let's go to asor
38:19
wrong uh let's go to asor
38:19
wrong uh let's go to asor right
38:23
uh okay it just automatically updated
38:27
uh okay it just automatically updated
38:27
uh okay it just automatically updated I don't know the
38:33
reason uh let me use this name instead
38:38
reason uh let me use this name instead
38:38
reason uh let me use this name instead of the dev
38:42
so cre it on four
38:49
level okay let's run it again and
38:56
see I already have opened it inside my
39:00
see I already have opened it inside my
39:00
see I already have opened it inside my browser so now this is tring definition
39:04
browser so now this is tring definition
39:04
browser so now this is tring definition for
39:05
for
39:05
for inser and now check get all mail
39:13
inser and now check get all mail
39:13
inser and now check get all mail students oh something wrong with the URL
39:16
students oh something wrong with the URL
39:16
students oh something wrong with the URL the name is get all mail
39:21
student okay now you can see that my
39:25
student okay now you can see that my
39:25
student okay now you can see that my aure function is returning me all the
39:27
aure function is returning me all the
39:27
aure function is returning me all the male students data the data is same
39:30
male students data the data is same
39:30
male students data the data is same because I have hardcoded this inside my
39:33
because I have hardcoded this inside my
39:33
because I have hardcoded this inside my Azure function but you can see that the
39:36
Azure function but you can see that the
39:36
Azure function but you can see that the row key is
39:39
row key is
39:39
row key is different okay now uh let me create an
39:43
different okay now uh let me create an
39:43
different okay now uh let me create an HTTP request body inside insert student
39:47
HTTP request body inside insert student
39:47
HTTP request body inside insert student so that I can uh post any data inside my
39:51
so that I can uh post any data inside my
39:51
so that I can uh post any data inside my aure table so after this I will annotate
39:57
aure table so after this I will annotate
39:57
aure table so after this I will annotate it from
39:59
it from
39:59
it from body and then I need to specify student
40:03
body and then I need to specify student
40:03
body and then I need to specify student entity the model that I want to get and
40:08
entity the model that I want to get and
40:08
entity the model that I want to get and I will say it
40:11
student okay after that I will be uh
40:14
student okay after that I will be uh
40:15
student okay after that I will be uh returning this entity as it
40:19
is and I'm am also setting
40:24
is and I'm am also setting
40:24
is and I'm am also setting the student row key here
40:29
randomly so that I have don't have to
40:32
randomly so that I have don't have to
40:32
randomly so that I have don't have to provide from front end I will also
40:35
provide from front end I will also
40:35
provide from front end I will also remove the get method from this because
40:39
remove the get method from this because
40:39
remove the get method from this because now I'm reading uh the data from the
40:42
now I'm reading uh the data from the
40:42
now I'm reading uh the data from the body of my HTTP request uh I also need
40:46
body of my HTTP request uh I also need
40:46
body of my HTTP request uh I also need to update uh
40:48
to update uh
40:48
to update uh this from body attribute because
40:50
this from body attribute because
40:50
this from body attribute because currently it is getting from body of
40:53
currently it is getting from body of
40:53
currently it is getting from body of asp.net M but I need to use it it from a
40:59
asp.net M but I need to use it it from a
40:59
asp.net M but I need to use it it from a your function so you can see that there
41:01
your function so you can see that there
41:01
your function so you can see that there are two available so I'm going to use
41:08
it I'm going to use this Microsoft as
41:12
it I'm going to use this Microsoft as
41:12
it I'm going to use this Microsoft as your function
41:14
your function
41:14
your function worker I will specify here
41:19
worker I will specify here
41:19
worker I will specify here Microsoft
41:21
Microsoft
41:21
Microsoft functions work HTTP do from
41:26
functions work HTTP do from
41:26
functions work HTTP do from body the reason why I have to specify
41:29
body the reason why I have to specify
41:29
body the reason why I have to specify the full name is because uh the names
41:33
the full name is because uh the names
41:33
the full name is because uh the names for
41:34
for
41:34
for both from body attri are same inside
41:38
both from body attri are same inside
41:38
both from body attri are same inside these both uh references so that's why I
41:41
these both uh references so that's why I
41:41
these both uh references so that's why I have to make it
41:43
have to make it
41:43
have to make it explicit okay now let's run this and
41:48
explicit okay now let's run this and
41:48
explicit okay now let's run this and let's copy the URL for insert
41:52
let's copy the URL for insert
41:52
let's copy the URL for insert student my Postman
42:04
let's this HTTP post and inside body I
42:10
let's this HTTP post and inside body I
42:10
let's this HTTP post and inside body I have Json inside Jon I will say I have
42:26
uh
42:56
e e
43:29
[Music]
43:42
okay guys welcome back uh
43:44
okay guys welcome back uh
43:45
okay guys welcome back uh so I was talking about how to uh test
43:48
so I was talking about how to uh test
43:48
so I was talking about how to uh test this function using Postman so inside
43:51
this function using Postman so inside
43:51
this function using Postman so inside Postman I have created a new request I
43:54
Postman I have created a new request I
43:54
Postman I have created a new request I make it HTTP post and then inside body I
43:57
make it HTTP post and then inside body I
43:57
make it HTTP post and then inside body I put by all the values then after uh
44:01
put by all the values then after uh
44:01
put by all the values then after uh sending the request so I just received
44:04
sending the request so I just received
44:04
sending the request so I just received my request inside HTTP trigger function
44:07
my request inside HTTP trigger function
44:07
my request inside HTTP trigger function so now let's check whether my student is
44:10
so now let's check whether my student is
44:10
so now let's check whether my student is getting properly data or not so you can
44:12
getting properly data or not so you can
44:12
getting properly data or not so you can see that partition key name and email
44:15
see that partition key name and email
44:15
see that partition key name and email are coming
44:16
are coming
44:16
are coming here so let's click on next
44:21
here so let's click on next
44:21
here so let's click on next button my row key have been generated
44:25
button my row key have been generated
44:25
button my row key have been generated and if I continue
44:27
and if I continue
44:27
and if I continue okay it is giving me 200 so if I uh
44:31
okay it is giving me 200 so if I uh
44:31
okay it is giving me 200 so if I uh check this data inside my other
44:36
API let's remove the break
44:39
API let's remove the break
44:39
API let's remove the break point so you can see that a new item
44:42
point so you can see that a new item
44:42
point so you can see that a new item have been created
44:44
have been created
44:44
have been created inside aure table so this is how you can
44:49
inside aure table so this is how you can
44:49
inside aure table so this is how you can leverage your aure table inside as your
44:52
leverage your aure table inside as your
44:52
leverage your aure table inside as your function
44:54
function
44:54
function so there are a lot of stuff available uh
44:58
so there are a lot of stuff available uh
44:58
so there are a lot of stuff available uh on Microsoft website which you can
45:01
on Microsoft website which you can
45:01
on Microsoft website which you can use if if you sech as your
45:05
use if if you sech as your
45:05
use if if you sech as your table
45:06
table
45:06
table uh binding for as your
45:09
uh binding for as your
45:09
uh binding for as your function so this is the official uh page
45:13
function so this is the official uh page
45:13
function so this is the official uh page you can uh learn more about Azure
45:16
you can uh learn more about Azure
45:16
you can uh learn more about Azure functions working with Azure tables uh
45:19
functions working with Azure tables uh
45:19
functions working with Azure tables uh so you can see there is uh available for
45:23
so you can see there is uh available for
45:23
so you can see there is uh available for both input and output Bings uh so you
45:27
both input and output Bings uh so you
45:27
both input and output Bings uh so you can learn more uh things about these
45:30
can learn more uh things about these
45:30
can learn more uh things about these bindings from Microsoft
45:34
bindings from Microsoft
45:34
bindings from Microsoft function so I think uh that was it from
45:39
function so I think uh that was it from
45:39
function so I think uh that was it from my side and I hope you guys have enjoyed
45:43
my side and I hope you guys have enjoyed
45:43
my side and I hope you guys have enjoyed sorry for the inter internet
45:45
sorry for the inter internet
45:45
sorry for the inter internet Interruption uh and next time I will try
45:47
Interruption uh and next time I will try
45:47
Interruption uh and next time I will try to improve that if you guys have any
45:51
to improve that if you guys have any
45:51
to improve that if you guys have any question you can ask me in comments uh
45:53
question you can ask me in comments uh
45:53
question you can ask me in comments uh otherwise uh inshallah show you
46:07
and
#Programming
#Software