Data Services (aka Astoria) : CRUD (Select / Insert / Update / Delete )
Creating Astoria is very easy and many of you might have tried that out. What important for us is to work with that data. If you are developing Visual Studio Solution then things are quite obvious as mentioned below,
Either you will have Astoria or you will create that service. I am not going in details how you can create that. Assume that you have a service running anywhere.
You create your client apps (Windows / Web) and the reference an assembly “System.Data.Services.Client”.
After that you need to create “Service Reference” like WCF / Web Service from your visual studio project. Add the required namespace on top of your code behind file where you are writing your code.
C : Create / Inserting Data
static void Main(string[] args)
{
//Initialize the consumed Astoria Service
DataServiceContext ctx = new DataServiceContext(new Uri(@"https://localhost:1116/TestDataService.svc/"));
//This option is very important for Inserting
ctx.MergeOption = MergeOption.AppendOnly;
//Create a new object to insert
Emp emp = new Emp() { Name = "Astoria Employee" };
//Add to the collection
ctx.AddObject("Emp", emp);
//Commit the changes to Database
ctx.SaveChanges();
}
U : Updating Data
static void Main(string[] args)
{
//Initialize the consumed Astoria Service
TestDataEntities ctx = new TestDataEntities(new Uri(@"https://localhost:1116/TestDataService.svc/"));
//Create a new object to insert
Emp emp = (from e in ctx.Emp where e.Id == 81 select e).First();
//Change the Employee Name
emp.Name = DateTime.Now.ToString();
//Update the collection
ctx.UpdateObject(emp);
//Commit the changes to Database
ctx.SaveChanges();
}
D : Deleting Data
static void Main(string[] args)
{
//Initialize the consumed Astoria Service
TestDataEntities ctx = new TestDataEntities(new Uri(@"https://localhost:1116/TestDataService.svc/"));
//Create a new object to insert
Emp emp = (from e in ctx.Emp where e.Id == 80 select e).First();
//Delete the entity
ctx.DeleteObject(emp);
//Commit the changes to Database
ctx.SaveChanges();
}
R : Read / Querying Astoria Service
static void Main(string[] args)
{
//Initialize the consumed Astoria Service
TestDataEntities ctx = new TestDataEntities(new Uri(@"https://localhost:1116/TestDataService.svc/"));
//Create a new object to insert
IEnumerable<Emp> emps = from e in ctx.Emp select e;
foreach (Emp emp in emps)
{
Console.WriteLine("Employee Id : [{0,2}] Name : {1}", emp.Id, emp.Name );
}
}
Namoskar!!!
Comments
Anonymous
April 12, 2009
PingBack from http://asp-net-hosting.simplynetdev.com/data-services-aka-astoria-crud-select-insert-update-delete/Anonymous
May 21, 2009
This article has been very helpful. An experience I had though was a problem if I made any changes on the server or viewed the datasource on the server then there would be an application error and I would have to upload the edmx files again to resolve it. this was quite speradic which had lead to quite a lot of debugging problems.