It's a professional logic to use the databaseOwner
and objectQualifier values when creating tables
else you will not be able to identify the tables
in databases with ease and gain other benefits of it.
there are different kind of joins available by sql like
inner join,left join,etc.by the following example i will show
how to do left join which i used in my application to
get data from two tables -
command objects use parameters for passing values
to sql statements for type cheking,validation,guarding
against SQL injection attacks,etc.so its a good practice
to use command parameters to sql statements.
connecting Asp.net local MDF database files to sql
server management studio express is easy to do.
following are the steps to do so -
we know how to use asp.net membership provider.
most of the time we create membership tables
manualy.But those tables can be created
automatically by adding a line in the membership
provider configuration in web.config file.