{"id":66,"date":"2016-10-26T02:43:53","date_gmt":"2016-10-26T02:43:53","guid":{"rendered":"http:\/\/www.softwaretraininginchennai.com\/blog\/?p=66"},"modified":"2017-02-10T03:06:35","modified_gmt":"2017-02-10T03:06:35","slug":"create-wcf-application-for-crud-operation","status":"publish","type":"post","link":"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/","title":{"rendered":"Create wcf Application for CRUD operation"},"content":{"rendered":"
\n

Document by Ganesan – Ganesanva@hotmail.com – + 919600370429<\/span><\/h2>\n

-Create StudentDetails<\/strong> Table in Local DB
\n\"\"
\nRight Click on the DB and Click Properties.
\n\"\"
\nConnection String can be seen in Property window.
\n\"\"
\n– Create a new WCF Service Application.
\nPut the connection string above in Web.config as in Snippet.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
<connectionStrings>
\n<add name=”TestConnection” connectionString=”Data Source=(LocalDb)\\v11.0;Initial Catalog=TestDB;Integrated Security=True;Pooling=False” providerName=”System.Data.SqlClient” \/>
\n<\/connectionStrings><\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\"\"
\nCreate StudentDetails.cs<\/strong> Class file as below.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
[DataContract]
\npublic class StudentDetails
\n{
\n[DataMember]
\npublic int Id { get; set; }
\n[DataMember]
\npublic string StudentName { get; set; }
\n[DataMember]
\npublic int? Age { get; set; }
\n}<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Create DBContext.Cs file as below<\/p>\n

\n\n\n<\/colgroup>\n\n\n
public class UsersContext : DbContext
\n{
\npublic UsersContext()
\n: base(“TestConnection”)
\n{
\n}
\npublic DbSet<StudentDetails> studentDbset { get; set; }
\n}<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Open the default interface file IService1.cs<\/strong>
\n\"\"
\nInsert the Snippet as below<\/p>\n

\n\n\n<\/colgroup>\n\n\n
[OperationContract]
\nList<StudentDetails> GetStudentData();
\n[OperationContract]
\nstring CreateStudentData(StudentDetails objStudentDetails);
\n[OperationContract]
\nstring UpdateStudentData(StudentDetails objStudentDetails);
\n[OperationContract]
\nStudentDetails GetStudentDatabyID(int id = 0);<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Implement the below code in Service1.Svc.cs<\/strong>
\n\"\"
\nCode Snippet<\/strong><\/p>\n

\n\n\n<\/colgroup>\n\n\n
public List<StudentDetails> GetStudentData()
\n{
\nreturn db.studentDbset.ToList();
\n}
\npublic string CreateStudentData(StudentDetails objStudentDetails)
\n{
\ndb.studentDbset.Add(objStudentDetails);
\ndb.SaveChanges();
\nreturn “Added”;
\n}
\npublic string UpdateStudentData(StudentDetails objStudentDetails)
\n{
\ndb.Entry(objStudentDetails).State = EntityState.Modified;
\ndb.SaveChanges();
\nreturn “Updated”;
\n}
\npublic StudentDetails GetStudentDatabyID(int id = 0)
\n{
\nStudentDetails studentdetails = db.studentDbset.Find(id);
\nreturn studentdetails;
\n}<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Run the Service application as below
\n\"\"
\nClick on the Link below to get the sample solution
\nhttps:\/\/1drv.ms\/u\/s!ArddhCoxftkQg6gdCJeDrlqBAJE0vg<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Document by Ganesan – Ganesanva@hotmail.com – + 919600370429 -Create StudentDetails Table in Local DB Right Click on the DB and Click Properties. Connection String can be seen in Property window. – Create a new WCF Service Application. Put the connection string above in Web.config as in Snippet. <connectionStrings> <add name=”TestConnection” connectionString=”Data Source=(LocalDb)\\v11.0;Initial Catalog=TestDB;Integrated Security=True;Pooling=False” providerName=”System.Data.SqlClient” […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,1],"tags":[14,31,34,61,67,69,106,111,122,150,152,153,154,157,158],"class_list":["post-66","post","type-post","status-publish","format-standard","hentry","category-information-on-dotnet","category-uncategorized","tag-net-training-in-chennai","tag-communication-using-wcf","tag-create-wcf-service","tag-dotnet-training-in-guindy","tag-expose-methods-using-wcf","tag-free-wcf-demo","tag-online-dotnet-demo","tag-online-wcf-tutorial","tag-rest-service-in-net","tag-wcf-online-training","tag-wcf-service-application","tag-wcf-service-in-net","tag-wcf-service-library","tag-wcf-training-in-chennai","tag-wcf-training-in-guindy"],"yoast_head":"\nCreate wcf Application for CRUD operation | Maria Academy<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create wcf Application for CRUD operation | Maria Academy\" \/>\n<meta property=\"og:description\" content=\"Document by Ganesan – Ganesanva@hotmail.com – + 919600370429 -Create StudentDetails Table in Local DB Right Click on the DB and Click Properties. Connection String can be seen in Property window. – Create a new WCF Service Application. Put the connection string above in Web.config as in Snippet. <connectionStrings> <add name=”TestConnection” connectionString=”Data Source=(LocalDb)v11.0;Initial Catalog=TestDB;Integrated Security=True;Pooling=False” providerName=”System.Data.SqlClient” […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/\" \/>\n<meta property=\"og:site_name\" content=\"Maria Academy\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DotnetTrainingChennai\" \/>\n<meta property=\"article:published_time\" content=\"2016-10-26T02:43:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-02-10T03:06:35+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102616_0243_CreatewcfAp1.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dotnettraining2\" \/>\n<meta name=\"twitter:site\" content=\"@dotnettraining2\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e\"},\"headline\":\"Create wcf Application for CRUD operation\",\"datePublished\":\"2016-10-26T02:43:53+00:00\",\"dateModified\":\"2017-02-10T03:06:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/\"},\"wordCount\":251,\"image\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102616_0243_CreatewcfAp1.png\",\"keywords\":[\".net training in Chennai\",\"Communication using WCF\",\"Create Wcf service\",\"Dotnet training in Guindy\",\"Expose methods using WCF\",\"Free WCF demo\",\"Online dotnet demo\",\"Online WCF tutorial\",\"Rest Service in .net\",\"WCF online Training\",\"WCF service application\",\"Wcf Service in .net\",\"Wcf service library\",\"WCF training in chennai\",\"WCF Training in Guindy\"],\"articleSection\":[\"information on dotnet\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/\",\"url\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/\",\"name\":\"Create wcf Application for CRUD operation | Maria Academy\",\"isPartOf\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102616_0243_CreatewcfAp1.png\",\"datePublished\":\"2016-10-26T02:43:53+00:00\",\"dateModified\":\"2017-02-10T03:06:35+00:00\",\"author\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/#primaryimage\",\"url\":\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102616_0243_CreatewcfAp1.png\",\"contentUrl\":\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102616_0243_CreatewcfAp1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create wcf Application for CRUD operation\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#website\",\"url\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/\",\"name\":\"Maria Academy\",\"description\":\"Dot Net Training in Chennai, Best Dot Net Training Institute in Chennai, .Net Training in Chennai\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g\",\"caption\":\"admin\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Create wcf Application for CRUD operation | Maria Academy","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/","og_locale":"en_US","og_type":"article","og_title":"Create wcf Application for CRUD operation | Maria Academy","og_description":"Document by Ganesan – Ganesanva@hotmail.com – + 919600370429 -Create StudentDetails Table in Local DB Right Click on the DB and Click Properties. Connection String can be seen in Property window. – Create a new WCF Service Application. Put the connection string above in Web.config as in Snippet. <connectionStrings> <add name=”TestConnection” connectionString=”Data Source=(LocalDb)v11.0;Initial Catalog=TestDB;Integrated Security=True;Pooling=False” providerName=”System.Data.SqlClient” […]","og_url":"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/","og_site_name":"Maria Academy","article_publisher":"https:\/\/www.facebook.com\/DotnetTrainingChennai","article_published_time":"2016-10-26T02:43:53+00:00","article_modified_time":"2017-02-10T03:06:35+00:00","og_image":[{"url":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102616_0243_CreatewcfAp1.png","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_creator":"@dotnettraining2","twitter_site":"@dotnettraining2","twitter_misc":{"Written by":"admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/#article","isPartOf":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/"},"author":{"name":"admin","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e"},"headline":"Create wcf Application for CRUD operation","datePublished":"2016-10-26T02:43:53+00:00","dateModified":"2017-02-10T03:06:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/"},"wordCount":251,"image":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/#primaryimage"},"thumbnailUrl":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102616_0243_CreatewcfAp1.png","keywords":[".net training in Chennai","Communication using WCF","Create Wcf service","Dotnet training in Guindy","Expose methods using WCF","Free WCF demo","Online dotnet demo","Online WCF tutorial","Rest Service in .net","WCF online Training","WCF service application","Wcf Service in .net","Wcf service library","WCF training in chennai","WCF Training in Guindy"],"articleSection":["information on dotnet"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/","url":"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/","name":"Create wcf Application for CRUD operation | Maria Academy","isPartOf":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/#primaryimage"},"image":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/#primaryimage"},"thumbnailUrl":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102616_0243_CreatewcfAp1.png","datePublished":"2016-10-26T02:43:53+00:00","dateModified":"2017-02-10T03:06:35+00:00","author":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e"},"breadcrumb":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/#primaryimage","url":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102616_0243_CreatewcfAp1.png","contentUrl":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/10\/102616_0243_CreatewcfAp1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/create-wcf-application-for-crud-operation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.softwaretraininginchennai.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Create wcf Application for CRUD operation"}]},{"@type":"WebSite","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#website","url":"https:\/\/www.softwaretraininginchennai.com\/blog\/","name":"Maria Academy","description":"Dot Net Training in Chennai, Best Dot Net Training Institute in Chennai, .Net Training in Chennai","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.softwaretraininginchennai.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g","caption":"admin"}}]}},"_links":{"self":[{"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/posts\/66","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/comments?post=66"}],"version-history":[{"count":1,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/posts\/66\/revisions"}],"predecessor-version":[{"id":304,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/posts\/66\/revisions\/304"}],"wp:attachment":[{"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/media?parent=66"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/categories?post=66"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/tags?post=66"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}