9eFish

DB

1
顶

顶

ADO.NET team blog : POCO Proxies Part 1

由

admin 发表于 66 天, 8 小时, 35 分钟之前

POCO Proxies Part 1Published 22 December 09 09:52 AM | dpblogs The Entity Framework (EF) in .NET 4.0 introduces the ability to interact with entities with persistence ignorance (POCOs). While this favors separation of concerns, it also means that the entities will do less because they cannot talk directly to the data access layer. Another new concept in EF 4.0 is the idea of dynamically generated proxies for such entities. Opting into proxies is an easy way to get additional capabilities like lazy lo... (more)

类别: DB | 点击: 0 | 评论 | | 源: blogs.msdn.com

标签: EF, Poco

1
顶

顶

How Do I Choose a Data Provider?

由

xgluxv 发表于 80 天, 7 小时, 18 分钟之前

As you've seen earlier there are many data providers available in ADO.NET. There may be cases when you can access a data source using more than one data provider. Now the question arises: which one is better? What are the selection criteria? The main criterion of selection is performance and multiple data source connectivity. In brief, to work with SQL server 7 or later and MSDE databases, Sql data provider is the best choice. The Sql data provider bypasses many layers and directly connects to the int... (more)

类别: DB | 点击: 0 | 评论 | | 源: www.c-sharpcorner.com

标签: ado.net

1
顶

顶

Agile Entity Framework 4 Repository: Part 1- Model and POCO Classes : Don't Be Iffy

由

xgluxv 发表于 112 天, 6 小时, 40 分钟之前

Agile Entity Framework 4 Repository: Part 1- Model and POCO Classes : Don't Be Iffy

I’m going to lay out this out in a few blog posts because it’s complex. As I am not a TDD developer, I won’t be starting from the tests. I’m doing this in a fashion which is logical to me. But that will mean you’ll get some teasers along the way that will be fleshed out further down the road. I should be working on my 2nd Edition of Programming Entity Framework, but it’s driving me crazy that this information is so hard to find even though I’ve been doing conference and live meeting presentations on it.... (more)

类别: DB | 点击: 3 | 评论 | | 源: thedatafarm.com

标签: EF, Poco

1
顶

顶

使用Linq to Sql 或者 EF加快数据访问速度

由

admin 发表于 135 天, 7 分钟之前

Speeding up data access by using Linq to SQL or EF 26 Oct, 2009 LINQ, c#, entity framwork, sql Recall that LINQ based object relational mappers (ORM) use expression trees to effectively translate your C# (or other language) LINQ code into SQL. Many DBA’s and developers that don’t fully understand this technology are often quick to discredit it. I’m going to show how significant performance, simplicity, and clarity can be gained by using Linq to SQL. A recent DBA asked me the question ... (more)

类别: DB | 点击: 0 | 评论 | | 源: www.ytechie.com

标签: LINQ to SQL

1
顶

顶

SET NOCOUNT (Transact-SQL)

由

carolhaozi 发表于 178 天, 20 小时, 28 分钟之前

Introduction Whenever we write any procedure and execute it a message appears in message window that shows no of rows affected with the statement written in the procedure and we become very happy to see that our procedure is working. But do you know that this message creates an extra overhead on the network? Yes it does. By removing this extra overhead from the network, we can actually improve the performance of our database and our application. How should we do it? (more)

类别: DB | 点击: 0 | 评论 | | 源: www.dotnetfunda.com

标签: SET NOCOUNT, sql

1
顶

顶

Restore MS SQL Server database from within your application(s) - Wilson Kutegeka

由

carolhaozi 发表于 185 天, 17 小时, 20 分钟之前

Restore MS SQL Server database from within your application(s) - Wilson Kutegeka

Restore MS SQL Server database from within your application(s) Introduction This post is a follow-up of my previous post; Backup MS SQL Server database from within your application(s). It presents a simple way in which you could incorporate a restore tool from with in your application. Simply download the source code with the restore form that you need to just add into your application Key Methods include LoadServers; this method loads all local servers ''' ''' PrivateSub LoadSe... (more)

类别: DB | 点击: 0 | 评论 | | 源: bloggingabout.net

1
顶

顶

Carsonified » Speed up your Web App by 1000% with 1 Line of SQL

由

carolhaozi 发表于 185 天, 17 小时, 21 分钟之前

Carsonified » Speed up your Web App by 1000% with 1 Line of SQL

Frameworks have changed the way we develop web applications and many amazing products and services have been delivered as a result. As developers we take these [frameworks] for granted, they help abstract a lot of the day to day leg work of our applications, and help us develop features more quickly. (more)

类别: DB | 点击: 0 | 评论 | | 源: carsonified.com

标签: sql

1
顶

顶

Mark Brown's Web Platform Blog : SQL Server 2008 Developer Training Kit Available

由

carolhaozi 发表于 290 天, 7 小时, 26 分钟之前

Mark Brown's Web Platform Blog : SQL Server 2008 Developer Training Kit Available

SQL Server 2008 Developer Training Kit Available SQL Server 2008 offers an impressive array of capabilities for developers that build upon key innovations introduced in SQL Server 2005. The SQL Server 2008 Developer Training Kit will help you understand how to build web applications which deeply exploit the rich data types, programming models and new development paradigms in SQL Server 2008. The training kit is brought to you by Microsoft Developer and Platform Evangelism. Overview and Benefits Th... (more)

类别: DB | 点击: 0 | 评论 | | 源: blogs.msdn.com

标签: Sql Server 2008, Training Kit

1
顶

顶

监控sql server的性能: Quickie Edition

由

xgluxv 发表于 316 天, 8 小时, 22 分钟之前

« Automated SQL Server Backup: Poor Man’s EditionMonitoring SQL Server Performance: Quickie Edition Posted by MarlonRibunal on April 28, 2009 There are various mechanisms to measure the performance of your SQL Server. An efficient way to do it is through digging in with Performance Monitor. But how about if you only need a quick and dirty way of monitoring your SQL Server right now? There are built-in functions for that one. Take a look at this quickie: SELECT @@total_readAS'Total Read', @@to... (more)

类别: DB | 点击: 1 | 评论 | | 源: dbalink.wordpress.com

标签: monitoring, performance, Sql Server

1
顶

顶

LINQ to SQL快速上手 step by step

由

dotlive 发表于 324 天, 17 小时, 40 分钟之前

最近接连遇到几个朋友问我同一个问题，就是关于.NET平台上ORM框架的选择。我想在这个讲求效率的时代，谁也不想手写SQL或存储过程去访问数据库了。大家都知道，在Java平台上，ORM这一块基本是Hibernate的天下。当然，相对轻量级的iBatis也有不错的表现。不过谈到.NET平台，ORM框架似乎相对混乱了点。很多朋友问我的时候，往往会这样问：NHibernate、NBear和Castle该选择哪个？而当我反问：为什么不适用微软自带的Linq to Sql呢？对方经常会迷茫和不解 (more)

类别: DB | 点击: 4 | 评论 | | 源: www.cnblogs.com

标签: LINQ to SQL, step by step

1
顶

顶

Less Than Dot - Blog -复制SQL Server数据库

由

xgluxv 发表于 330 天, 19 小时, 41 分钟之前

Copy SQL Server Databaseby onpnt 13 Apr 2009 07:13 , Categories: Microsoft SQL Server Admin With the type of databases that can be set to nightly or even weekly recovery points, the copy database task is ideal and a quick way to setup you DR services. Many times the copy database task is overlooked for tasks such as disaster/recovery and test or development resources. This task available is very useful for databases that primarily hold meta data or are relatively small in size. The company I am ... (more)

类别: DB | 点击: 0 | 评论 | | 源: blogs.lessthandot.com

标签: Sql Servce

1
顶

顶

SQL SERVER - Introduction to JOINs - Basic of JOINs « Journey to SQL Authority with Pinal Dave

由

dotlive 发表于 333 天, 5 小时, 10 分钟之前

SQL SERVER - Introduction to JOINs - Basic of JOINs « Journey to SQL Authority with Pinal Dave

The launch of Gandhinagar SQL Server User Group was a tremendous, astonishing success! It was overwhelming to see a large gathering of enthusiasts looking up to me (I was the Key Speaker) eager to enhance their knowledge and participate in some brainstorming discussions. Some members of User Group had requested me to write a simple article on JOINS elucidating its different types. Download SQL Script used throughout in this article to practice along. Now, take a quick look at the following two tables I... (more)

类别: DB | 点击: 0 | 评论 | | 源: blog.sqlauthority.com

标签: Join, Sql Server

1
顶

顶

InfoQ: 关系型的云呼之欲出

由

admin 发表于 352 天, 8 小时, 26 分钟之前

微软的高级项目经理Dave Robinson报告说，微软计划加快发布核心关系数据库特性的速度，将其作为Azure的SQL Data Services的一部分 (more)

类别: DB | 点击: 0 | 评论 | | 源: www.infoq.com

标签: CLOUD, 云计算，关系型数据库，Azure

欢迎光临本网站

DB