January 30, 2008
@ 11:21 PM
Comments [17]
LINQ to SQL ( DataContext.Log )
Linq to Sql de veritabanı sunucusuna giden sorguları SQL Profiler ile izleriz. Fakat daha kolay bir yol var. Aşağıdaki resim gayet açıklayıcı ;)
Tek yapmamız gereken DataContext türünden nesnemizin Log özelliğine istediğimiz çıktıyı vermek olacaktır.



Eğer kodumuzu aşağıdaki gibi düzenlersek bu defa da üretilen T-SQL istediğimiz herhangi bir fiziksel dosyaya kaydedilecektir.

testDataContext db = new 
db.Log = new StreamWriter("C:\\l2s.log");

var v = from p in db.Persons
        where p.Surname == "asma"
        select p.Name;

Text = v.First();
db.Log.Close();
l2s.log dosyasının içeriği aşağıdaki gibidir.

SELECT TOP (1) [t0].[Name]
FROM [dbo].[Person] AS [t0]
WHERE [t0].[Surname] = @p0
-- @p0: Input NVarChar (Size = 4; Prec = 0; Scale = 0) [asma]
-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.21022.8

 
Categories: .NET | C# | Code | Inceleme

« Yine Güzel Bir Seminer Daha Gerçekleşti | Home | Linq To Sql Left Outer Join »
Friday, October 16, 2009 8:15:57 AM (GTB Daylight Time, UTC+03:00)
<h2 align="center">Costs For Uggs--What It Costs?</h2>
<p>--&gt;Are you lusting after a few (or even more) <a href="http://www.goodugg.co.uk/ugg-classic-cardy-c-161.html">Ugg boots</a> and if so, you're in good company, as girls and women of all ages, especially with the simple, slipper-like design of these sheepskin <a href="http://www.goodugg.co.uk/grey-ugg-boots-5819-classic-cardy-p-23458.html">ugg boots sale </a>, which are relatively easy and very comfortable to wear. And they appear to be affected. Some men are also jumping on the trend and luxury UGGs? Australia, the brand also offers a range of contemporary styles for them.</p>
<p>--&gt;Could you mind giving everyone loves from <a href="http://www.goodugg.co.uk/ugg-classic-tall-c-162.html">ugg classic </a>? There are so many types of uggs, <a href="http://www.goodugg.co.uk/ugg-bailey-button-c-178.html?zenid=847c0f495b87cb43928dcc19d09f4019">ugg bailey button</a>,ugg <a href="http://www.goodugg.co.uk/ugg-classic-tall-c-162.html">classic tall</a>, ugg <a href="http://www.goodugg.co.uk/ugg-classic-short-c-160.html">classic short</a>, ugg <a href="http://www.goodugg.co.uk/ugg-classic-cardy-c-161.html">classic cardy</a>. How to choose your favorite? Or do you really want to one uggs regardless its style? Despite their design is awkward and slipper-lile, <a href="http://www.goodugg.co.uk/">Uggs</a> is one of the few stations that are of general interest, have argued that cross generational lines.</p>
<p>--&gt;Young people, students and young mothers and the Middle Ages, the original Black <a href="http://www.goodugg.co.uk/ugg-ultra-tall-c-167.html">Ultra Tall UGG Boots</a>, seem pulled the fleecy-lined boots that are manufactured in Australia, with the best materials. Are you sure that your feet warm in winter without socks, and cool in summer so that is more versatile too? If no, hurry up to take one <strong>ugg boots </strong>on <a href="http://www.goodugg.co.uk/ugg-classic-tall-c-162.html">uggs on sale</a> ! That's why we see people wear them in schools, supermarkets, on the slopes and even in the most popular beaches in the United States and abroad. Many surfers also use uggs to keep their feet warm.</p>
<p>--&gt;What do you really care about? Is its price or quality, or you just following the general trend? You know what are you thinking in your heart!</p>
angelia110 | sharing_09AT NOSPAMhotmail dot com
Saturday, October 24, 2009 3:42:35 PM (GTB Daylight Time, UTC+03:00)
why the ugg bailey<strong> <a href="http://www.linkboots.com/ugg-womens-knightsbridge-c-50.html">ugg knightsbridge sale</a> </strong>button boot is so popular? as we known,<strong><a href="http://www.linkboots.com/ugg-womens-knightsbridge-c-50.html">ugg knightsbridge boots</a></strong> have morphed together their two most popular styles. they started with the ever-popular <strong><a href="http://www.linkboots.com/ugg-womens-knightsbridge-c-50.html">ugg knightsbridge sand</a></strong> and then added a wooden <strong><a href="http://www.linkboots.com/ugg-classic-cardy-5819-c-26.html">classic cardy uggs grey</a></strong> from their best-selling, as seen on oprah, uggcardy. they are one pop-fusion<strong> <a href="http://www.linkboots.com/ugg-womens-knightsbridge-c-50.html">ugg knightsbridge black</a></strong>. when the new fall step into our life this year, <strong><a href="http://www.linkboots.com/ugg-womens-knightsbridge-c-50.html">ugg knightsbridge on sale</a></strong> are beginning search for an footwear going together with their jeans. now you are reaching to the every <strong><a href="http://www.linkboots.com/ugg-classic-cardy-5819-c-26.html">classic cardy ugg australia</a></strong> for the latest fashion trend. in past two or<A href="http://www.thegoodboots.com/specials.html" target="_blank"><strong> </strong></A>three years, the <strong><a href="http://www.linkboots.com/ugg-classic-cardy-5819-c-26.html">classic cardy uggs on sale</a></strong> kept women, men and kids <strong><a href="http://www.linkboots.com/ugg-womens-knightsbridge-c-50.html">ugg knightsbridge boot</a></strong> salewarm and cozy under its super-popular fashion. <strong><a href="http://www.linkboots.com/ugg-womens-knightsbridge-c-50.html">ugg knightsbridge chestnu</a></strong><a href="http://www.linkboots.com/ugg-womens-knightsbridge-c-50.html">t</a> the new fall in 2009, we get<strong> <a href="http://www.linkboots.com/ugg-womens-knightsbridge-c-50.html">ugg knightsbridge uk</a></strong>. the <strong><a href="http://www.linkboots.com/ugg-womens-knightsbridge-c-50.html">knightsbridge uggs</a></strong> become the first choice for ugg follower<strong> <a href="http://www.linkboots.com/ugg-womens-knightsbridge-c-50.html">ugg knightsbridge ugg boots</a> </strong>and getting hotter and hotter. the <strong><a href="http://www.linkboots.com/ugg-womens-knightsbridge-c-50.html">ugg knightsbridge uggs on sale</a> </strong>style c the bailey button has become a must have this winter. now<strong> <a href="http://www.linkboots.com/ugg-bailey-button-5803-c-30.html">ugg australia bailey button</a> </strong>there are 5 colors available in 5 colors including black, chestnut, grey, chocolate and sand on<strong> <a href="http://www.linkboots.com/ugg-bailey-button-5803-c-30.html">ugg australia bailey button boot</a></strong>. we provide enough stock for this fall and winter. you <A href="http://www.thegoodboots.com/ugg-classic-cardy-c-2.html" target="_blank"><strong>ugg shoes </strong></A>wil enjoy shopping anytime before this <strong><a href="http://www.linkboots.com/ugg-bailey-button-5803-c-30.html">ugg boots bailey button</a></strong>. anyway, the popular classic styles including <strong><a href="http://www.linkboots.com/ugg-bailey-button-5803-c-30.html">bailey button grey uggs</a></strong>, ugg boot short (5825) and<a href="http://www.linkboots.com/ugg-classic-cardy-5819-c-26.html"> <strong>classic cardy ugg boots</strong></a><strong></strong> are all your choices. tags ?
uggboots | linkbootsAT NOSPAMbazargo dot com
Sunday, November 01, 2009 3:07:51 AM (GTB Standard Time, UTC+02:00)
Thanks for article. Everytime like to read you.
ugg boots | siliAT NOSPAM163 dot com
Friday, November 06, 2009 3:24:51 AM (GTB Standard Time, UTC+02:00)
Do you want to buy some sheepskin boots, please come to www.findugg.com.Full range of UGG boots for Men and Women to buy online. Fast and free shipping to worldwide, competitive price, high quality, and efficient service.

Read more:http://www.findugg.com
findugg | finduggAT NOSPAMsina dot com
Wednesday, November 11, 2009 11:23:27 AM (GTB Standard Time, UTC+02:00)
Nowadays,UGG Classic Cardy Boots is a tall-styled boots (14.5 inches), designed for comfort, style and durability. While many colors are available, choose a darker, neutral-toned hue for versatile outfitting (such as black and gray). Additionally, darker colors will mask dirt more efficiently than the lighter Cardy shades.
Secondly,choose a size smaller than your usual boot size. According to the Ugg manufacturer, Classic Cardy Boots runs a whole size larger. They suggest you order a full size and a half smaller if you are between shoe sizes. It’s best to try the Ugg boots on at a reputable store (such as Nordstrom) before <A HREF="http://www.uggbootshare.com/ugg-classic-cardy-c-1.html">Ugg Classic Cardy 5819</A>
<A HREF="http://www.uggbootshare.com/ugg-classic-short-c-2.html">Ugg Classic Short 5825</A>purchasing. <A HREF="http://www.uggbootshare.com/ugg-classic-tall-c-3.html">Ugg Classic Tall 5815</A>
<A HREF="http://www.uggbootshare.com/ugg-classic-mini-c-4.html">Ugg Classic Mini 5854</A>Ensure the boots fit snugly around the foot, without feeling uncomfortable.
Last,Boycott the socks. Ugg Classic Cardy Boots are designed to be worn barefoot. Relish in foot comfort and softness while running errands or attending class. The authentic boots <A HREF="http://www.uggbootshare.com/ugg-classic-tall-metalli-c-5.html">Ugg Classic Classic Metalli 5812</A>
<A HREF="http://www.uggbootshare.com/ugg-australia-tall-c-6.html">Ugg Australia Tall 5818</A>
<A HREF="http://www.uggbootshare.com/ugg-classic-crochet-short-c-7.html">Ugg Classic Crochet Short 5833</A>
<A HREF="http://www.uggbootshare.com/ugg-bailey-button-c-8.html">Ugg Bailey Button 5803</A>
<A HREF="http://www.uggbootshare.com/ugg-paisley-classic-short-c-9.html">Ugg Paisley Classic Short 5831</A>
<A HREF="http://www.uggbootshare.com/ugg-knightsbridge-c-10.html">Ugg Knightsbridge 5119</A>
<A HREF="http://www.uggbootshare.com/ugg-nightfall-c-11.html">Ugg Nightfall 5359</A>
<A HREF="http://www.uggbootshare.com/ugg-ultra-tall-c-12.html">Ugg Ultra Tall 5245</A>
<A HREF="http://www.uggbootshare.com/ugg-ultra-short-c-13.html">Ugg Ultra Short 5225</A>
<A HREF="http://www.uggbootshare.com/ugg-lo-pro-button-c-14.html">Ugg Lo Pro Button 5691</A>
<A HREF="http://www.uggbootshare.com/ugg-lo-pro-classic-tall-c-15.html">Ugg Lo Pro Classic Tall 5715</A>
<A HREF="http://www.uggbootshare.com/ugg-sundance-ii-c-16.html">Ugg Sundance II 5325</A>
<A HREF="http://www.uggbootshare.com/ugg-coquette-slipper-c-17.html">Ugg Coquette Slipper 5125</A>
<A HREF="http://www.uggbootshare.com/ugg-sunburst-tall-c-18.html">Ugg Sunburst Tall 5218</A>
<A HREF="http://www.uggbootshare.com/ugg-tall-stripe-cable-knit-c-19.html">Ugg Tall Stripe Cable Knit 5822</A>
<A HREF="http://www.uggbootshare.com/ugg-classic-argyle-knit-c-20.html">Ugg Classic Argyle Knit 5879</A>
<A HREF="http://www.uggbootshare.com/ugg-fluff-flip-flop-c-21.html">Ugg Fluff Flip Flop 5304</A>
<A HREF="http://www.uggbootshare.com/ugg-classic-tall-romantic-flower-pink-5802-p-88.html">Ugg Classic Tall Romantic Flower Pink 5802
</A>
<A HREF="http://www.uggbootshare.com/ugg-metallic-classic-short-c-23.html">Ugg Metallic Classic Short 5842</A>
<A HREF="http://www.uggbootshare.com/ugg-classic-tall-baroque-c-24.html">Ugg Classic Tall Baroque 5852</A>
<A HREF="http://www.uggbootshare.com/ugg-sundance-limited-edition-chestnut-5728-p-96.html">Ugg Sundance Limited Edition Chestnut 5728</A>
<A HREF="http://www.uggbootshare.com/ugg-ultra-short-le-chestnut-5118-p-97.html">Ugg Ultra Short Le Chestnut 5118
</A>
<A HREF="http://www.uggbootshare.com/ugg-kids-classic-tall-c-27.html">Ugg Classic Tall 5815</A>sockliner inside the boot pulls moisture, such as sweat, away from the skin’s surface, keeping feet smooth, dry and odor-free.
Today, if you own a pair of this Ugg Cardy boots, you will take many benefits from them. So, own one will bring you good moods.
Classic Tall Ugg Boots on sale | aieAT NOSPAMyahoo dot com
Saturday, November 14, 2009 12:30:14 PM (GTB Standard Time, UTC+02:00)
<a href="http://www.selluggsboots.com/classic-tall-ugg-boots-c-5.html" target="_parent"><strong>Classic Tall Ugg Boots</strong></a> on sale!,We are professional supply <a href="http://www.selluggsboots.com/ugg-bailey-button-c-21.html" target="_parent"><strong>Ugg bailey button </strong></a> ,<a href="http://www.selluggsboots.com/classic-short-ugg-boots-c-2.html" target="_parent"><strong>Ugg classic short boots </strong></a>is your best choice,free shipping and nontax,only need 1 week to your door!
Uggs Boots On Sale | selluggsbootsAT NOSPAMhotmail dot com
Saturday, November 21, 2009 2:54:09 PM (GTB Standard Time, UTC+02:00)
Do you want to buy some <a href="http://www.findugg.com/products_all.html">sheepskin boot</a>,come to <a href="http://www.findugg.com/">www.findugg.com</a>.Full range of UGG boots for Men&<a href="http://www.findugg.com/ugg-womens-c-17.html">women</a>to buy online. Fast and free shipping to worldwide, competitive price, high quality, and efficient service.

Read more:http://www.findugg.com or http://www.bootshotsale.com
Cheap UGG Boots | finduggAT NOSPAMsina dot com
Tuesday, November 24, 2009 5:51:22 AM (GTB Standard Time, UTC+02:00)
if you want to buy<A href="http://www.uggou.com">ugg boots sales<A>
<A href="http://www.uggou.com">ugg boots sale</A>
<A href="http://www.uggou.com/ugg-sundance-c-7.html">ugg boot sales</A>
<A href="http://www.uggou.com/ugg-classic-short-c-6.html">ugg boot sale</A>

[url=http://www.uggou.com]ugg boots sales[/url]
[url=http://www.uggou.com]ugg boots sale[/url]
[url=http://www.uggou.com]ugg boot sales[/url]
[url=http://www.uggou.com]ugg boot sale[/url]

We supply ugg boots good quality.100% Free Shipping + No sales Tax! Quick Delivery! Come and join us!
link:http://www.uggou.com/
ugg boots sales | 123AT NOSPAM123 dot com
Friday, November 27, 2009 3:49:43 AM (GTB Standard Time, UTC+02:00)
Nice post, thanks you. I'm a diabetic with poor circulation and so my toes almost never warm up.. I ordered these [url=http://www.buddyugg.com/]ugg classic cardy boots[/url] hoping they would help and they did the job pretty well. The inside is very plush, my feet even feel close to sweating when the air con is up and the house is warm. The upper is a little tight, I wouldn't recommend these [url=http://www.buddyugg.com/]ugg classic cardy boots[/url] for larger people.[url=http://www.buddyugg.com/]Uggs boots on sale[/url], free shipping, LOL!
uggs boots on sale | panAT NOSPAMyahoo dot cn
Sunday, November 29, 2009 8:15:27 AM (GTB Standard Time, UTC+02:00)
Ugg classic Short most people around the world accepted by the whole. Ugg short are fashionable, give your feet a warm feeling. Discount ugg boots at inexpensive prices, many people can choose their favorite boots, I believe your choice is good. http://www.elegantugg.com/ugg-classic-short-c-1.html
ugg short | erye0002AT NOSPAMsina dot com
Monday, November 30, 2009 5:50:44 PM (GTB Standard Time, UTC+02:00)


<a href="http://www.mytobling.com/ugg-ultra-short-boots-c-

42.html"><strong>ugg ultra short</strong></a>-wonderful to work

with! Top of the line service! Thanks!
Nice <a href="http://www.mytobling.com/ugg-ultra-tall-boots-c-

43.html"><strong>ugg ultra tall</strong></a>, but a bit tight-seller

responsive and friendly, easy transaction.
werwe | qwrewqfAT NOSPAMyahoo dot com
Tuesday, December 01, 2009 1:13:00 PM (GTB Standard Time, UTC+02:00)
http://www.uggonsale.org Uggs Classic tall | Ugg Bailey Button | Ugg Nightfall | Ugg 30th anniversary
http://www.jordanshoesdiy.org Air Jordan online store | Nike Air Jordan | Michael Jordan Shoes | Air Jordan Sneakers
http://www.sell-nfl-jerseys.com Cheap NHL Jerseys | NFL Jerseys China | Reebok NFL Jerseys | Reebok Football Jerseys
http://www.ghdforsale.org GHD | GHDS | GHD Hair Straighteners | Ghd Hair Products
http://www.likeshoes.com Cheap cartier glasses | Cartier Glasses | True Religion Jeans | Women Boots
http://www.jerseystime.com Cheap NFL Jersey | wholesale nhl jerseys china | authentic nhl jerseys china
uggs | loginfashionAT NOSPAM163 dot com
Thursday, December 03, 2009 9:54:49 AM (GTB Standard Time, UTC+02:00)
<p>UGG boots for sale,you can choose UGGS online,the officl <a href="http://www.souggs.com/conditions.html"><strong>ugg outlets</strong></a> online,find UGG fashion ,all UGGS boots are free shipping,australia ugg,,ugg outlet,ugg australia,you can choose the <a href="http://www.souggs.com/ugg-bailey-button-c-24.html"><strong>UGG Bailey Button</strong></a>,UGG Classic Cardy,UGG Classic Tall,andd UGG Classic Short,pick <a href="http://www.souggs.com/discount_coupon.html"><strong>discount ugg boots</strong></a> on www.souggs.com now. </p>
ugg cardy | souggsAT NOSPAMyahoo dot com
Wednesday, December 23, 2009 12:04:12 PM (GTB Standard Time, UTC+02:00)
welcome to http://www.bellbest.com.
We sit the right inscription are: High Quality + Brand New + Quick Shipping + Secure Payment
our sell <a href="http://www.bellbest.com/">Nike shoes</a>,<a href="http://www.bellbest.com/">Adidas shoes</a>,<a href="http://www.bellbest.com/">Puma shoes</a>,<a href="http://www.bellbest.com/">Supra shoes</a>,<a href="http://www.bellbest.com/">Ugg shoes</a>,Air force shoes, Jordan max , Jordan mix Air force UGG, ED Hardy, CA, Air max 87, max 90, max 95, max 97, max 2003, max LTD, Nike shox R4, Shox TL3, Shox NZ, Shox MOSTER, Shox TUROB, Shox R3, Gucci, TN shoes, Puma shoes, Prada , Lacoste, Timberland shoes.
alinkes | alinkesAT NOSPAMgmail dot com
Wednesday, December 23, 2009 12:04:40 PM (GTB Standard Time, UTC+02:00)
Nike each kind of shoe, has everything expected to find:www.bellbestnike.com
Newest Nike athletic shoes, walking shoe, track shoes, sandals. High shoes, low shoes
2009 for a new model,originals,So fashion,more product form bellbestnike.com
welcome viste our website
http://www.bellbestnike.com
<a href="http://www.bellbestnike.com/">nike shoes</a>
<a href="http://www.bellbestnike.com/">nike shox</a>
<a href="http://www.bellbestnike.com/">Nike Kobe Bryant</a>
<a href="http://www.bellbestnike.com/">nike air max</a>
nike air force 1 what does nike stand for nike ankle supports nike golf nikes nike air
force one custom nike shoes nike uptown sneakers nike uptowns nike commercials nike site
nike running shoes what does the word nike mean nike sandals nike golf clubs nike soccer
ball nike swoosh nike air jordan nike outlet nike outlet stores nike sb blazer who
designed the nike logo nike football nike company code of ethics nike cortez nike
sneakers sale nike sb dunks nike symbol nike ads nike blazers nike swimwear
alinkes | alinkesAT NOSPAMgmail dot com
Wednesday, December 23, 2009 12:05:12 PM (GTB Standard Time, UTC+02:00)
Offer all kinds of different brand name product in high quality with their original packing unless otherwise noted.
target=_blank>http://www.bellbestpuma.com

bellbestpuma.com products include:
shoes, <a href="http://www.bellbestpuma.com/">Puma shoes</a>, <a href="http://www.bellbestpuma.com/">Puma basketball shoes</a>, <a href="http://www.bellbestpuma.com/">Puma sneakers</a>,puma tennis shoes, black puma shoes, puma baseball shoes, newest puma shoes, latest puma shoes, wholesale puma shoes, puma running shoes, puma athletic shoe, youth soccer shoes, new football shoes] walking shoes, bowling shoes, track shoes,
http://www.bellbestpuma.com
cheap shoes | alinkesAT NOSPAMgmail dot com
Wednesday, December 23, 2009 12:05:49 PM (GTB Standard Time, UTC+02:00)
A good shoe may better protect your foot! Some not good shoe, will often put on will have been smelly, as well as the crack falls! Our company from China! The quality aspect has our special personnel check! Lets enjoyable which you use! We have each kind of attractive shoe. Company's website daily is also renewing the most new style shoe. Each kind of brand, has everything expected to find. Because our company uses the meager profit but high turnover the way, therefore our company's shoe can probably be cheaper than other shoes!
http://www.baysneaker.com
http://www.bytohere.com
http://www.bellbestsupra.com
lttyyp | zzc010837AT NOSPAMyahoo dot com
Name
E-mail
Home page

Comment (HTML not allowed)  

Enter the code shown (prevents robots):
Live Comment Preview