Wcf Ria Services学习笔记（一）:开发前的准备工作

(一)环境搭建（以vs2010环境搭建Silverlight4为列）

       在安装好了vs2010的情况下，其实搭建silverlight开发环境很简单的，步骤如下：

     （1）安装Silverlight4_Tools.exe,这个已经包含了RiaServices的安装（如果是vs2008中搭建sl3时还要另装RiaServices ）

       (2)安装Silverlight_4_Toolkit_April_2010.msi（这个是个控件包），这个是可选安装，但因为我们要用到如DataForm等控件，所以最好安装（其中April为版本的时间，你的版本有肯能不同！）

(二)准备数据库        

     为了简单明了的学习和掌握Wcf Ria Services准备运用学生选课数据库，作为开发的数据库。创建数据库所运用的脚本如下： use master go create database xscj go use xscj go create table Student (StudentID char(6) not null primary key, StudentName char(8), Major char(10), Sex bit default 1, Birthday smalldatetime, TotalCredit tinyint, Remark text) go create table Course (CourseID char(3) not null primary key, CourseName char(16), TotalTerm tinyint default 1, check(TotalTerm>=1 and TotalTerm<=8), CreditHour tinyint, Credit tinyint) go create table Student_Course ( ID int identity(1,1) primary key, StudentID char(6) not null references Student(StudentID) , CourseID char(3) not null references Course(CourseID), Score tinyint, Credit tinyint) go insert into Student values('001101','王林','计算机',1,'1980-2-10',50,null) insert into Student values('001102','程明','计算机',1,'1981-2-1',50,null) insert into Student values('001103','王燕','计算机',0,'1979-10-6',50,null) insert into Student values('001104','伟严严','计算机',1,'1980-8-26',50,null) insert into Student values('001106','李芳芳','计算机',1,'1980-11-20',50,null) insert into Student values('001107','李明','计算机',1,'1980-5-1',54,'提前修完《数据结构》，并获学分') insert into Student values('001108','林一帆','计算机',1,'1979-8-5',52,'已提前修完一门课') insert into Student values('001109','张强明','计算机',1,'1978-8-11',50,null) insert into Student values('001110','张蔚','计算机',0,'1981-7-22',50,'三好学生') insert into Student values('001111','赵琳','计算机',0,'1980-3-18',50,null) insert into Student values('001113','严红','计算机',0,'1979-7-13',48,'有一门功课不及格，待补考') insert into Student values('001201','李红庆','通信工程',1,'1979-5-11',40,'有一门不及格，待补考') insert into Student values('001202','孙详欣','通信工程',1,'1979-6-11',42,null) insert into Student values('001203','孙研','通信工程',1,'1978-6-10',42,null) insert into Student values('001204','吴薇华','通信工程',0,'1978-6-1',42,null) insert into Student values('001206','刘燕敏','通信工程',0,'1979-9-20',42,null) insert into Student values('001210','罗林琳','通信工程',0,'1979-5-1',44,'已提前修完一门，并获得学分') insert into Student values('001216','李计','通信工程',1,'1978-3-9',42,null) insert into Student values('001218','马琳琳','通信工程',0,'1980-10-9',42,null) insert into Student values('001220','王玉民','通信工程',1,'1980-3-18',42,null) insert into Student values('001221','王林','通信工程',0,'1979-11-13',42,null) insert into Student values('001241','王敏','通信工程',0,'1980-1-30',50,'转专业学习') insert into Course values('101','计算机基础',1,80,5) insert into Course values('102','程序设计与语言',2,68,4) insert into Course values('206','离散数学',4,68,4) insert into Course values('208','数据结构',5,68,4) insert into Course values('209','操作系统',6,68,4) insert into Course values('210','计算机原理',5,85,5) insert into Course values('212','数据库原理',7,68,4) insert into Course values('301','计算机网络',7,51,3) insert into Course values('302','软件工程',7,51,3) insert into Course values('304','算法',7,51,3) insert into Course values('305','软件设计',7,51,3) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001101','101',80,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001101','102',78,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001101','206',76,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001103','101',76,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001103','102',72,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001103','206',70,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001106','101',65,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001106','102',71,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001106','206',85,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001104','101',90,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001104','102',84,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001104','206',65,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001102','102',78,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001102','206',78,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001107','101',78,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001107','102',80,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001107','206',68,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001108','101',85,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001108','102',64,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001108','206',87,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001109','101',66,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001109','102',83,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001109','206',70,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001110','101',95,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001110','102',90,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001110','206',89,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001111','101',91,null) insert into Student_Course(StudentID,CourseID,Score,Credit) values('001111','102',70,null) go --新建视图 create view view_Stuent_StudentCourse as select Student.StudentID,Student.StudentName,CourseName,Score from Student,Student_Course,Course where Student.StudentID=Student_Course.StudentID and Student_Course.CourseID=Course.CourseID ; go select *from view_Stuent_StudentCourse go --自定义函数 create function fun_average(@cnum char(20)) returns int as begin declare @aver int select @aver=(select AVG(Score) from Student_Course where CourseID=@cnum group by CourseID) return @aver end go --调用自定义函数 declare @course char(20) declare @aver int select @course='101' select @aver=dbo.fun_average(@course) select @aver as '101课程的平均成绩' go /*带输出参数的存储过程*/ create procedure totalcredit(@name varchar(40),@total int output) as select @total=SUM(score) from Student,Student_Course where Student.StudentID=Student_Course.StudentID and StudentName=@name group by Student.StudentID go --调用存储过程 declare @total int EXECUTE totalcredit '王林',@total output select '王林',@total go /*带输入参数的存储过程*/ create procedure SP_StudentInfo @studentName char(8),@courseName char(16) as select s.StudentID,s.StudentName,CourseName,Score,sc.Credit from Student s inner join Student_Course sc on s.StudentID=sc.StudentID inner join Course c on sc.CourseID=c.CourseID where s.StudentName=@studentName and c.CourseName=@courseName; --调用存储过程 exec SP_StudentInfo '王林','计算机基础' go /*不带任何参数的存储过程(只是执行一种操作)*/ create procedure sp_SelectAllStudent as select *from Student go --调用存储过程 exec SP_SelectAllStudent go

         在查询分析器里运行脚本得到数据xscj，下面的工作就可以陆续展开了！