Download Source Code

By Usama Wahab Khan

Passion to share . Learn Free!

WCF DataSerivce and EntityFramework Provideing wornderful Rest Web Service

so i am try to domeistrate Copy Record Update Delete database Functions In Silverlight Application or Call View,Stored Procedure and call dumay entity for complex type Before using this app plase check connectionsstring and database

Download Source code

by

Usama Wahab Khan

ADO.Net

---------------------SqlQuerys------------------------------------------
Select * from TableName or ViewName


Insert Into TableName
(colname,colname)
values
('calvalue','colvalue')


UPdate TableName
set ColumnName='Value', ColumnName='Value'


---------------------------------------ConnectionString---------
Data Source=myServerAddress;Initial Catalog=myDataBase;User
Id=myUsername;Password=myPassword;

SqlConnection cn = new SqlConnection("Data
Source=-SERVER\\express;Initial Catalog=GIS;Integrated Security=True");;


----------------------------------Disconnected
Ado.net-------------------------------------


xxxConnection cn = new xxxConnection();
xxxDataAdapter da = new xxxDataAdapter("Select * from",cn);
DataSet ds = new DataSet();
da.Fill(ds);
---------------- Data will be loaded in Dataset(ds) NOw you can change data--
---------------------After Change Data in Ds to save data In database -----
ds.AcceptChanges();
da.Update(ds);

----------------------------------connected
Ado.net-------------------------------------



xxxConnection cn = new xxxConnection();

xxxCommand cmd = new xxxCommand("SqlQuery",cn);

try
{
//Select Command
SqlCommand cmd = new SqlCommand("Select * From app_users", cn);
//Check Connection State and Open it
if (cn.State != System.Data.ConnectionState.Open) { cn.Open(); }
//Executereader to fatch data;
SqlDataReader reader = cmd.ExecuteReader();
//Read Data Till Last Record from While
while (reader.Read())
{
Console.WriteLine(reader[1].ToString());
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
//last close connectionString
cn.Close();

}
Console.ReadLine();

Microsoft .net framework 4 have usefull enhancements in there Data-services model After the WCf For quite long Microsoft .net Providing such useful services fro client and server side features One of Most Beautful enhancements .net is WCF Data Services (former "ADO.NET Data Services") whichImproved data binding ,Server side Paging ,Count and Enhanced Blob support.Wcf Data Service are allow to Create Open Data Protocol (OData) to expose and consume data over the Web or intranet by using the semantics of representational state transfer (REST).OData exposes data as resources that are addressed by URIs(uniform resource identifier).Data can accessed by Get,POst and other http varbs, Wcf DataServices

use Entity Data Model to Provide entity-relationship conventions. for more

Download SourceCode