I am going to tell you  very simple manner to do the CRUD operation using LocalDB with entity framework and how to use code first Database migration.After reading this article you are going to know about,Uses and purpose of LocalDb.Connection string about LocalDb.Model Binding.What is DBContext class ?Step by...

Select * from(SELECT 0 as SORTCOLUMN, -1 AS [KEY], 'Select' AS [VALUE]UNION allSELECT 1 AS SORTCOLUMN, PARAMALLOWEDVALUEID AS [KEY], PARAMETERVALUE AS [VALUE]FROM ICM_COMMPARAMALLOWDVALUE where PARAMETERID = 1 AND ISACTIVE = 1) tbl order by case when SORTCOLUMN=0 then 3 else 1 end,[value] ...

namespace CSSI.VUE.Web.API.Controllers{public class ProducerEligibiltyController : ApiController{ [CSSIScope("GET_PRODUCER_ELIGIBILITY")][HttpGet]public ResponseMessageResult Get(string ApplicationSignedDate,string CarrierCode,string LOB,string SitusState,string RequestType,string AgentCode = null,string WritingNumber...