Configuring Connection string in appsettings. Here in ASP. In this file, we have added ConnectionStrings section inside that we have added DatabaseConnection key and other is value. Registering Dependency injection AddDbContext.
In this part, we are going to register DatabaseContext class as a service for using it as dependency injection, which will be available to the entire application.
We are going to register this service in ConfigureServices Method of startup class. First, we need to read connection string from appsettings. Getting Connection String from appsettings.
Next, we are going to use AddDbContext extension method to register the DatabaseContext in the dependency injection container.
This method is backwards-compatible to SQL Server then register below method. ConfigureServices Method in Startup Class.
Please select a comment to reply. You can add your comment about this article using the form below.
Make sure you provide a valid email address else you won't be notified when the author replies to your comment Please note that all comments are moderated and will be deleted if they are Not relavant to the article Spam Advertising campaigns or links to other sites Abusive content.
Please do not post code, scripts or snippets. Required Invalid Email Address. Security code:. Required Invalid security code. I declare, I accept the site's Privacy Policy. Add Comment. Disclaimer : The code samples and API available at www.
You are free to use it for commercial as well as non-commercial use at your own risk, but you cannot use it for posting on blogs or other tutorial websites similar to www.
All the code samples and API provided by the authors are solely their creation and neither the author nor the site are responsible if it does not work as intended. I agree to the above terms.
Download Required. What our readers say. Error Details. This site makes use of Cookies. Now let's see the upload, as shown below: We got the file name, as shown below: Content Type is shown below: Let's see the length of that document which is depicted below: Now we will see what we have successfully uploaded.
Conclusion This article was about uploading the files in the database and saving them in a binary format. I hope this article was helpful. Next Recommended Reading. Net Core 6. Value ; cmd. Text ; cmd. ExecuteNonQuery ; con. Redirect Request. ReadBytes CType s. Length, Int32 'fetch connection string from the web. ConnectionStrings "ConnectionStrings". Value cmd. Text cmd. Open 'execute SQL statement cmd. ExecuteNonQuery con. AbsoluteUri End Sub Explanation As you can see in the written code above, first we fetched a name of the uploaded file and stored it in a local variable empFilename, then we fetched and stored the content type of the uploaded file and stored it in variable FileContentType.
Then we read the contents of the file and stored in-stream variables and then created an object of binary reader class that reads primitive data types as binary values in specific encoding and uses that file content and stored binary data in a byte array. Then we have created a database connection and command object as well as prepared a parameterized SQL query for inserting records into the tblEmpIdentity table and passing required parameters with values and executes SQL statement and inserts a record into the SQL server database.
Finally, as per the requirement described above, we need to display uploaded files or documents of the employees into the grid view, so we will fetch all the records from the tblEmpIdentity table and bind those records with the grid view.
0コメント