Decode tables fields before get in linq

Question

0.00/5 (No votes)

See more:

Hi.
I have a table in my project that fields inserted with c# encode before.
but in get mthods we don't handled decoding. some thing like this :

var submitPerson = (from i in db.tSubmitPersons
                                where i.SubmitPersonID == Convert.ToInt32(lblPersonID.Text)
                                select i);

txtOtherLanguages.Text = submitPerson.Single().otherLanguages;

And I have this codes in many pages several times.
Is there any way to decode these fields once some where like trigger?
I want to use decode method once and don't add it in all pages when I use this table if possible.
And I need these fields encoded in tables. no way to decode in sql.
Any idea?
Thanks in advance.

Posted 6-Apr-13 2:31am

arminamini

Add a Solution

Comments

AmitGajjar 6-Apr-13 8:33am

what encoding you have used ?

arminamini 6-Apr-13 8:40am

Something like this :
<pre>
private string EncodeServerName(string ServerName)
{
byte[] NameEncodein = new byte[ServerName.Length];
NameEncodein = System.Text.Encoding.UTF8.GetBytes(ServerName);
string EcodedName = Convert.ToBase64String(NameEncodein);
return EcodedName;
}
</pre>

And I need something like triggers but in linq in c# not in sql side. That I run it before all gets methods in all project parts.
Thanks.

AmitGajjar 6-Apr-13 8:42am

Create extension method that will decode your table information. but you need to apply method on all your query.

arminamini 6-Apr-13 8:45am

aah Thanks. I hoped if exists some thing like trigger in linq!

AmitGajjar 6-Apr-13 8:48am

can you explain what you mean by trigger in linq ? i never heard that.

arminamini 6-Apr-13 8:53am

Something like trigger in sql. For example you can add a function in sql query, and add something to fields while insert,update,select and Delete.
I need add something to my linq class, that if I Select this spcial table, get me decoded fields.
I mean I need add my decode function somewhere like get events if exists, that help me apply it in one place.

AmitGajjar 6-Apr-13 8:58am

ohh yes, then extension method is what you are looking for.

arminamini 6-Apr-13 9:05am

Yes my solution is that if there is any way that I add this method :
public string DecoAndGetServerName(string Servername)
{
System.Text.UTF8Encoding encoder = new System.Text.UTF8Encoding();
System.Text.Decoder strDecoder = encoder.GetDecoder();
byte[] to_DecodeByte = Convert.FromBase64String(Servername);
int charCount = strDecoder.GetCharCount(to_DecodeByte, 0, to_DecodeByte.Length);
char[] decoded_char = new char[charCount];
strDecoder.GetChars(to_DecodeByte, 0, to_DecodeByte.Length, decoded_char,0);
string Name = new string(decoded_char);

return Name;
}

And call it one time, not all times that I get this table by linq.
Once in linq class or somewhere like this that help me use it once.
coz I use this table more than 100 times in many pages and gridviews and ...
its so hard to add this method to all these pages.

AmitGajjar 7-Apr-13 22:42pm

don't you have any general class that inherit in all your forms ? if so, you can add method in that class and use everywhere.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Decode tables fields before get in linq

Add your solution here

Preview 0

Decode tables fields before get in linq

Add your solution here

Preview 0

Existing Members

...or Join us