How to get the value from web.config(if any value assign as static Key)

Web.Config File:

 <appSettings>
    <add key="DomainName" value="PW" />
    </appSettings>


Class.cs

WebConfigurationManager.AppSettings["DomainName"]

WebAPI Project Layers

Please check the below screen shot:

AutoFac dependency injection in entity frame work

Reference Link :

https://www.c-sharpcorner.com/article/using-autofac-with-web-api/

Creating the repository Base in entity frame work

Reference Link:

https://www.c-sharpcorner.com/blogs/generic-repository-pattern-with-webapi-and-entity-framework


https://www.codeproject.com/Articles/814768/CRUD-Operations-Using-the-Generic-Repository-Patte

How to connect local visual studio code with server Data Base and local Data Base

 Connect visual studio code with local Sql server DB:

<add name="FMECADB" providerName="System.Data.SqlClient" connectionString="Data Source=.;Initial Catalog=FMECADB;Integrated Security=True;" />

Name:- name of the connection string
DataSource:-login details(for local DB we are login using DOT(.))
Initial Catalog:-Name of the DataBase


Connect visual studio code with Server Sql server DB:

    <add name="FMECADB" providerName="System.Data.SqlClient" connectionString="Data Source=190.25.118.54;Initial Catalog=FMECADB_Onsite;Integrated Security=false;User Id=FMECADB;Password=1qaz2wsx@"/>

How to serialize(convert) string of values array of class in C#

Deserialize data from string to list of class:


            List<ClassName> Results = (List<ClassName>)Newtonsoft.Json.JsonConvert.DeserializeObject(string of date, typeof(List<ClassName>));

Concatenate Multiple Rows Within Single Row in SQL Server 2008

https://www.c-sharpcorner.com/UploadFile/860b29/concatenate-multiple-rows-within-single-row-in-sql-server-20/