【linq to sql】步骤

最新推荐文章于 2024-07-19 09:45:38 发布
最新推荐文章于 2024-07-19 09:45:38 发布
阅读量778 收藏
点赞数
分类专栏： C# 文章标签： C# linq to sql
本博客所有公开的原创博文皆允许转载，无须再征求作者本人（也就是我）同意
本文链接：https://blog.csdn.net/for_cxc/article/details/51250918
版权

1、新建项目--> 类库   假设命名为A

2、在 A 下 添加新项--> linq to sql class   假设命名为 aa.dbml  此时会看到一个设计页面

3、服务器资源管理器-->新建连接-->添加你的数据库连接

4、把需要的表一个个拖到 设计页面，然后 Ctrl + S 保存

5、生成或重新生成，此时bin目录下会有个 dll 文件

6、在你要使用linq to sql 的项目中引用这个类库然后就可以CRUD了

=========================================================下面是个小小的示例，只有插入操作=======================

using System.IO;
using System.Net;
using System.Text;
using System.Xml;
using System;
using Newtonsoft.Json;
using System.Drawing;
using System.Drawing.Imaging;
using Newtonsoft.Json.Linq;
using ConsoleApplication4.com.fengjing.travel;
using System.Collections.Generic;
using System.Threading;
using System.Linq;
using LinqToSqlDemo.Orm;
/*
 http://travel.fengjing.com/HolidaySvc.asmx
{"RCode":"fengjing@#*!2014","ClientType":"1","Module":"scenic","Method":"GetScenicPicList","Data":"11749"}   图片     
{"RCode":"fengjing@#*!2014","ClientType":"1","Module":"scenic","Method":"GetScenicLBS","Data":{"scenicId":"11749"}}   坐标
{"RCode":"fengjing@#*!2014","ClientType":"1","Module":"scenic","Method":"getscenicofvoice","Data":{"scenicId":"11749","userId":""}}  景区+所有子景点列表
{"RCode":"fengjing@#*!2014","ClientType":"1","Module":"scenic","Method":"getsceniclistofcity","Data":{"PageIndex":3,"PageSize":20,"QueryDict":{"cityname":"无锡","voice":"1"}}} 所有景区第3页
{"RCode":"fengjing@#*!2014","ClientType":"1","Module":"scenic","Method":"getsceniclistofcity","Data":{"PageIndex":1,"PageSize":20,"QueryDict":{"cityname":"无锡","voice":"1"}}} 所有景区第1页
{"RCode":"fengjing@#*!2014","ClientType":0,"Module":"SmartTour","Method":"GetRegionList","Data":{"RegionKey":""}}  所有城市
*/
class City
{
    public string Initial { get; set; }
    public string Code { get; set; }
    public string Parent { get; set; }
    public string Name { get; set; }
    public string IsSmartTourCity { get; set; }
}
class Scenic
{
    public string ScenicId { get; set; }
    public string SName { get; set; }
    public string PriceNotes { get; set; }
    public string City { get; set; }
    public string County { get; set; }
    public string Level { get; set; }
    public string ScenicMes { get; set; }
    public string ScenicPic { get; set; }
    public string ListionVoiceCount { get; set; }
    public string TicketCounT { get; set; }
    public string SalePrice { get; set; }
    public string voice_Picture { get; set; }
    public string isVoice { get; set; }
    public string isPiao { get; set; }
    public string lon { get; set; }
    public string lat { get; set; }
    public string Address { get; set; }
    public string Score { get; set; }
    public string CommentCount { get; set; }
    public string CommentList { get; set; }
    public string FavoriteCountOfPiao { get; set; }
    public string IsFavoriteOfPiao { get; set; }
    public string FavoriteCountOfVoice { get; set; }
    public string IsFavoriteOfVoice { get; set; }
    public string VoiceFile { get; set; }
    public string scenicDistance { get; set; }
    public string PicCount { get; set; }
    public string LocalVoiceCount { get; set; }
    public string LocalVoiceTypeCount { get; set; }
}
class Scenic1
{
    public string ScenicId { get; set; }
    public string SName { get; set; }
    public string PriceNotes { get; set; }
    public string City { get; set; }
    public string County { get; set; }
    public string Level { get; set; }
    public string ScenicMes { get; set; }
    public string ScenicPic { get; set; }
    public string ListionVoiceCount { get; set; }
    public string TicketCounT { get; set; }
    public string SalePrice { get; set; }
    public string voice_Picture { get; set; }
    public string isVoice { get; set; }
    public string isPiao { get; set; }
    public string lon { get; set; }
    public string lat { get; set; }
    public string mapPath { get; set; }
    public string Address { get; set; }
    public string Score { get; set; }
    public string FavoriteCountOfVoice { get; set; }
    public string IsFavoriteOfVoice { get; set; }
    public string IsScenicTrfface { get; set; }
    public string IsScenicNews { get; set; }
    public string IsScenicCustom { get; set; }
    public string IsScenicFood { get; set; }
    public string scType { get; set; }
    public string Traffic { get; set; }
    public string PicCount { get; set; }
}
class ScenicChild
{
    public string ScenicId { get; set; }
    public string SpotId { get; set; }
    public string FileName { get; set; }
    public string FileSize { get; set; }
    public string InertTimeStr { get; set; }
    public string SummaryTxt { get; set; }
    public string ImgPath { get; set; }
    public string SpotName { get; set; }
    public string FileExt { get; set; }
    public string FileNameShort { get; set; }
    public string localvoicelist { get; set; }
}
class Spot
{
    public string Title { get; set; }
    public string XCoord { get; set; }
    public string YCoord { get; set; }
    public string ScenicId { get; set; }
    public string SpotId { get; set; }
    public string SpotName { get; set; }
}

namespace ConsoleApplication2
{
    class Program
    {
        private static DataClassesDataContext dataContext = new DataClassesDataContext();
        public static HolidaySvc svc = new HolidaySvc();

        public static int CityCount;  //城市个数
        public static int ScenicCount;  //每个城市景点个数
        public static int ScenicChildCount;  //每个景点语音个数
        public static int ImgUrlCount;  //图片个数
        public static int SpotCount;   //现场个数
        public static City[] city = new City[500];
        public static Scenic1 scenic1 = new Scenic1();
        public static ScenicChild[] scenicchild = new ScenicChild[100];
        public static string[] url = new string[50];
        public static Spot[] spot = new Spot[100];
        public static void getCityArray()
        {
            string senddata = "{\"RCode\":\"fengjing@#*!2014\",\"ClientType\":0,\"Module\":\"SmartTour\",\"Method\":\"GetRegionList\",\"Data\":{\"RegionKey\":\"\"}}";
            try
            {
                string ss = svc.RequestServiceData(senddata);
                ss = "[" + ss + "]";
                JArray jsonObj = JArray.Parse(ss);
                JObject j = (JObject)jsonObj.First;
                j = (JObject)j["Data"];
                jsonObj = (JArray)j["Citys"];

                foreach (JObject jObject in jsonObj)
                {
                    city[CityCount] = new City();
                    city[CityCount].Initial = jObject["Initial"].ToString();
                    city[CityCount].Code = jObject["Code"].ToString();
                    city[CityCount].Parent = jObject["Parent"].ToString();
                    city[CityCount].Name = jObject["Name"].ToString();
                    city[CityCount].IsSmartTourCity = jObject["IsSmartTourCity"].ToString();
                    CityCount++;
                }
            }
            catch
            {
                Console.ForegroundColor = ConsoleColor.Red;
                Console.WriteLine("获取城市超时");
                Console.ForegroundColor = ConsoleColor.Green;
            }
        }
        public static void CreateScenicArray(string city)
        {
            List<Scenic> scenic = new List<Scenic>();
            ScenicCount = 0;
            for (int i = 1; i < 50; i++)
            {
                string senddata = "{\"RCode\":\"fengjing@#*!2014\",\"ClientType\":\"1\",\"Module\":\"scenic\",\"Method\":\"getsceniclistofcity\",\"Data\":{\"PageIndex\":" + i.ToString() + ",\"PageSize\":20,\"QueryDict\":{\"cityname\":\"" + city + "\",\"voice\":\"1\"}}}";
                try
                {
                    string s = svc.RequestServiceData(senddata);
                    s = "[" + s + "]";
                    JArray jsonObj = JArray.Parse(s);
                    JObject j = (JObject)jsonObj.First;
                    string f = j["Data"].ToString();
                    if (f == "")
                    {
                        break;
                    }
                    jsonObj = (JArray)j["Data"];
                    foreach (JObject jObject in jsonObj)
                    {
                        var sc = new Scenic();
                        sc.ScenicId = jObject["ScenicId"].ToString();
                        sc.SName = jObject["SName"].ToString();
                        sc.PriceNotes = jObject["PriceNotes"].ToString();
                        sc.City = jObject["City"].ToString();
                        sc.County = jObject["County"].ToString();
                        sc.Level = jObject["Level"].ToString();
                        sc.ScenicMes = jObject["ScenicMes"].ToString();
                        sc.ScenicPic = jObject["ScenicPic"].ToString();
                        sc.ListionVoiceCount = jObject["ListionVoiceCount"].ToString();
                        sc.TicketCounT = jObject["TicketCounT"].ToString();
                        sc.SalePrice = jObject["SalePrice"].ToString();
                        sc.voice_Picture = jObject["voice_Picture"].ToString();
                        sc.isVoice = jObject["isVoice"].ToString();
                        sc.isPiao = jObject["isPiao"].ToString();
                        sc.lon = jObject["lon"].ToString();
                        sc.lat = jObject["lat"].ToString();
                        sc.Address = jObject["Address"].ToString();
                        sc.Score = jObject["Score"].ToString();
                        sc.CommentCount = jObject["CommentCount"].ToString();
                        sc.CommentList = jObject["CommentList"].ToString();
                        sc.FavoriteCountOfPiao = jObject["FavoriteCountOfPiao"].ToString();
                        sc.IsFavoriteOfPiao = jObject["IsFavoriteOfPiao"].ToString();
                        sc.FavoriteCountOfVoice = jObject["FavoriteCountOfVoice"].ToString();
                        sc.IsFavoriteOfVoice = jObject["IsFavoriteOfVoice"].ToString();
                        sc.VoiceFile = jObject["VoiceFile"].ToString();
                        sc.scenicDistance = jObject["scenicDistance"].ToString();
                        sc.PicCount = jObject["PicCount"].ToString();
                        sc.LocalVoiceCount = jObject["LocalVoiceCount"].ToString();
                        sc.LocalVoiceTypeCount = jObject["LocalVoiceTypeCount"].ToString();

                        scenic.Add(sc);
                        ScenicCount++;
                    }
                }
                catch
                {
                    Console.ForegroundColor = ConsoleColor.Red;
                    Console.WriteLine("获取景点超时");
                    Console.ForegroundColor = ConsoleColor.Green;  
                }
            }
            if (scenic.Count < 3)
            {
                Console.ForegroundColor = ConsoleColor.Red;
                Console.WriteLine(city + " 城市无景点");
                Console.ForegroundColor = ConsoleColor.Green;
                return;
            }
            foreach (var sc in scenic.Skip(2).ToList())
            {
                try
                {
                    LinqToSqlDemo.Orm.Scenic ss = new LinqToSqlDemo.Orm.Scenic()
                    {
                        ScenicId = sc.ScenicId,
                        SName = sc.SName,
                        PriceNotes = sc.PriceNotes,
                        City = sc.City,
                        County = sc.County,
                        Level1 = sc.Level,
                        ScenicMes = sc.ScenicMes,
                        ScenicPic = sc.ScenicPic,
                        ListionVoiceCount = sc.ListionVoiceCount,
                        TicketCounT = sc.TicketCounT,
                        SalePrice = sc.SalePrice,
                        voice_Picture = sc.voice_Picture,
                        isVoice = sc.isVoice,
                        isPiao = sc.isPiao,
                        lon = sc.lon,
                        lat = sc.lat,
                        Address = sc.Address,
                        Score = sc.Score,
                        CommentCount = sc.CommentCount,
                        CommentList = sc.CommentList,
                        FavoriteCountOfPiao = sc.FavoriteCountOfPiao,
                        IsFavoriteOfPiao = sc.IsFavoriteOfPiao,
                        FavoriteCountOfVoice = sc.FavoriteCountOfVoice,
                        IsFavoriteOfVoice = sc.IsFavoriteOfVoice,
                        VoiceFile = sc.VoiceFile,
                        scenicDistance = sc.scenicDistance,
                        PicCount = sc.PicCount,
                        LocalVoiceCount = sc.LocalVoiceCount,
                        LocalVoiceTypeCount = sc.LocalVoiceTypeCount
                    };
                    dataContext.Scenic.InsertOnSubmit(ss);
                    dataContext.SubmitChanges();
                }
                catch (Exception e)
                {
                    Console.ForegroundColor = ConsoleColor.Red;
                    Console.WriteLine(e.Message + "-----" + city + " 城市有景点但出异常");
                    Console.ForegroundColor = ConsoleColor.Green; 
                }

                try
                {
                    //CreateScenic1(sc.ScenicId);
                    CreateScenic1Child(sc.ScenicId);
                }
                catch (Exception e)
                {
                    Console.ForegroundColor = ConsoleColor.Red;
                    Console.WriteLine(e.Message + "CreateScenic1错误");
                    Console.ForegroundColor = ConsoleColor.Green; 
                }

                try
                {
                    CreateImg(sc.ScenicId);
                }
                catch (Exception e)
                {
                    Console.ForegroundColor = ConsoleColor.Red;
                    Console.WriteLine(e.Message + "CreateImg错误");
                    Console.ForegroundColor = ConsoleColor.Green; 
                }

                try
                {
                    CreateSpot(sc.ScenicId);
                }
                catch (Exception e)
                {
                    Console.ForegroundColor = ConsoleColor.Red;
                    Console.WriteLine(e.Message + "CreateSpot错误");
                    Console.ForegroundColor = ConsoleColor.Green;  
                }
            }
        }
        public static void CreateScenic1(string id)
        {
            string senddata = "{\"RCode\":\"fengjing@#*!2014\",\"ClientType\":\"1\",\"Module\":\"scenic\",\"Method\":\"getscenicofvoice\",\"Data\":{\"scenicId\":\"" + id + "\",\"userId\":\"\"}}";
            string s = svc.RequestServiceData(senddata);
            s = "[" + s + "]";
            JArray jsonObj = JArray.Parse(s);
            JObject j = (JObject)jsonObj.First;
            j = (JObject)j["Data"];
            scenic1.ScenicId = j["ScenicId"].ToString();
            scenic1.SName = j["SName"].ToString();
            scenic1.PriceNotes = j["PriceNotes"].ToString();
            scenic1.City = j["City"].ToString();
            scenic1.County = j["County"].ToString();
            scenic1.Level = j["Level"].ToString();
            scenic1.ScenicMes = j["ScenicMes"].ToString();
            scenic1.ScenicPic = j["ScenicPic"].ToString();
            scenic1.ListionVoiceCount = j["ListionVoiceCount"].ToString();
            scenic1.TicketCounT = j["TicketCounT"].ToString();
            scenic1.SalePrice = j["SalePrice"].ToString();
            scenic1.voice_Picture = j["voice_Picture"].ToString();
            scenic1.isVoice = j["isVoice"].ToString();
            scenic1.isPiao = j["isPiao"].ToString();
            scenic1.lon = j["lon"].ToString();
            scenic1.lat = j["lat"].ToString();
            scenic1.mapPath = j["mapPath"].ToString();
            scenic1.Address = j["Address"].ToString();
            scenic1.Score = j["Score"].ToString();
            scenic1.FavoriteCountOfVoice = j["FavoriteCountOfVoice"].ToString();
            scenic1.IsFavoriteOfVoice = j["IsFavoriteOfVoice"].ToString();
            scenic1.IsScenicTrfface = j["IsScenicTrfface"].ToString();
            scenic1.IsScenicNews = j["IsScenicNews"].ToString();
            scenic1.IsScenicCustom = j["IsScenicCustom"].ToString();
            scenic1.IsScenicFood = j["IsScenicFood"].ToString();
            scenic1.scType = j["scType"].ToString();
            scenic1.Traffic = j["Traffic"].ToString();
            scenic1.PicCount = j["PicCount"].ToString();
        }
        public static void CreateScenic1Child(string id)
        {
            List<ScenicChild> lsc = new List<ScenicChild>();
            try
            {
                string senddata = "{\"RCode\":\"fengjing@#*!2014\",\"ClientType\":\"1\",\"Module\":\"scenic\",\"Method\":\"getscenicofvoice\",\"Data\":{\"scenicId\":\"" + id + "\",\"userId\":\"\"}}";
                string s = svc.RequestServiceData(senddata);
                s = "[" + s + "]";
                JArray jsonObj = JArray.Parse(s);
                JObject j = (JObject)jsonObj.First;
                j = (JObject)j["Data"];
                jsonObj = (JArray)j["spotlist"];
                foreach (JObject jObject in jsonObj)
                {
                    var sc = new ScenicChild();
                    sc.ScenicId = jObject["ScenicId"].ToString();
                    sc.SpotId = jObject["SpotId"].ToString();
                    sc.FileName = jObject["FileName"].ToString();
                    sc.FileSize = jObject["FileSize"].ToString();
                    sc.InertTimeStr = jObject["InertTimeStr"].ToString();
                    sc.SummaryTxt = jObject["SummaryTxt"].ToString();
                    sc.ImgPath = jObject["ImgPath"].ToString();
                    sc.SpotName = jObject["SpotName"].ToString();
                    sc.FileExt = jObject["FileExt"].ToString();
                    sc.FileNameShort = jObject["FileNameShort"].ToString();
                    sc.localvoicelist = jObject["localvoicelist"].ToString();

                    lsc.Add(sc);
                    ScenicChildCount++;
                }
            }
            catch
            {
                Console.ForegroundColor = ConsoleColor.Red;
                Console.WriteLine("声音获取超时！");
                Console.ForegroundColor = ConsoleColor.Green;
            }
            if (lsc.Count < 1)
            {
                return;
            }
            try
            {
                foreach(var sc in lsc)
                {
                    ScenicVoice ss = new ScenicVoice()
                    {
                        ScenicId = sc.ScenicId,
                        SpotId = sc.SpotId,
                        FileName = sc.FileName,
                        FileSize = sc.FileSize,
                        InertTimeStr = sc.InertTimeStr,
                        SummaryTxt = sc.SummaryTxt,
                        ImgPath = sc.ImgPath,
                        SpotName = sc.SpotName,
                        FileExt = sc.FileExt,
                        FileNameShort = sc.FileNameShort,
                        localvoicelist = sc.localvoicelist
                    };
                    dataContext.ScenicVoice.InsertOnSubmit(ss);
                    dataContext.SubmitChanges();
                }
            }
            catch(Exception e)
            {
                Console.ForegroundColor = ConsoleColor.Red;
                Console.WriteLine(e.Message + "-----" + "声音写入错误！");
                Console.ForegroundColor = ConsoleColor.Green;
            }
        }
        public static void CreateImg(string id)
        {
            ImgUrlCount = 0;
            try
            {
                string senddata = "{\"RCode\":\"fengjing@#*!2014\",\"ClientType\":\"1\",\"Module\":\"scenic\",\"Method\":\"GetScenicPicList\",\"Data\":\"" + id + "\"}";
                string s = svc.RequestServiceData(senddata);
                s = "[" + s + "]";
                JArray jsonObj = JArray.Parse(s);
                JObject j = (JObject)jsonObj.First;
                jsonObj = (JArray)j["Data"];
                foreach (JObject jObject in jsonObj)
                {
                    url[ImgUrlCount] = jObject["url"].ToString();
                    ImgUrlCount++;
                }
            }
            catch
            {
                Console.ForegroundColor = ConsoleColor.Red;
                Console.WriteLine("图片获取超时！");
                Console.ForegroundColor = ConsoleColor.Green;
            }
            if (ImgUrlCount<1)
            {
                return;
            }

            for (int i = 0; i < ImgUrlCount; i++)
            {
                try
                {
                    Imgs I = new Imgs()
                    {
                        cityid = id,
                        url = url[i],
                    };
                    dataContext.Imgs.InsertOnSubmit(I);
                    dataContext.SubmitChanges();
                }
                catch
                {
                    Console.ForegroundColor = ConsoleColor.Red;
                    Console.WriteLine("图片URL写入失败");
                    Console.ForegroundColor = ConsoleColor.Green;
                }   
            }
        }
        public static void CreateSpot(string id)
        {
            SpotCount = 0;
            try
            {
                string senddata = "{\"RCode\":\"fengjing@#*!2014\",\"ClientType\":\"1\",\"Module\":\"scenic\",\"Method\":\"GetScenicLBS\",\"Data\":{\"scenicId\":\"" + id + "\"}}";
                string s = svc.RequestServiceData(senddata);
                s = "[" + s + "]";
                JArray jsonObj = JArray.Parse(s);
                JObject j = (JObject)jsonObj.First;
                jsonObj = (JArray)j["Data"];
                foreach (JObject jObject in jsonObj)
                {
                    spot[SpotCount] = new Spot();
                    spot[SpotCount].Title = jObject["Title"].ToString();
                    spot[SpotCount].XCoord = jObject["XCoord"].ToString();
                    spot[SpotCount].YCoord = jObject["YCoord"].ToString();
                    spot[SpotCount].ScenicId = jObject["ScenicId"].ToString();
                    spot[SpotCount].SpotId = jObject["SpotId"].ToString();
                    spot[SpotCount].SpotName = jObject["SpotName"].ToString();
                    SpotCount++;
                }
            }
            catch
            {
                Console.ForegroundColor = ConsoleColor.Red;
                Console.WriteLine("景点坐标获取超时！");
                Console.ForegroundColor = ConsoleColor.Green;
            }
            if (SpotCount < 1)
            {
                return;
            }
            for (int i = 0; i < SpotCount; i++)
            {
                try
                {
                    LinqToSqlDemo.Orm.Spot sp = new LinqToSqlDemo.Orm.Spot()
                    {
                        Title = spot[i].Title,
                        XCoord = spot[i].XCoord,
                        YCoord = spot[i].YCoord,
                        ScenicId = spot[i].ScenicId,
                        SpotId = spot[i].SpotId,
                        SpotName = spot[i].SpotName,
                    };
                    dataContext.Spot.InsertOnSubmit(sp);
                    dataContext.SubmitChanges();
                }
                catch
                {
                    Console.ForegroundColor = ConsoleColor.Red;
                    Console.WriteLine("景点坐标写入失败！");
                    Console.ForegroundColor = ConsoleColor.Green;
                }
            }
        }
        public static void downloadPicture(string url, string path)
        {
            try
            {
                Uri uri = new Uri(url);
                WebRequest request = WebRequest.Create(uri);
                WebResponse response = request.GetResponse();
                Stream s = response.GetResponseStream();
                Image image = Image.FromStream(s);
                image.Save(path, ImageFormat.Jpeg);//绝对路径
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message + "图片不存在");
            }

        }
        public static void downloadSound(string url, string path)
        {
            try
            {
                //创建请求
                HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
                //接收响应

                HttpWebResponse response = (HttpWebResponse)request.GetResponse();
                //输出流
                Stream responseStream = response.GetResponseStream();

                using (FileStream fs = new FileStream(path, FileMode.Create, FileAccess.Write))
                {
                    byte[] bufferBytes = new byte[10000];//缓冲字节数组
                    int bytesRead = -1;
                    while ((bytesRead = responseStream.Read(bufferBytes, 0, bufferBytes.Length)) > 0)
                    {
                        fs.Write(bufferBytes, 0, bytesRead);
                    }
                    //关闭写入
                    fs.Flush();
                    fs.Close();

                }
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message + ",文件不存在");
            }
        }
        public static void CreateALL()
        {
            List<string> ll = new List<string>();

            getCityArray();
         
            for (int i = 0; i < CityCount; i++)
            {
                Console.ForegroundColor = ConsoleColor.Green;
                Console.WriteLine(city[i].Name + " 数据正在写入...");
                try
                {
                    LinqToSqlDemo.Orm.City c = new LinqToSqlDemo.Orm.City()
                    {
                        Initial = city[i].Initial,
                        Code = city[i].Code,
                        Parent = city[i].Parent,
                        Name = city[i].Name,
                        IsSmartTourCity = city[i].IsSmartTourCity,
                    };
                    dataContext.City.InsertOnSubmit(c);
                    dataContext.SubmitChanges();
                }
                catch
                {
                    Console.WriteLine(city[i].Name + " 城市写入错误！");
                }
                
                CreateScenicArray(city[i].Name.Replace("市", ""));

                Console.WriteLine(city[i].Name + " 数据已写入！");
            }
        }
        static void Main(string[] args)
        {
            CreateALL();
        }
    }
}


Rand Tsui
关注
专栏目录
linq 连接mysql_浅析LINQ to SQL访问后台数据库步骤
weixin_42429893的博客
02-06 373
本文将为大家讲解LINQ to SQL访问后台数据库步骤，这也是LINQ方法的重要实现。希望本文能对大家有所帮助。我们将用OpenXML SDK 2.0 for Microsoft Office (August 2009 CTP)来生成一个Word文档。我们要写一段程序来访问后台SQL Server数据库，并把返回的数据包在一个表里插入到一个已有的Word文档中。生成一个控制台程序并连接到后台数据...
LINQ_to_sql详细教程
08-11
LINQ_to_sql的入门教程。适合初学者使用。容易上手
LINQ to SQL使用教程
anw53724的博客
02-22 970
前些时间用LINQ to SQL做了一些项目，现在打算总结一下，帮助新手快速入门，并写一些别的教程没提到的东西。 一、LINQ to SQL和别的LINQ to XXX有什么关系？二、延迟执行（Deferred Loading）三、什么是LINQ to SQL？四，看看LINQ to SQL到底干了些啥？——创建自己的工具类五、创建一个基本查询六，大致扫一扫 1，WHERE ...
linq to sql 的介绍和使用及原理
最新发布
战族狼魂的博客
07-19 497
简单来说，LINQ to SQL 允许开发者使用LINQ语法来查询和操作SQL Server数据库，从而实现了对象关系映射（ORM）。：当你使用LINQ语法编写查询时，LINQ to SQL 会将这些查询转换为等效的SQL语句。综上所述，LINQ to SQL 通过对象关系映射和将LINQ查询转换为SQL语句的方式，使得开发者能够使用C#等编程语言来方便地查询和操作SQL Server数据库。然后，它将数据库返回的结果转换回你可以用你的编程语言处理的对象。这个实例将代表与数据库的连接。等关键字来构建查询。
LINQ to sql 学习一
weixin_30915275的博客
07-13 114
什么是Linq to sql 　　Linq to sql(或者叫DLINQ)是LINQ(.NET语言集成查询)的一部分，全称基于关系数据的 .NET 语言集成查询，用于以对象形式管理关系数据，并提供了丰富的查询功能，它和Linq to xml、Linq to objects、Linq to dataset、Linq to entities等组成了强大的LINQ。 　　要学好LINQ查询语法，就...
LINQ To SQL
weixin_30402343的博客
08-29 134
议程 1.LINQ To SQL概述 2.LINQ To SQL对象模型 3.LINQ To SQL查询 用到的数据库 SQL Server 2005，数据库名为Test。 两张表，分别为Student学生表和Score成绩表 LINQ To SQL概述 在 LINQ to SQL 中，关系数据库的数据模型映射到用开发人员所用的编程语言表示的对象模型。当应用程序运行时，LI...
LINQ to SQL语句
GuoHX
11-13 1239
LINQ to SQL语句(1)之Where 适用场景：实现过滤，查询等功能。 说明：与SQL命令中的Where作用相似，都是起到范围限定也就是过滤作用的，而判断条件就是它后面所接的子句。Where操作包括3种形式，分别为简单形式、关系条件形式、First()形式。下面分别用实例举例下： 1.简单形式： 例如：使用where筛选在伦敦的客户var q = from c in
LINQ to SQL数据库同步器
04-11
1. **LINQ-to-SQL-Database-Synchronizer.pdf**：这可能是一个用户手册或技术文档，详细介绍了如何使用这个同步器，包括安装、配置和操作步骤。 2. **下载链接.txt**：可能包含额外资源或更新版本的下载地址。 3. **...
如何处理LINQ to SQL中的并发性？
04-07
在LINQ to SQL的上下文中，处理并发冲突通常涉及以下步骤： 1. **读取数据**：获取并显示数据给用户。 2. **用户修改**：用户对数据进行更改。 3. **保存更改**：调用`DataContext.SubmitChanges()`，此时LINQ to ...
ASP.NET MVC+LINQ TO SQL登陆
11-03
ASP.NET MVC（Model-View-...通过以上步骤，你可以理解如何在ASP.NET MVC项目中结合LINQ to SQL实现一个基本的用户登录功能。这个过程中涉及到了MVC架构的运用、ORM的使用以及数据库操作和用户验证的基本原理。
asp.net使用LINQ to SQL连接数据库及SQL操作语句用法分析
10-22
LINQ to SQL 的基本用法包括几个主要的步骤： 1. 连接数据库：首先需要在 *** 应用中配置和连接到数据库。这通常通过使用 DataContext 类实现，它表示数据库的连接和映射的表。 2. 查询语法：LINQ to SQL 使用的...
Linq to sql 教程
08-23
包含十步讲解Linq to sql 。。。适合初学者
LINQ To SQL 教程
06-22
鉴于近期多位同学向我问起LINQ To SQL的事，为了方便解答，我用自己的项目和辅导员以前的案例做了一个教程，还有不清楚的同学可以翻一下书，比如了解Single，DeleteOnSubmit等方法的调用 为方便浏览和拷贝，另提供图片和文本,已经都上传群共享
LINQ To SQL 语法及实例大全
热门推荐
pan_junbiao的博客
11-26 9万+
LINQ to SQL语句(1)之Where   Where操作   适用场景：实现过滤，查询等功能。   说明：与SQL命令中的Where作用相似，都是起到范围限定也就是过滤作用的，而判断条件就是它后面所接的子句。   Where操作包括3种形式，分别为简单形式、关系条件形式、First()形式。下面分别用实例举例下：   1.简单形式：   例如：使用where筛选在伦
Linq to SQL
萧莯技术知识博客
04-02 231
Linq   to   SQLLINQ to SQL是LINQ中的最重要的一个组件，为.NET Framework 3.5所支持，它可以为关系数据库提供一个对象模型。其中LINQ to SQL最重要的一个功能就是为数据库创建一个对象模型(由基于.NET框架的类组成)，并将该对象模型映射到数据库中的相应对象Datacontext 又称为数据上下文，它是LINQ to SQL提供操作数据库的入口、如果...
译：在C#中使用LINQ To SQL
weixin_33831673的博客
02-05 139
译文出处：http://www.codeproject.com/Tips/871938/LINQ-To-SQL-Using-Csharp  今天在这个话题中，我给大家分享一个在c#编程中非常有趣和十分有用的特性。 开始之前，我想告诉大家关于Linq的基本信息。比如：什么是linq？然后再来分享实际应用。 说明： LINQ = Language Integrated Query（集成查询语言...
LINQ to SQL语句(19)之ADO.NET与LINQ to SQL
Johnson的专栏
02-17 735
ADO.NET与LINQ to SQL它基于由 ADO.NET 提供程序模型提供的服务。因此，我们可以将 LINQ to SQL 代码与现有的 ADO.NET 应用程序混合在一起，将当前 ADO.NET 解决方案迁移到 LINQ to SQL。 1.连接 在创建 LINQ to SQL DataContext 时，可以提供现有 ADO.NET 连接。对 DataContext 的所
LINQ编程之LINQ to SQL
来了，看看吧...
09-14 5610
最近比较忙，博客更新的比较慢，请大家谅解！ 今天来简单介绍一下LINQ to SQL的知识。（用实例） 什么是LINQ to SQL?        LINQ to SQL是基于关系数据的.NET语言集成查询，用于以对象形式管理关系数据，并提供丰富的查询功能。 下面开始介绍LINQ to SQL的用法，在LINQPad下实现。 实例中用到的表： LINQ to SQL查询所
构建LINQ to SQL类的详细步骤教程
创建LINQ to SQL类的步骤如下： 1. **理解LINQ基础**： - LINQ引入了语言集成查询的概念，使得查询成为C#和Visual Basic语言的核心组成部分。它消除了对不同数据源专用查询语言的学习需求，通过关键字和标准运算符...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值