How to Use DotConnect for SQL Server with Visual Studio

Here I have explain the features and their uses about DotConnect for SQL Server with the help of Microsoft Visual Studio. DotConnect provide the rich set of features that is very helpfull to the development of Ado.NET technology. DotConnect for SQL Server offers both high performance native connectivity to SQL Server and a number of innovative database development tools and technologies.

For download and more more details about dotConnect Visit: https://www.devart.com/dotconnect/sqlserver/

🌀 More Videos
https://youtu.be/hhzCzgGjteM : Facebook Authentication in ASP.NET Core
https://youtu.be/YmxtJ5euiSo : Google Authentication in ASP.NET Core
https://youtu.be/5KNIpKcTIVs : Import data from Excel to SQL Server database in ASP.NET Core
https://youtu.be/b8ALu0PhNiU : Export data from SQL Server to Excel file in ASP.NET Core
https://youtu.be/XkzBEz2YhFw : Upload Large Files in ASP.NET Core

Subscribe to this channel
► https://www.youtube.com/csharpspace?sub_confirmation=1


🎬 All Playlist
https://bit.ly/3cHsXxO : ASP.NET Core
https://bit.ly/3jgyL2x : ASP. NET Web API
https://bit.ly/2MSpi5i : ASP.NET MVC
https://bit.ly/2LinGBm : ASP.NET MVC With Angular JS
https://bit.ly/39NZZuj : Social Account Login in ASP.NET MVC
https://bit.ly/2MyVgUq : ASP.NET Web Forms

🌟 About this Channel
Csharp Space provide simple and step to step video tutorials of different programming languages like ASP.NET, ASP.NET Core, C#, ASP.NET MVC,
Angular JS, JavaScript, jQuery, SQL ,Crystal Report.
This channel also provide How to and problem solving topics of the programming languages.
► For Sponsorship Contact here: vivek29417@gmail.com

🔗 Social Media Links
Blog : http://www.voidgeeks.com
Facebook : https://www.facebook.com/csharpspace
Twitter : https://twitter.com/csharpspace
YouTube : https://youtube.com/csharpspace

---

Closed Caption:

hello friends welcome to csup space
today in this video session we will
discuss about uh how to use uh
net connect
for
a sql server
uh and we also discussed there this
features for eddy.net technologies
uh that we use in our dotnet
applications
uh that contains some uh
the most important features that we can
use in our radio.net application
like it contain a
wide result range of advantage for
skills rules
like wide coverage sql server features
and
this
also provide a tool box for sql server
uh data like this when we uh download
this extension in our which is visual
studio
uh this will provide this set of tools
in our toolbox
so we can simply use this
by drag and drop in our applications
and
like it's also provide optimized code
and database application development
extensions
and
this
this can
use in both connected and disconnected
models
and like it's a
comprehensive support for uh
net technologies features that can use
all the features for that
and here is the key features
uh
that dot net connect provide for sql
server
here is the different uh
features
for dot net connect
so uh
you can you can simply download this
from here for
30 days trials and you can use in your
application
uh destroyed on both
free and uh
one is pro version for a 30 days trial
so you can simply download this here and
this will
add um application in your widget studio
uh that person you wish you use like uh
2017 or 19
so now uh we can
see this demo in live on some
demo project here i already
created one blank project for windows
applications
and this is the different tools uh
that will
so here after installing the
this dot net connect
so this all this toolbox will
show here so
we simply use
this
in our this demo application
so
first of all uh we need to
connect
database with our application so you can
use this in your
code level
on this
or you can simply drag and drop to here
so here i drop this sql connection
object
so now we can configure this sql
connects our tool with our database so i
am here using
one demo database for
this project
so we click on simply connect string
and here
we provide
our database names user id passwords and
different details that we need to
provide so here i am using a local
database so
i am using this
as a windows authentication so this
integrity will be true
and
here
we
add our database name
so that database name will be copied to
here
and
data source name and database name is
uh display will be here
so
i had my database name is here
and then here i am chooses my
database name cc service space
and then
click on ok
then we
successfully connected
then click on ok
now save it
now this uh sql connection is connected
so we can also
change their property to here
it's also so different
here this will show the
connection string that we configured
now in next step like
if you want to
display data from any tables so
like simply i take a
sql data table
so i drag and drop it here
and then
we
provide a connect string
connection string is
this so simply choose this sql
connection
and then you can
configure this data table from here or
you can also
do these same things dynamically at the
code level
so you need to add our two name spaces
for this
for using
this extension
first is like
using
reward
dot
data dot
sql server
and using
reward
dot
data
so uh
if you
use this two name spaces then
all this uh
all these tools is also
display here like i'm go to this uh
load function so you can simply write it
here so this will provide same things to
here
and like i also use sql data tables so
this will also provide it here
so firstly i demonstrate this example
with the design level
so we configure this
configure data table
and uh
like here
uh we firstly uh
write a
uh query you can write it here
and this for a parameters you can use
both text
histories and direct tables so this
provider different
uh
features for this so and you can also
specify their parameters to here and
this for
command generators and this for update
command here you can
generate the insert update and delete
commands
so we can
write here
a table name for fetching the record
from that table
so here i am writing a
select command
select stroke from tbl imply here i am
using a
employee table for fetching the record
so you can also check this query by
clicking on this preview
so this will paste the record from
database this container
different columns from that tbl employee
table click on ok
and then click on ok but
you can also check it here preview data
and click on ok
and now
now we can
choose a data grid view for
testing the
different data from that columns name
so i'm going to data and then choose
data grid view
then go to this design
here we set it
and we can choose
we can fill the data from both like at
the code level
or at design level by
choosing the data source to here
like here we can choose data sources
like this showing a data table so simply
select it
and save it
now
to fill the record into this data table
uh we use a sql data adapter here and
demonstrating the disconnected model
so you can use uh connected also like
this also provide a connected features
is a sql data reader
like isql command
and you can use
that model also
now uh you can configure this uh data
adapter so and click on this configure
data adapter and here
you can
write a query store processes or direct
tables
so like here i'm again writing the query
for finding the record
so it's a table
employee
and click on view this will
find the data
and then
choose okay
uh
you can also fill uh the dataset from
that create from this design
so so we can simply click on here data
set wizard and then click next and then
uh configure that data set to fill that
data into
that comp configured dataset
so here
so after that you can
click on this field dataset to fill that
data to data set
then click on preview data to get the
preview of that
data that present into the table
so here and fill the data into this sql
data table so simply
i'm going to this paste load and here
i'm adding sql data doctor
dr.fill
and then
we write a
sql data
table
and then
we write this uh
data grid with dot data source and then
and this data table
so now we
run this application
so this will uh display all the records
from uh
that table employee table
now uh we can
now
check the other stored modules that
provided by dotnet connect
so this also provides one most important
tools that simplifies our development
that the sql script
square script we can
simply write any
uh any command
command here
to
directly execute that
script from our c sub
so we can write anything
any commands that you want to run on
runtime
like i am writing here insert command
or insert recording to this tpl employee
and click on ok
now we execute that script in our c sub
code
so simply write it here
script
dot
and this
will provide a different
uh properties for this like uh cancel
connections containers dispose execute
executes that the different features
so simply i am writing your execute so
we
execute that script
now
we run this application
in connections properties not
initialized here we need to
initialize the connectors uh properties
for this uh
square script
so i am choosing this connection
second x and one
now we again run this
mixing must be opens
we again check this
this showing uh
close connect open connections errors so
we can simply open a connection here
connection dot open
and then we can
close this
connections
now we check this
so that
joking record is inserted
so
you can write any sql queries or process
to this this window and you can also
check this uh command to here
and you can also
load the scripts from different files
and you can save this script to any
files
so this required uh more features
to
do the best performance of this edit.net
technology
now this will provide other tools like
uh
data link
uh
here this allow the pla stabilizing the
flexible cross from data bindings from
different data is for sql connection
that we we used it here
is for sql command like in edu.net that
we use it
so simply you can also drag it drop here
and then uh configure the
kinect string
like this and then choose the command
text and then you can use that uh sql
command to any data adapters
and any uh like actual data writers you
can simply use it and this is data
adapters that we use it here and this
sql command builder
uh that generate the
uh commands
uh like here in the spider tool t
the next command used to reconcile
changes made to dataset with this seated
server database means you can
generate the insert update lead from
that
tables for that servers and this is the
sql monitors allow to monitor dynamic
sql executions you can monitor the any
dynamic sql qr executions
is for sql data set that we use it here
this is the data tables here we used
and this the sql loaders
here
uh these sql loaders like you can
uh import the data from different types
of
data sources like flat files csv excels
from that file to you in your sql server
database
and this uh sql scripts that we use it
here
so this is the different tools and
features that
are developed.net connect destroyed or
educated technologies
so
if you can if you like these tools you
can simply
uh try to download it here and
you can embed this in your visual studio
and check at your site
so
so
today is complete so thanks thanks for
watching
and if you like my videos please click
on subscribe buttons and for getting
latest updates also click on
notification bell
so thanks thanks for watching we will
meet in next video session