E10: Using SqlMethods.Like in Method Directive

Yahoo Archive
1
After more “Googling”, I found StartsWith.





Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:aed850.png@2366d12a.4480c4ba]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, December 22, 2014 2:19 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E10: Using SqlMethods.Like in Method Directive



I did not. I suspect where I would create that in Visual Studio that I would have no issues but I was hoping to get this to work from within a method directive directly.





Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:aa0973.png@1dc6cb82.42974fc5]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, December 22, 2014 12:16 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: E10: Using SqlMethods.Like in Method Directive



Did you try using that method through an external assembly?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, December 22, 2014 11:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] E10: Using SqlMethods.Like in Method Directive



Hello,

I am trying to use SqlMethods.Like in a Linq statement.
From a quick Google search, I found this as the solution for trying to replicate a SQL LIKE statement.

It looks like in order to use this class, I need to add the System.Data.Linq Assembly (which I would have thought was already added) and then add “using System.Data.Linq.SqlClient”.
The problem is, I can’t seem to be able to add Standard Assemblies to my method directive for Customer.Update.

Any ideas of what I am missing or maybe another way to replicate LIKE?




Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:819c4c.png@4df8dacb.49b1c76c]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



[Non-text portions of this message have been removed]


[Non-text portions of this message have been removed]


[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
2
Hello,

I am trying to use SqlMethods.Like in a Linq statement.
From a quick Google search, I found this as the solution for trying to replicate a SQL LIKE statement.

It looks like in order to use this class, I need to add the System.Data.Linq Assembly (which I would have thought was already added) and then add “using System.Data.Linq.SqlClient”.
The problem is, I can’t seem to be able to add Standard Assemblies to my method directive for Customer.Update.

Any ideas of what I am missing or maybe another way to replicate LIKE?




Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:819c4c.png@4df8dacb.49b1c76c]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.




[Non-text portions of this message have been removed]
3
Did you try using that method through an external assembly?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, December 22, 2014 11:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] E10: Using SqlMethods.Like in Method Directive



Hello,

I am trying to use SqlMethods.Like in a Linq statement.
From a quick Google search, I found this as the solution for trying to replicate a SQL LIKE statement.

It looks like in order to use this class, I need to add the System.Data.Linq Assembly (which I would have thought was already added) and then add “using System.Data.Linq.SqlClient”.
The problem is, I can’t seem to be able to add Standard Assemblies to my method directive for Customer.Update.

Any ideas of what I am missing or maybe another way to replicate LIKE?




Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:819c4c.png@4df8dacb.49b1c76c]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
4
I did not. I suspect where I would create that in Visual Studio that I would have no issues but I was hoping to get this to work from within a method directive directly.





Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:aa0973.png@1dc6cb82.42974fc5]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, December 22, 2014 12:16 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: E10: Using SqlMethods.Like in Method Directive



Did you try using that method through an external assembly?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, December 22, 2014 11:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] E10: Using SqlMethods.Like in Method Directive



Hello,

I am trying to use SqlMethods.Like in a Linq statement.
From a quick Google search, I found this as the solution for trying to replicate a SQL LIKE statement.

It looks like in order to use this class, I need to add the System.Data.Linq Assembly (which I would have thought was already added) and then add “using System.Data.Linq.SqlClient”.
The problem is, I can’t seem to be able to add Standard Assemblies to my method directive for Customer.Update.

Any ideas of what I am missing or maybe another way to replicate LIKE?




Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191

addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring

[cid:819c4c.png@4df8dacb.49b1c76c]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.



[Non-text portions of this message have been removed]


[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]