kendime notlar (notes to myself)

linq - Row not found or changed

Gönderen pantepember 16 Şubat 2011 Çarşamba

trouble:

var daskTeklif = _context.tblDaskTeklifs.SingleOrDefault(dt => dt.teklif_id == TeklifTkID);
daskTeklif.SirketPoliceNo = policeNo;
_context.SubmitChanges();

throws an exception: System.Data.Linq.ChangeConflictException: Row not found or changed.

solution:

creating a new datacontext:

var context = new DataClassesDataContext();
daskTeklif = context.tblDaskTeklifs.SingleOrDefault(dt => dt.teklif_id == TeklifTkID);
daskTeklif.sirketPoliceNo = policeNo;
context.SubmitChanges();

cycle error on cloning linq object

Gönderen pantepember 24 Ocak 2011 Pazartesi

error: "Object graph for type 'TestLinq.PersonAddress' contains cycles and cannot be serialized if reference tracking is disabled.”

solution: change the 'Serialization Mode' to 'Unidirectional'.

source: http://stackoverflow.com/questions/1432501/clone-linq-object-error-object-graph-for-type-testlinq-personaddress-contains

clone linq object

Gönderen pantepember

///

/// Clones any object and returns the new cloned object.
///

/// The type of object.
///
The original object./// The clone of the object.
public static T Clone(T source)
{
var dcs = new DataContractSerializer(typeof(T));
using (var ms = new System.IO.MemoryStream())
{
dcs.WriteObject(ms, source);
ms.Seek(0, System.IO.SeekOrigin.Begin);
return (T)dcs.ReadObject(ms);
}
}

source:http://stackoverflow.com/questions/2178080/linq-to-sql-copy-original-entity-to-new-one-and-save

session killer script

Gönderen pantepember 20 Kasım 2010 Cumartesi

this one line of script is a killer of asp.net session on ie 7, 8, and 9 browsers (maybe ie6, i didn't test it):

$(document).ready(function() {
// for remembering the selected tabs
$("div[id*='tabs']").tabs({ cookie: { expires: 999, name: this.id }, cache: false, collapsible: true });
}

script'i 2 parça halinde yazmak buna neden oluyor.

// // for remembering the selected tabs
   // $("div[id*='tabs']").tabs({ cookie: { expires: 999, name: this.id }, cache: false, collapsible: true });

   // fade effect
   $("div[id*='tabs']").tabs({
   fx: {
   opacity: 'toggle',
   duration: 'fast'
   },
   cookie: { expires: 999, name: this.id }, cache: false, collapsible: true
   });

t-sql find object references

Gönderen pantepember 26 Ekim 2010 Salı

select object_name(object_id), OBJECT_DEFINITION(object_id)
from sys.objects
where OBJECT_DEFINITION(object_id) like '%CDS%' and type='P'

örn: ProductId alanının kullanıldığı sp'ler.

streamreader encoding

Gönderen pantepember 23 Ekim 2010 Cumartesi

sorun: doğru encoding verilmezse türkçe karakterler okunamıyor.

çözüm:
StreamReader sr = new StreamReader("ornek.txt", Encoding.GetEncoding("windows-1254"));
textBox1.Text = sr.ReadToEnd();

Value cannot be null. Parameter name: name

Gönderen pantepember 24 Eylül 2010 Cuma

add web reference ile web service eklenirken, veya web service çalıştırılırken, dbml'in güncel olmaması nedeniyle bulunamayan nesneler (stored procedure vb.) bu hataya neden olabiliyor.

indexed view with schemabinding

Gönderen pantepember 15 Eylül 2010 Çarşamba

ALTER VIEW [dbo].[Vw_View1] WITH SCHEMABINDING AS
SELECT ...
FROM ...

CREATE UNIQUE CLUSTERED INDEX [IX_Index1] ON [dbo].[Vw_View1]
(
[Column1] ASC
)
GO

related errors:
Cannot create index on view because the view is not schema bound.

http://www.mssqltips.com/tip.asp?tip=1610

checkboxlist prerender

Gönderen pantepember 14 Eylül 2010 Salı

protected void cblDilekceTipi_PreRender(object sender, EventArgs e)
{
foreach (ListItem item in cblDilekceTipi.Items)
{
item.Text = item.Text.Replace(" Dilekçesi", "");
}
}

ie6 background image