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!!!